Empowering Business Through Data

on YouTube ↗18m

" summary

Claims that Power BI plus Excel lets analysts fuse OLTP, big‑data and streaming sources and deliver interactive dashboards in minutes. Demo pulls data with Power Query from SQL Server, HDInsight, blobstore and public APIs, builds a PowerPivot model with hierarchies and KPIs, and drops it into pivot tables and a clickable dashboard. Shows a concrete analytic: a customer segment with 68% confidence will buy a car within 90 days, and sketches real‑time toll/car monitoring use cases.

AI-written summary · about

" chapters (11)

1. 0:00Introduction to data empowerment
2. 1:06Bridging business and customers with data
3. 2:31Data events and business intelligence
4. 3:33Types of data challenges
5. 5:00Fetching data with Power Query
6. 8:29Data modeling with Power Pivot
7. 10:17Creating relationships in Excel
8. 13:58Building KPIs and reports
9. 15:24Self-service analytics in action
10. 16:17Building dashboards with Power BI
11. 17:19Conclusion and next steps

" related talks

• 01h 01mDiscover, Manage, Analyze, and Visualize Your Data with Power BIMiguel Martínez · PASS Business Analytics Conference 2015
• 48mPower BI for DevelopersPeter Meyers · NDC Sydney 2018
• 54mExtending PowerPivot into a Scalable Component for Enterprise BIAvi Perez · PASS Business Analytics Conference 2013
• 58mPower BI for the DeveloperPeter Myers, Chris Webb · NDC London 2023
• 58mPower BI for DevelopersPeter Myers, Laurent Amar · NDC London 2019
• 01h 03mPower BI for the DeveloperPeter Myers · NDC Sydney 2016
• 58mReal world PowerBIMatt Davies · NDC Sydney 2017
• 47mFrom Power BI to Excel - The best of two worldsPedro Reis · Global Azure 2021