Description: Designing Business Intelligence Solutions
Attendees will learn how to plan business intelligence (BI) solutions, design BI infrastructure, design a reporting solution, design BI data models, and design an ETL solution. This course will help prepare the attendees for the Implementing Data Models and Reports with Microsoft SQL Server although the design concepts are tool independent. This is a 15-week session meeting twice a week with virtual lectures and online instructor-led interactive group discussions.
Please check the events calendar for the next available sessions, or send a note with questions.
Module 1: Install and Configure Microsoft SQL Server
- Plan Installation
- Install SQL Server and related services
- Implement a migration strategy
- Configure additional SQL Server components
- Manage SQL Server Agent
Module 2 Configuring the Data Warehouse
- Designing the Data Warehouse
- Creating a Data Warehouse
- The ETL Process
- Beginning the ETL Process
- Completing ETL
Module 3 Using SSAS
- Starting an SSAS Project
- Configuring Dimensions
- Creating and Configuring CUBES
- Advance topics in SSAS
Module 4 Using SSRS and Related Services
- Creating Report Queries
- Using MDX Queries in Reports
- Integrating Excel
- Creating Reports in SSRS
- Configuring Reports