Data Analysis with Multidimensional Modelling Course Overview

The Data Analysis with Multidimensional modelling course is designed to equip learners with the skills to utilize business intelligence (BI) tools and Data modelling techniques. In Module 1: Introduction to Business Intelligence and Data Modelling, students will gain foundational knowledge of BI concepts and data models, understand the differences between MS SQL databases and cubes, and learn how to connect databases with SSIS and SSAS. They'll explore the creation and connection of Data sources and multidimensional databases.

Module 2: SCD and Dimensions with Cube dives into practical aspects, teaching students to work with Dimensions, measures, and measure groups, and introduces MDX for cube calculations.

In Module 3: Tabular Data Model with Analysis Services, learners will create a tabular data model and employ DAX to formulate calculated columns and measures. This course will be instrumental for those seeking to enhance their data analysis capabilities and gain proficiency in Multidimensional modelling and business intelligence tools.