My Brain Hurts: Presenting Data with Microsoft Tools
summary
Survey of Microsoft BI tools with concrete tradeoffs: PerformancePoint is strong for scorecards/dashboards and browser analytics but only works against cubes and has poor formatting control; Excel + Excel Services offers full pivot-driven analysis and the game-changing Excel Services 2013 pivot field in browser; Power Pivot/Power View enable ad hoc tabular models and rich visuals including Power View mapping/timeline; GeoFlow duplicates map-driven exploration; Reporting Services suits static, scheduled reports. Practical limits: tabular is easiest but in-memory scale is real — e.g. tabular 10:1 compression needing 3 TB RAM — and MDX/DAX differences affect which model to choose.
AI-written summary · about
chapters (6)
- 0:00Introduction
- 6:23Performance Point scorecards
- 17:17Excel for analytics
- 24:04Power Pivot and Power View
- 37:10Reporting Services
- 48:15Q&A
related talks
01h 04mCreate Reports That Help You Run Your Business
49mVisualizing Data: the Good, the Bad, and the Ugly
18mEmpowering Business Through Data
01h 08mAdvanced Modelling and Calculation Using the Power BI Designer
46mVisualizing Data for Non-Data Experts: Making Reports Accessible to All
50mThe Path to Success with Power BI: Best Practices
01h 01mHow to Create Value and Present Data to Business Executives in SharePoint
59mA pragmatic approach to turn your data into actionable insights