Computer Technology

   >

Computer Technology 

   >

Developing SQL Data Models

Developing SQL Data Models

Duration (Days)

3

Overview

This course is designed to help participate to manage enterprise BI solution by implementing both multidimensional and tabular data models, create cubes, dimensions, measure groups and measure. They will learn how to create a multidimensional database with analysis services.

Objectives
  • Create a cubeImplement tabular database

  • Apply DAX to query a tabular model

  • Mining for data for predictive analysis

  • Implement measures and measure groups in a cube

  • Create a multidimensional database with analysis services

Course Outline
  • Business intelligence

  • Data modelling

  • BI solution 

  • Data warehouse

  • Multidimensional databases

  • Cubes and dimensions

  • Measure and measure groups

  • MDX

  • MDX functions

  • Cube functionality

  • Tabular data model

  • Analysis services

  • Data analysis expression DAX

  • Predictive analysis with data mining