Preparation Tools and Resources

Search here for prep resources for specific exam topics and add any exam prep resources that you have found helpful in preparing for this exam.

General preparation material

Learning plans and classroom training

Prep resources by objective

1  Build an Analysis Services Database

1.1  Design dimensions and measures

  • <<fires>>
  • <<Add your resources here>>

1.2  Implement and configure dimensions in a cube

  • <<Add your resources here>>
  • <<Add your resources here>>

1.3  Design a schema to support cube architecture

  • <<Add your resources here>>

1.4  Create measures

  • <<Add your resources here>>
  • <<Add your resources here>>

1.5  Impement a cube

  • <<Add your resources here>>
  • <<Add your resources here>>

1.6  Create Multidimensional Expressions (MDX) queries

  • <<Add your resources here>>
  • <<Add your resources here>>

1.7  Implement custom logic in a data model

  • <<Add your resources here>>
  • <<Add your resources here>>

1.8  Implement storage design in a multidimensional model

  • <<Add your resources here>>
  • <<Add your resources here>>

1.9  Select an appropriate model for data analysis

  • <<Add your resources here>>
  • <<Add your resources here>>

2  Manage, Maintain, and Troubleshoot an SSAS Database

2.1  Analyze data model performance

  • <<Add your resources here>>

2.2  Process data models

  • <<Add your resources here>>
  • <<Add your resources here>>

2.3  Troubleshoot data analysis issues

  • <<Add your resources here>>
  • <<Add your resources here>>

2.4  Deploy SSAS databases

  • <<Add your resources here>>
  • <<Add your resources here>>

2.5  Install and maintain SSAS instance

  • <<Add your resources here>>
  • <<Add your resources here>>

3  Build a Tabular Data Model

3.1  Configure permissions and roles in Business Intelligence Semantic Model (BISM)

  • <<Add your resources here>>
  • <<Add your resources here>>

3.2  Implement a tabular data model

  • <<Add your resources here>>
  • <<Add your resources here>>

3.3  Implement business logic in a tabular data model

  • <<Add your resources here>>

3.4  Implement data access for a tabular data model

  • <<Add your resources here>>

4  Build a Report with SQL Server Reporting Services (SSRS)

4.1  Design a report

  • <<Add your resources here>>
  • <<Add your resources here>>

4.2  Implement a report layout

  • <<Add your resources here>>
  • <<Add your resources here>>

4.3  Configure authentication and authorization for a reporting solution

  • <<Add your resources here>>

4.4  Implement interactivity in a report

  • <<Add your resources here>>
  • <<Add your resources here>> 

4.5  Troubleshoot reporting services issues

  • <<Add your resources here>>
  • <<Add your resources here>> 

4.6  Manage a report environment

  • <<Add your resources here>>
  • <<Add your resources here>> 

4.7  Configure report data sources and datasets

  • <<Add your resources here>>
  • <<Add your resources here>>