Discover, Acquire, and Transform Your Data with Power Query
summary
Power Query demonstrates end-to-end acquisition and reshaping: discovers public datasets via a Data Catalog with 3 million tables, pulls web pages and Google Sheets, and runs UI transforms (split, replace, pivot, transpose, fill down) and merges to join population GDP and BMI for cross‑country analysis. A reusable function iterates pages to collect 693 rows of movie data; another demo unpivots 232 yearly columns into tidy time series. All examples load into Excel/Power View, run live, and the Excel 2016 integration plus VBA/query object model work as shown.
AI-written summary · about
chapters (11)
- 0:00Power Query intro
- 1:05Data acquisition challenge
- 10:54Why Power Query matters
- 12:17Demo: public data discovery
- 16:31Demo: tennis rankings scraping
- 22:29Demo: global economic health data
- 33:31Demo: spreadsheet data cleaning
- 36:18Demo: movie data scraping
- 42:06Power Query updates
- 50:14Power Query in Excel 2016
- 1:01:44Q&A
related talks
18mEmpowering Business Through Data
19mPower Query in 20 Minutes - How it Works
54mWhat's new in Power Query in Power BI, Fabric and Excel?
01h 03mMicrosoft Data Explorer for Excel: Data Discovery & Transformation
01h 03mFeed Your Data! OData Data Feeds for PowerPivot Users
01h 03mFrom Data to Insight – Views from Microsoft Finance
45mRebooting your SME Data Analysis Strategy
54mExtending PowerPivot into a Scalable Component for Enterprise BI