Developing SQL Data Models

Course Code:
MS20768

Duration:
3 days
9.00am to 5.00pm
Location:
80 Jurong East Street 21 #04-04
Devan Nair Institute
Singapore 609607
Course Fees:
S$1,800 (excl of G.S.T)
2019 Course Dates
22 – 24 Jul 2019
16 – 20 Sep 2019
18 – 20 Nov 2019
None of the published dates will work for you? Speak to our training consultants for a private tuition arrangement or a closed door training.
Do note that this course listed is a Microsoft Digital Class (DMOC Class). You are required to bring your own device.

Course Overview

This three-day instructor-led course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS.

Program Objectives

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

Course 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

Click Here for full course Outline

Take the Next Step

It Takes Less Than 5 Min