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

Data Modelling with SSAS