Self-Service Business Analytics in 2013
summary
Argues that managed self-service BI works only when IT supplies an 80% corporate data base and users add the remaining 20% with governable tools; demonstrates SSRS data alerts (SQL Agent jobs firing on thresholds), PerformancePoint decomposition trees, report parts drag‑and‑drop, a Pivot/HTML5 visualizer, and building a PowerPivot model (SQL + Excel + lat/long) then publishing PowerPivot to SharePoint and interactive Power View reports (pie, scatter with play axis, map geocoding); shows PowerPivot gallery and management dashboard and previews Data Explorer and GeoFlow.
AI-written summary · about
chapters (15)
- 0:00Self-service analytics intro
- 1:49Corporate BI definition
- 6:21Personal BI definition
- 8:06Managed self-service BI
- 10:50SSRS data alerts demo
- 13:39Performance Point dashboard demo
- 16:52Geospatial reporting demo
- 20:23Pivot visualization demo
- 23:33Report parts demo
- 27:23Power Pivot modeling demo
- 34:44Power View reports demo
- 42:39Power Pivot Gallery demo
- 47:11Power Pivot management demo
- 48:552013 Data Explorer features
- 51:41Summary and Q&A
related talks
01h 01mHow to Create Value and Present Data to Business Executives in SharePoint
41mCreating an Effective Reporting Strategy: Tools, Metrics, Analytics
37mPitfalls and pro-tips for effective and transparent BI tools data science & applications
20mPower BI Culture: Governance as a gateway to adoption, not a barrier.
27mDemocratising data-driven decisions with self-service tools
48mCombine Power BI with External Tools
01h 04mThe Art of Prototyping Analytics
39mKey Elements for a Successful Service Analytics Program