Developing SQL Data Models


The focus of this third-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.

Audience Profile

The primary audience for this course are database professionals who need to fulfil BI Developer

role to create enterprise BI solutions. 

Primary responsibilities will include:

  •  implementing multidimensional databases by using SQL Server Analysis Services
  •  creating tabular semantic data models for analysis by using SQL Server Analysis Services.


After completing this course, students will gain the skills to:

  • describe the components, architecture, and nature of a BI solution
  • create a multidimensional database with analysis services
  • implement dimensions in a cube
  • implement measures and measure groups in a cube
  • use MDX syntax
  • customise a cube
  • implement a tabular database
  • use DAX to query a tabular model
  • use data mining for predictive analysis.


Before attending this course, students must have:

  • experience of querying data using Transact-SQL. 

Onsite training?

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.

User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info


  • Virtual Classroom AEST
  • 4/10/2021 - 6/10/2021
  • 1/12/2021 - 3/12/2021

Next Step

Book Course Now
Enquire Now
Tell a Friend
Email Course Outline