Dark Matter: Domain Experts & Nextgen Spreadsheets Are Our Future
summary
Argues that spreadsheets are the hidden majority of analytics, claiming 90+% of data crunching flows through Excel because subject-matter experts avoid costly communication overhead. Shows Power Pivot handling 300+ million rows in one workbook on a commodity Ultrabook with ~1.5s slicer response, demonstrates reusable DAX “measures” that replace fragile vlookup hacks, and describes a fast, iterative workflow: deliver simple star-schema tables, author reports in minutes (budget vs actual in ~15 minutes) and iterate with DBAs.
AI-written summary · about
chapters (26)
- 0:00Introduction
- 1:05Dark matter in astronomy
- 4:16Excel’s dominance in analytics
- 8:35Why Excel is feared
- 10:01Power of experts and barriers
- 16:00Excel’s communication efficiency
- 17:29Excel’s new features
- 19:15Self-service BI trends
- 22:22Kinds of dark matter
- 23:45Excel already paid for
- 24:2830 million power users
- 27:0015-to-1 report consumers
- 29:07Half billion Excel users
- 31:15Interactive demo selection
- 32:52Training for Power Pivot
- 37:25Excel calendar demo
- 39:12Thousand miles in one file
- 42:44Just-in-time data marts
- 43:46Consulting with Power Pivot
- 46:43Selling Power Pivot
- 48:50Loading legacy data
- 51:04Slowly changing dimensions
- 51:47Portable formulas for budget
- 56:29Custom functions in DAX
- 58:21Weather impact demo
- 1:00:32Closing and Q&A
related talks
18mEmpowering Business Through Data
53mCreating Outstanding Spreadsheet Models
16mData is the Future, Future already started
02h 12mOptimizing your Power Pivot models using Power Query
45mRebooting your SME Data Analysis Strategy
25mFrom Data Warehouse To Self-service BI: Our Journey To Data Mesh
53mThe Pain and Glory of Data Preparation
01h 04mBest Practices for Collecting and Analyzing Data with Power Query and Excel