From Data to Insight – Views from Microsoft Finance
summary
Microsoft Finance shows how Excel 2013 + Power Pivot/Power View + SharePoint and PowerPoint turn raw sources into actionable dashboards: an American Express feed of 1.5 million airfare records and a 50-country review that was 1250 slides collapsed into one become interactive visuals with slicers, maps and DAX measures. Models scale to enterprise (he reports a deployed model handling 250 million records refreshing in 2–3 seconds), row-level security carries into PowerPoint, and the demos work live when connectivity holds (offline Excel falls back to the same Power Pivot model).
AI-written summary · about
chapters (13)
- 0:00Introduction
- 1:05Finance professional at Microsoft
- 3:14Handling massive financial data
- 7:27Excel Power View demo
- 12:10Building financial reports
- 22:22Business review with dynamic data
- 26:13BI tools transformed workflows
- 30:30Data to insight conversion
- 36:51Data storytelling design
- 42:41Overview, zoom, filter, details
- 48:23Scaling reports with Power BI
- 56:13Finance in business intelligence
- 1:02:14Q&A
related talks
18mEmpowering Business Through Data
45mRebooting your SME Data Analysis Strategy
02h 12mOptimizing your Power Pivot models using Power Query
01h 13mDiscover, Acquire, and Transform Your Data with Power Query
51mPower BI Composite and Hybrid Models
01h 03mBudgeting with Power Pivot
54mWhat's new in Power Query in Power BI, Fabric and Excel?
01h 04mBest Practices for Collecting and Analyzing Data with Power Query and Excel