Formation Suite Microsoft (SSIS-SSAS-SSRS)

Module 1: Dimension Modeling & Data Warehousing

Explore fundamental Business Intelligence concepts and Data Warehousing basics.

Dive into the design of facts and dimensions, including key performance indicators.

Understand the dimensional modeling process for Data Warehouse design.
 

Module 2: MS SQL Server Integration Services (SSIS)

Learn Extract, Transform, and Load (ETL) processes, covering various transformations.

Solve data management challenges through data migration and processing.

Implement ETL Framework, enhance functionality with scripting, and handle errors effectively.

Explore SSIS Package Performance Tuning and Best practices.

Deploy packages, administer storage, security, and execution on an SSIS server.
 

Module 3: MS SQL Server Reporting Services (SSRS)

Produce table and matrix reports with drill-down and drill-through functionality.

Create reports with enhanced visualization features such as charts, maps, and gauges.

Integrate parameters, filters, and interactive components into reports.

Develop reports on SSAS cubes with Report Builder.

Deploy reports to the Report Server, configure security, and test report item security.

Perform report performance tuning.
 

Module 4: MS SQL Server Analysis Services – Multidimensional Analysis Model (SSAS)

Create and deploy cubes, extend hierarchies, and utilize advanced dimension relationships.

Configure many-to-many dimension relationships and build aggregations.

Implement Key Performance Indicators for monitoring business objectives.

Explore Cube storage modes: MOLAP, ROLAP, and HOLAP.

Implement actions to open Reporting Services reports or analyze data using Excel.

Automate cube processing with an XMLA script.
 

Module 5: MS SQL Server Analysis Services - Tabular Analysis Model (SSAS)

Understand the basics of in-memory processing.

Compare multiple dimensional models vs. tabular analysis models.

Create and deploy a tabular analysis cube.

Build aggregations, hierarchies, and dimension relationships.

Implement Key Performance Indicators and explore the DAX query language.
 

Module 6: MDX Queries

Explore the basics of MDX (Multidimensional Expressions).

Work with sets, calculations, and hierarchical calculations.

Implement Time Intelligence functions like QTD (Quarter to Date) and YTD (Year to Date).

Deploy and manage calculations.