Data Modelling with SSAS

Course Summary

Training levelDeep Dive
Duration4 days / 32 Hours
Delivery methodIn class
List price850 Euro VAT Excl.

Click Tabs for Detailed info

SQL Server Analysis Services (SSAS) enables IT Professionals to rapidly build and deploy powerful analytical solutions that enable business users to analyze business data and achieve competitive advantage. During this 4-day course attendees will learn to design, develop, and deploy an analytical solution using SQL Server Analysis Services (SSAS). This course demonstrates best practices as you build a fully working analytical solution. It focuses on teaching IT professionals the skills required to design and develop a well performing and successful analytical solution using SQL Server Analysis Services.

  • IT Professionals that are responsible for designing, developing, and deploying business intelligence solutions
  • BI solution architects and intelligence developers who want to learn the details of how to use the new capabilities provided by SSAS to build analytical applications
  • Describe the process of building a business intelligence solution and identify where and how SSAS fits into the process
  • Create effective SSAS solutions complete with calculations, actions, aggregations, and more
  • Design SSAS solutions that are both scalable and secure
  • Successfully manage and deploy SSAS solutions in a development/test/production environment

Module 1. Introduction to BI Data Platform

Module 2. The concept of Dimensional Modelling

Module 3. Creating a BISM End-to-End: Understanding the Process

Module 4. Multidimensional Model: Creating Dimensions and Cubes

Module 5. Multidimensional Model: Advanced Features

Module 6. Tabular Model: Building Models

Module 7. Tabular Model: Advanced Features

Module 8. Storage Modes, Aggregation Designs, and Proactive Caching

Module 9. Model Deployments and processing

Next planned dates:

Trainer: Margarita Naumova



You have a question or you want to book now? Feel free to contact us!

Vili Koleva-Training Manager


M: +359 (885) 113 442