Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: snapreportschamp.com/course
Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
solveandexcel.ca/dynamic-dependent-dropdown-lists-in-excel/
_______________________________________________________________________
Session recorded live on September 14, 2022
If you have a long memory, you'll recall that 8 years ago Microsoft BI was all about Power Pivot and Power BI in Excel. Power BI is the big thing nowadays, but Excel's BI features have recently had a makeover - and in this session, we'll see just how much BI you can do with the Excel you already own, without paying for Power BI or any other BI tool. As well as seeing what's new in Power Pivot and Power BI you'll see how Office Scripts can be used to automate tasks and Data Types can bring in external data.
---------------------
About the Speaker: Chris Webb
Chris Webb is a member of the Power BI Customer Advisory Team at Microsoft. He has over 20 years experience of using Microsoft BI tools, has written several books and blogs about Microsoft BI.
--------------
Find more about Owen's work and connect with him:
Blog: blog.crossjoin.co.uk/
CHAPTERS: (Thank you to Gráinne Duggan for her help with this list.)
00:00:00 - Celia Alves MS Excel Toronto news and upcoming events
00:05:00 - Celia Introduces Chris Webb
00:08:30 – Chris introduces himself and his presentation
00:12:45 – History of modern Excel
00:15:50 – What do you mean by BI?
00:17:15 – Parametrized table reports with Power Query
00:29:10 – More complex layouts with Linked Data Types
00:34:15 – Report bursting with Power Automate desktop flows
00:45:00 – Automating report generation in Office Scripts
00:49:00 – Exploratory analysis with Power Pivot and Ideas
01:02:45 – Dashboards and interactive reports
01:08:40 - Conclusion
01:12:45 - Questions
01:28:00 - Wrap up
- MS Excel Toronto - BI with Excel - but not Power BI! - Chris Webb ( Download)
- BI with Excel - but not Power BI! | Chris Webb ( Download)
- MS Excel Toronto- From Power BI to Excel and back - Sue Bayes ( Download)
- Using Excel as a reporting & analysis tool for Power BI data | Chris Webb ( Download)
- MS Excel Toronto Meetup – Catching Errors in Power Query for Exception Reporting – Cristian Angyal ( Download)
- [BI6] Bl with Excel - but not Power Bl! ( Download)
- Connect Live with Chris Webb ( Download)
- London Power BI User Group - May 21 - Chris Webb - Excel as a reporting tool for Power BI ( Download)
- Chris Webb: Modern Excel ( Download)
- Chris Webb - Performance tuning Power Query and dataflows ( Download)
- MS Excel Toronto Meetup - The Magic of Filters in Power Query - Alejandra Horvath ( Download)
- MS Excel Toronto Meetup - From Data 2 Dashboard in 1 Day - Mark Rosenkrantz ( Download)
- Power Query Beyond the Basics Chris Webb ( Download)
- Demystifying Power BI Datasets with Chris Webb and Peter Myers ( Download)
- This can happen in Thailand ( Download)
