Integrated Microsoft BI Solution Implementation
The end-to-end design, development, and implementation of a Microsoft Business Intelligence solution.
Course Description
The course provides a detailed presentation of the Business Intelligence solution architecture based on a typical data warehouse architecture.
By integrating SSIS, SSAS, and SSRS, a complete Microsoft BI solution can be successfully built that transforms raw data into actionable insights
Source Systems → SSIS → Data Warehouse → SSAS Cube → SSRS Reports
SSIS (SQL Server Integration Services) – Data integration
SSAS (SQL Server Analysis Services) – Analytical data model
SSRS (SQL Server Reporting Services) – Reporting and dashboards
Audience Profile
The course is designed for IT professionals and data specialists who want to design, implement, and manage an end-to-end Microsoft Business Intelligence (BI) solution using technologies such as SQL Server, SSIS, SSAS, SSRS and Power BI.
Course Outline
Before designing the implementation model
- Goals and Scope: Define the objectives of the solution and the business domains it will address.”
- “Source data: Identify and define the data sources required for the solution.
- Types of reporting models: static reports and real-time reports
Implementation and design phases of the BI solution
SSIS (SQL Server Integration Services) – Data integration
- Star Schema configuration of the staging database or a Data Warehouse
- Extracts data from operational systems, performs data cleansing and transformation, and loads it into a staging database or data warehouse, following the design for measures and dimensions
SSAS (SQL Server Analysis Services) – Analytical data model
- Analyze and compare the Multidimensional and Tabular Data Warehouse models in terms of design, performance, and usability
- Implementation of a Multidimensional Model
- Management and Administration of the Multidimensional Model
- Implementation of a Tabular Model
- Management and Administration of the Tabular Model OR
- Selection of the Data Warehouse Model – Multidimensional vs. Tabular
- Scheduled processing for the data warehouse model.
SSRS (SQL Server Reporting Services) – Reporting and dashboards
- Selection of the interactive report and dashboard design application.
- Design and development of reports using Power BI Desktop.
- Data source connectivity configuration: Import mode vs Direct Query / Live Connection mode
- Comparison and deployment considerations: Power BI Report Server vs SQL Server Reporting Services (SSRS).
- Uploading, publishing, and sharing reports through Power BI Report Server or SQL Server Reporting Services.
- Querying the SSAS analytical model using external client tools such as Microsoft Excel, Power Query, and Power Pivot, Report Builder
- Implementation of scheduled report subscriptions to enable automated distribution of reports
