Microsoft SQL Server Analysis Services Multidimensional

• You will get familiar with SQL Server Analysis Services
• You will learn how to create your own multidimensional databases and work with OLAP cubes
• You will master the creation of dimensions and measures
• You will learn the basics of the MDX language
• You will understand the fundamentals of administering a multidimensional instance of SQL Server Analysis Services

• Basic knowledge of relational databases and T-SQL at the level of course GOC277
• Basic understanding of data warehouse concepts at the level of course GOC645

1. Introduction to Analysis Services
• Overview of SQL Server Analysis Services
• Key concepts and use cases
2. Creating Multidimensional Databases
• Creating a Data Source and connecting to data sources
• Implementing a Data Source View
• Building cubes and dimensions
3. Working with Cubes and Creating Dimensions
• In-depth focus on cube creation
• Advanced work with dimensions
4. Working with Measures and Measure Groups
• Creating and managing measures
• Working with measure groups
5. Introduction to MDX Language
• Explanation of MDX fundamentals
• Introduction to basic MDX constructs
• Creating calculated members
6. Administration of a Multidimensional Analysis Services Instance
• Deploying solutions from development to production
• Security management
• Data updates (Processing)
• Task automation

Previous courses

Implementation of a data warehouse and ETL processes using Microsoft SQL Server Integration Services. [GOC645]

Next courses

DAX language and data model creation for Power BI and SQL Server Analysis Services [GOC644]