Applied BI

Applied Microsoft BI

The Microsoft Data Platform empowers BI pros to implement organizational BI solutions delivering a single version of the truth across the enterprise. A typical organizational solution includes a data warehouse/data mart, ETL processes to extract, transform, and load the data, and a semantic model to centralize business calculations. This four-day class is designed to help you become proficient with the Microsoft BI toolset and acquire the necessary skills to implement an organizational BI solution. You’ll learn how to design a star schema, use SQL Server Integration Services to transform data, and implement a Tabular semantic model. Depending on the students’ skillset, it can be customized, such as to reduce coverage of specific technologies, replace them with other topics of interest, such as Multidimensional instead of Tabular, or cover additional topics, such as Power BI or Reporting Services.


  • BI professions
  • BI developers


  • Experience with SQL Server development
  • Familiarity with organizational BI

Hardware and software requirements

  • Windows 7 or above
  • Minimum of 4GB RAM (8GB recommended)
  • SQL Server instance (local or remote)
  • SQL Server Data Tools or Visual Studio with SSDT-BI
  • AdventureWorks and AdventureWorksDW databases