Hailing Frequencies: Analysis Services Terms and Concepts
summary
Overview of SQL Server Analysis Services shows two concrete models and working examples: a multi‑dimensional cube queried with MDX and browsed via Excel 2013 pivot (cube processes instantly, reveals 80 Original Series episodes, ~170 across the three later series, ~100 for Enterprise, and overlapping air years like 1993 and 1995). The session builds a live PowerPivot → SSAS Tabular import, demonstrates DAX calculated measures, hides key columns, and confirms the tabular model works interactively in Excel.
AI-written summary · about
chapters (8)
- 0:00Welcome
- 1:46Overview and agenda
- 8:30Multi-dimensional terms
- 16:10Multi-dimensional cube demo
- 25:50Tabular model intro
- 31:27Building tabular model
- 47:14Deploying to tabular
- 52:08Q&A
related talks
58mBeginners Guide to MDX
01h 13mIntegrating SQL Server Analysis Services with Hadoop
52mPower BI + Azure Synapse Analytics. All you need to start creating a unified analytics solution
49mAnalytics in SQL Server and Azure SQL Database
16mGood Data Modeling & Effective Communication in Power BI
51mData modeling for experts with Power BI
20mLet's Improve the Tabular Model by Combining Queries
28mSimplify data analysis using analytic views
