´╗┐

Developing SQL Data Models


Introduction

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.

Outcomes

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.

Prerequisites

ABefore attending this course, students must have:

  • experience of querying data using Transact-SQL. 

Support your training with these additional resources:

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


Schedule

  • Melbourne
  • 22/07/2019 - 24/07/2019
  • 14/10/2019 - 16/10/2019
  • 3/12/2019 - 5/12/2019
  • Canberra
  • 22/07/2019 - 24/07/2019
  • 14/10/2019 - 16/10/2019
  • 3/12/2019 - 5/12/2019
  • Sydney
  • 22/07/2019 - 24/07/2019
  • 14/10/2019 - 16/10/2019
  • 3/12/2019 - 5/12/2019
  • Brisbane
  • 22/07/2019 - 24/07/2019
  • 14/10/2019 - 16/10/2019
  • 3/12/2019 - 5/12/2019
  • Adelaide
  • 22/07/2019 - 24/07/2019
  • 14/10/2019 - 16/10/2019
  • 3/12/2019 - 5/12/2019
  • Perth
  • 22/07/2019 - 24/07/2019
  • 14/10/2019 - 16/10/2019
  • 3/12/2019 - 5/12/2019
  • Hobart
  • 22/07/2019 - 24/07/2019
  • 14/10/2019 - 16/10/2019
  • 3/12/2019 - 5/12/2019
  • Darwin
  • 22/07/2019 - 24/07/2019
  • 14/10/2019 - 16/10/2019
  • 3/12/2019 - 5/12/2019
  • New Zealand
  • 22/07/2019 - 24/07/2019
  • 14/10/2019 - 16/10/2019
  • 3/12/2019 - 5/12/2019

Next Step

Book Course Now
Enquire Now
Tell a Friend
Email Course Outline