20768C: Developing SQL Data Models Training

Course 20768C: Developing SQL Data Models Training

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.The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions.

✔ Course Duration : 24 hrs

✔ Training Options : Live Online / Self-Paced / Classroom

✔ Certification Pass : Guaranteed

Overview

What you will Learn

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

Experience of querying data using Transact-SQL

CURRICULUM

Learning Objectives:

This module introduces key BI concepts and the Microsoft BI product suite.

Lessons:

Introduction to Business Intelligence

The Microsoft business intelligence platform

Lab : Exploring a BI Solution

Exploring a Data Warehouse

Exploring a data model

Learning Objectives:

This module describes how to create multidimensional databases using SQL Server Analysis Services.

Lessons:

Introduction to Multidimensional Analysis

Data Sources and Data Source Views

Cubes

Overview of Cube Security

Configure SSAS

Monitoring SSAS

Lab : Creating a multidimensional database

Creating a Data Source

Creating and Configuring a data Source View

Creating and Configuring a Cube

Adding a Dimension to a Cube

Learning Objectives:

This module describes how to implement dimensions in a cube.

Lessons:

Configuring Dimensions

Defining Attribute Hierarchies

Implementing Sorting and Grouping Attributes

Slowly Changing Dimensions

Lab : Working with Cubes and Dimensions

Configuring Dimensions

Defining Relationships and Hierarchies

Sorting and Grouping Dimension Attributes

Learning Objectives:

This module describes how to implement measures and measure groups in a cube.

Lessons:

Working with Measures

Working with Measure Groups

Lab : Configuring Measures and Measure Groups

Configuring Measures

Defining Regular Relationships

Configuring Measure Group Storage

Learning Objectives:

This module describes the MDX syntax and how to use MDX.

Lessons:

MDX fundamentals

Adding Calculations to a Cube

Using MDX to Query a Cube

Lab : Using MDX

Querying a cube using MDX

Adding a Calculated Member

Learning Objectives:

This module describes how to customize a cube.

Lessons:

Implementing Key Performance Indicators

Implementing Actions

Implementing Perspectives

Implementing Translations

Lab : Customizing a Cube

Implementing an action

Implementing a perspective

Implementing a translation

Learning Objectives:

This module describes how to implement a tabular data model in Power Pivot.

Lessons:

Introduction to Tabular Data Models

Creating a Tabular Data Model

Using an Analysis Services Tabular Data Model in an Enterprise BI Solution

Lab : Working with an Analysis Services Tabular Data Model

Creating an Analysis Services Tabular Data Model

Configure Relationships and Attributes

Configuring Data Model for an Enterprise BI Solution.

Learning Objectives:

This module describes how to use DAX to create measures and calculated columns in a tabular data model.

Lessons:

DAX Fundamentals

Using DAX to Create Calculated Columns and Measures in a Tabular Data Model

Lab : Creating Calculated Columns and Measures by using DAX

Creating Calculated Columns

Creating Measures

Creating a KPI

Creating a Parent – Child Hierarchy

Learning Objectives:

This module describes how to use data mining for predictive analysis.

Lessons:

Overview of Data Mining

Creating a Custom Data Mining Solution

Validating a Data Mining Model

Connecting to and Consuming a Data-Mining Model

Using the Data Mining add-in for Excel

Lab : Using Data Mining

Creating a Data Mining Structure and Model

Exploring Data Mining Models

Validating Data Mining Models

Consuming a Data Mining Model

Using the Excel Data Mining add-in

FAQs

You can enroll for this classroom training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.
1. Online ,By deposit the mildain bank account
2. Pay by cash team training center location

Highly qualified and certified instructors with 20+ years of experience deliver more than 200+ classroom training.

Contact us using the form on the right of any page on the mildaintrainings website, or select the Live Chat link. Our customer service representatives will be able to give you more details.

You will never miss a lecture at Mildaintrainigs! You can choose either of the two options: View the recorded session of the class available in your LMS. You can attend the missed session, in any other live batch.

We have a limited number of participants in a live session to maintain the Quality Standards. So, unfortunately, participation in a live class without enrollment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in a class.

Yes, you can cancel your enrollment if necessary prior to 3rd session i.e first two sessions will be for your evaluation. We will refund the full amount without deducting any fee for more details check our Refund Policy

Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

Just give us a CALL at +91 8447121833 OR email at info@mildaintrainings.com

Call us At