SQL Server 201 – BI Quick Start

Class Description
BI Quick Start provides a hands-on lab environment. In 5-days, Participants will build a fully functional prototype data warehouse using SQL Server along with the complete Microsoft BI Platform: SSIS, SSAS, SSRS and Power BI.

Course Benefits

  • The Microsoft BI platform from top to bottom; Best practices of modeling a data warehouse
  • Proficiency with the BI developer tools that will accelerate Students projects and improve Students solutions
  • Readiness to undertake the toughest BI projects for Students organization

Suggested Prerequisites
A computer will be provided for lab work. There are no additional system requirements for this course.

Course Outline

  • Creating the Data Model
  • Loading Dimensions
  • Loading Fact Tables
  • Package Deployment
  • Cube Design
  • Creating MDX Calculations
  • Creating KPI’s
  • SSRS Reports
  • Power Pivot

Related Classes

Our goal is to make sure your class meets your objectives, not ours. Therefore, all of our outlines are treated as guides to help steer the workshop. This outline does not guarantee that all the topics listed will be covered in the time allowed. The amount of material covered is based on the skill level of the student audience. We may change or alter course topics to best suit the classroom situation.