Developing SQL Data Models


Duration : 3 Days

Course Contents

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

At course completion:

After completing this course, students will be able 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

Customize a cube

Implement a tabular database

Use DAX to query a tabular model

Use data mining for predictive analysis

Prerequisites

Before attending this course, students must have:

Experience of querying data using Transact-SQL

Regular Price : $1350.00
Special Price :$900.00

Upcoming Schedules

Start Date End Date Delivery Location Details
For any custom schedule, please email us at support@gtechlearn.com or Call us at +1 951.405.4345


This course includes:

  • 24x7 Lab Access during your Training
  • Official Courseware
  • Free retake upto 6 months
  • Post Training Support
  • Experienced Instructors
  • Train from AnyWhere