Business intelligence solutions provide the infrastructure that enables users at all levels of a business to make better decisions based on more accurate and up-to-date information. This workshop focuses on teaching IT professionals the best practices and skills required to successfully design, build and operate a business intelligence solution using SQL Server 2016 Integration Services, Analysis Services, Reporting Services and Power BI.
This workshop-style course is designed for IT professionals who are interested in learning how to implement Business Intelligence solutions on the Microsoft BI Stack. Basic knowledge of common business requirements for a BI solution is assumed and some experience with SQL Server is required.
Please note: Although this course uses a later edition of SQL Server and tools (2016), most of the tools are very similar to those in previous version such as 2008R2, 2012 and 2014. All techniques and technologies are applicable to the old editions. The differences if noticable will be pointed out on the course.
Module 1: Business Intelligence Overview
This module will introduce the course concepts and the Microsoft Business Intelligence stack (covering line-of-business systems, Integration Services, the Data Warehouse, Analysis Services, Reporting Services, Power View, SharePoint, PerformancePoint and PowerPivot for Excel).
Sections:
BI products
BI Projects
Labs:
Module 2: Designing Business Intelligence Solution
Sections:
References:
Demonstrations:
Labs:
Module 3: Creating the Data Warehouse
Sections:
Demonstrations:
Labs:
Module 4: Loading the Data Warehouse
Sections:
Demonstrations:
Labs:
Module 5: Creating the Analysis Cube using the Multi-Dimensional model
Sections:
Labs:
Module 6: Enhancing the Multi-Dimensional Analysis cube
Sections:
Demonstrations:
Labs:
Module 7: Creating the Analysis Cube using the Tabular model
Sections:
Demonstrations:
Labs:
Module 8: Creating reports with Reporting Services
Sections:
Demonstrations:
Labs:
Module 9: Power BI
Sections:
Demonstrations:
Labs:
Join our public courses in our Norway facilities. Private class trainings will be organized at the location of your preference, according to your schedule.