Self-Service Data Modeling

on YouTube ↗59m

" summary

Advanced Excel users can build a usable star schema and compare sales vs. budget without writing SQL by using Power Pivot to host measures and lookup tables and Data Explorer to merge territory rows and unpivot/crosstab automation for web tables. Demos show copying/cleaning to create year and category dimension tables, merging territory into shops and customers, loading to the data model and refreshing the workbook; the result is a working report that refreshes automatically and is ready in a few hours, with tradeoffs in relationships and performance.

AI-written summary · about

" chapters (11)

1. 0:00Self-service data modeling intro
2. 3:53Perfect data analysis day
3. 9:13Real-world modeling challenges
4. 14:34Common modeling issues
5. 25:19Over-denormalization in Excel
6. 28:08Over-normalization problems
7. 31:48Ambiguous territory relationships
8. 35:46Data Explorer denormalization
9. 45:35Crosstab data automation
10. 56:17Key skills and tools
11. 59:10Q&A

" related talks

• 45mRebooting your SME Data Analysis StrategyMark Hayes · SQLBits 2020
• 58mProductivity Revolution in ExcelAvi Singh, Purna Duggirala · PASS BA Marathon 2015
• 18mEmpowering Business Through DataDeepthi Anantharam · Great Indian Developer Summit 2015
• 01h 04mThe Art of Prototyping AnalyticsKen Raetz · PASS Business Analytics Conference 2015
• 01h 03mBudgeting with Power PivotMarco Russo · PASS Business Analytics Conference 2015
• 01h 01mHow to Create Value and Present Data to Business Executives in SharePointMatt Allington · PASS Business Analytics Conference 2015
• 30mSelf-service data warehousingPatrick Wheeler · Oracle DatabaseWorld 2021
• 01h 13mDiscover, Acquire, and Transform Your Data with Power QueryMiguel Llopis · PASS Business Analytics Conference 2015