Quick access to online references
Errata, updates, & book support
Chapter 1 Design a multidimensional business intelligence (BI) semantic model
Skill 1.1: Create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS)
Design, develop, and create multidimensional databases
Skill 1.2: Design and implement dimensions in a cube
Define attribute relationships
Skill 1.3: Implement measures and measure groups in a cube
Chapter 2 Design a tabular BI semantic model
Skill 2.1: Design and publish a tabular data model
Design measures, relationships, hierarchies, partitions, perspectives, and calculated columns
Publish from Microsoft Visual Studio
Import from Microsoft PowerPivot
Select a deployment option, including Processing Option, Transactional Deployment, and Query Mode
Skill 2.2: Configure, manage, and secure a tabular model
Configure tabular model storage and data refresh
Configure refresh interval settings
Configure user security and permissions
Skill 2.3: Develop a tabular model to access data in near real time
Use DirectQuery with Oracle, Teradata, Excel, and PivotTables
Convert in-memory queries to DirectQuery
Chapter 3 Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
Skill 3.1: Create basic MDX queries
Implement basic MDX structures and functions, including tuples, sets, and TopCount
Skill 3.2: Implement custom MDX solutions
Create custom MDX or logical solutions for pre-prepared case tasks or business rules
Skill 3.3: Create formulas by using the DAX language
Use the EVALUATE and CALCULATE functions
Chapter 4 Configure and maintain SQL Server Analysis Services (SSAS)
Skill 4.1: Plan and deploy SSAS
Configure Non-Union Memory Access (NUMA)
Determine SSAS instance placement
Skill 4.2: Monitor and optimize performance
Monitor performance and analyze query plans by using Extended Events and Profiler
Identify bottlenecks in SSAS queries
Monitor processing and query performance
Optimize and manage model design
Skill 4.3: Configure and manage processing
Configure partition processing
Configure dimension processing
Configure Parallel, Sequential, and Writeback processing settings
Skill 4.4: Create Key Performance Indicators (KPIs) and translations
Create KPIs in multidimensional models and tabular models
Create and develop translations
What do you think of this book? We want to hear from you!
Microsoft is interested in hearing your feedback so we can continually improve our books and learning resources for you. To participate in a brief online survey, please visit: