MCSA: SQL Server 2016 Business Intelligence Development

  • Course level: Intermediate
  • Categories Microsoft
  • Last Update 19/03/2021


MCSA SQL Server 2016 BI course from VEGA aims to equip BI developers with core knowledge and skills to implement business intelligence solutions for SQL Server 2016. Database professionals and Business Intelligence (BI) developers will learn to use SQL Server Analysis Services (SSAS), and utilize it to create tabular semantic data models for analysis.

What Will I Learn?

  • Understand the underlying architecture, components, and properties of a BI solution
  • Use SSAS analysis services for creating a multidimensional database
  • Implement dimensions, measures and measure groups in a cube
  • Create a tabular database
  • Query a tabular model using DAX
  • Customize a cube
  • Implement MDX syntax
  • Perform data mining for predictive analysis

Material Includes

  • Duration: Full-time- 15 Days
  • Duration: Part-time- 9 Months
  • 28 hours on-demand video
  • 11 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion


  • Knowledge of querying using T-SQL and basic knowledge of normalized relational databases.

Target Audience

  • This SQL Server BI training is ideal for database professionals who are responsible for fulfilling the role of a BI Developer for creating enterprise BI solutions. Power users, information workers and data analysts can also attend this course for better understanding of SSAS in SQL Server BI.