fbpx

Course Statues

Registration Open

Duration

6 Days, 42 Hours

Timing

9:00 AM - 04:00 PM

Availability

Weekdays - Weekends

Course Overview

Developing SQL Data Models course aimed at database professionals who need to fulfill a BI Developer role to create enterprise BI solutions. The course focuses on how to create 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.

Learning Outcome

Upon successful completion of developing SQL data models 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
Prerequisite
  • Must have a working knowledge of Transact-SQL.
  • Must have a working knowledge of relational databases.
Course Content
  • Introduction to Business Intelligence and Data Modelling
  • Creating Multidimensional Databases
  • Working with Cubes and Dimensions
  • Working with Measures and Measure Groups
  • Introduction to MDX
  • Customizing Cube Functionality
  • Implementing a Tabular Data Model by Using SQL Server Analysis Services
  • Introduction to Data Analysis Expressions (DAX)
  • Performing Predictive Analysis with Data Mining

Book your course today

Loading...

Enquire Now

Courses you maybe interested