Visualization Choices: What, When, and How?
summary
Shows a concrete workflow: a three‑year FAA on‑time dataset is modeled in PowerPivot with DAX KPIs, visualized interactively in Power View (including an animated bubble chart for Delta flight 1977), exported as live slides into PowerPoint and published to SharePoint, and promoted to a tabular Analysis Services model for scalable access. Reports built with Report Builder/Reporting Services support richer parameters and drilldown but take more development time; Excel+SharePoint serves quick self‑service while SSRS suits production dashboards.
AI-written summary · about
chapters (16)
- 0:00Data visualization choices intro
- 1:27Introduction
- 3:13Business intelligence needs
- 8:55Microsoft in BI landscape
- 15:36Core BI components
- 21:20Personal BI with Excel
- 26:16Tool comparison and demo
- 29:36Power View flight demo
- 34:46Share Power View reports
- 37:48Export to PowerPoint
- 41:48Excel 2010 Power Pivot
- 47:55Report Builder dashboards
- 55:02Excel 2013 Power View
- 56:06Mobile BI future
- 59:17Summary BI tools
- 1:00:00Q&A
related talks
01h 04mCreate Reports That Help You Run Your Business
01h 01mHow to Create Value and Present Data to Business Executives in SharePoint
46mVisualizing Data for Non-Data Experts: Making Reports Accessible to All
49mVisualizing Data: the Good, the Bad, and the Ugly
50mLet End Users Drive: Empowering User Control in Power BI Reports
58mProductivity Revolution in Excel
18mEmpowering Business Through Data
25mTake your Power BI Reports to the Next Level