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 Skill 2.3. Develop a tabular model to access data in near real time   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 Skill 3.3. Create formulas by using the DAX language   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 Skill 4.4. Create Key Performance Indicators (KPIs) and Translations

Authoritative and complete MCSA Exam 70-768 preparation content, straight from Microsoft Covers key skills associated with creating solutions based on SSAS 2016 multidimensional and tabular models, and implementing and maintaining OLAP cubes Organized by exam objectives for efficient study Strategic, what-if scenarios challenge exam candidates, helping them master the big-picture thinking the exam demands Contains up-to-date exam preparation tips from a highly-respected Microsoft MVP