Developing Sever 2016 SQL Data Models

  • Course Code: MS20768
  • Course Location: Columbia, SC
  • $1500
  • Get Started

Schedule

Sorry No Events

Audience

The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions.

Objective

The focus of this 3-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.

Outline

Module 1: Introduction to Business Intelligence and Data Modeling Module 2: Creating Multidimensional Databases Module 3: Working with Cubes and Dimensions Module 4: Working with Measures and Measure Groups Module 5: Introduction to MDX Module 6: Customizing Cube Functionality Module 7: Implementing a Tabular Data Model by Using Analysis Services Module 8: Introduction to Data Analysis Expression (DAX) Module 9: Performing Predictive Analysis with Data Mining