This 5-day instructor-led SQL Basics course is the ideal training course for introducing you to the Microsoft BI tool suite for SQL Server. We start with an introduction to the basics of business intelligence and data warehousing. After going through the general BI basics, you will learn how to implement an Analysis Services OLAP solution (2 days), an Integration Services ETL solution (2 days) and a Reporting Services solution (1 day).
This SQL Basics course explains:
- How to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.
- How to develop, deploy and manage Integration Services ETL packages to extract, transform, clean and enrich source data for uploading into a data warehouse database.
- How to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.
Each of these three components can be provided in separate SQL Basics training sessions if necessary.
Training duration: 5 days (SSIS, SSAS & SSRS).