Table of Contents

• 1: Design a Multidimensional Business Intelligence (BI) Semantic Model
• Skill 1.1. Create a Multidimensional Database by Using Microsoft SQL Server Analysis Services (SSAS)
• Skill 1.2. Design and Implement Dimensions in a Cube
• Skill 1.3. Implement Measures and Measure Groups in a Cube
• 2: Design a Tabular BI Semantic Model
• Skill 2.1. Design and Publish a Tabular Data Model
• Skill 2.2. Configure, Manage, and Secure a Tabular Model
• 3: Develop Queries Using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
• Skill 3.1. Create Basic MDX Queries
• Skill 3.2. Implement Custom MDX Solutions
• 4: Configure and Maintain SQL Server Analysis Services (SSAS)
• Skill 4.1. Plan and Deploy SSAS
• Skill 4.2. Monitor and Optimize Performance
• Skill 4.3. Configure and Manage Processing
• Configure Parallel, Sequential, and Writeback Processing Settings
• Skill 4.4. Create Key Performance Indicators (KPIs) and Translations

About the Author

Stacia Varga, Microsoft Data Platform MVP since 2011, has been helping organizations and individuals succeed with SQL Server Analysis Services since it launched in SQL Server 2000. She has authored or coauthored multiple books about BI (as Stacia Misner), and co-authored Introducing Microsoft SQL Server 2016. Varga trains and consults through her company, Data Inspirations; speaks frequently at SQL Server events; and leads SQL Server Society of Las Vegas.