The Art of Prototyping Analytics

on YouTube ↗01h 04m

" summary

Shows how to prototype end-to-end analytics with Excel tools: extract and clean HTML/web tables with Power Query, model with Power Pivot, publish to Power BI and automate refresh with Power Update. Demonstrates shaping oddly formatted files into dates, handling a 300 million‑row source that ends up compressed to 2.2 MB, and delivering interactive Power View dashboards that support daily refresh and user-driven dashboards. Presents a short ROI spreadsheet, a small cross‑functional team model, and an iterative delivery loop that succeeds in practice.

AI-written summary · about

" chapters (7)

1. 0:00Introduction
2. 10:16Data culture in orgs
3. 24:24Dysfunctional to functional analytics
4. 34:55Prototyping in Excel
5. 53:29Visual analytics with Power BI
6. 1:00:42Automating with Power Update
7. 1:03:13Empowering leaders

" related talks

• 18mEmpowering Business Through DataDeepthi Anantharam · Great Indian Developer Summit 2015
• 58mProductivity Revolution in ExcelAvi Singh, Purna Duggirala · PASS BA Marathon 2015
• 49mVisualizing Data: the Good, the Bad, and the UglyStacia Varga · 24 Hours of PASS: Summit Preview 2015
• 50mThe Path to Success with Power BI: Best PracticesPatrick LeBlanc, Adam Saxton · SQLBits 2023
• 50mBuilding an Empire - Implementing Power BI Step by StepAlexander Arvidsson · Power Platform Virtual Conference 2021
• 47mFrom Power BI to Excel - The best of two worldsPedro Reis · Global Azure 2021
• 59mSelf-Service Data ModelingMarco Russo · PASS Business Analytics Conference 2013
• 48mCombine Power BI with External ToolsMiguel Félix · SQLBits 2023