SQL Server Analysis Services (SSAS) Training Course and Workshop in Bangalore, Mysore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Kolkata

In Microsoft SQL Server Analysis Services (SSAS) training course, you will learn to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups.

By attending Microsoft SQL Server Analysis Services (SSAS) workshop, delegates will learn:

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

Basic knowledge of the Microsoft Windows operating system and its core functionality
Working knowledge of Transact-SQL
Working knowledge of relational databases

The SQL Server Analysis Services (SSAS) class is intended for Data analysts, power information workers and database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions.

Introduction to Business Intelligence and Data Modeling

Introduction to Business Intelligence
Microsoft Business Intelligence Platform

Create Multidimensional Databases

Introduction to Multidimensional Analysis
Create Data Sources and Data Source Views
Cubes
Overview of Cube Security
Configure SSAS
Monitoring SSAS

Working Cubes and Dimensions

Configure Dimensions
Define Attribute Hierarchies
Implementing Sorting and Grouping Attributes
Slowly Changing Dimensions

Working with Measures and Measure Groups

Working with Measures
Working with Measure Groups

Introduction to Multidimensional Expressions (MDX)

MDX Fundamentals
Add Calculations to a Cube
Use MDX to Query a Cube

Customize Cube Functionality

Implement Key Performance Indicators
Implement Actions
ImplementPerspectives
Implement Translations

Implement a Tabular Data Model by Using Analysis Services

Introduction to Tabular Data Models
Create a Tabular Data Model
Use an Analysis Services Tabular Model in an Enterprise BI Solution

Introduction to Data Analysis Expression (DAX)

DAX Fundamentals
Using Dax to create Calculated Columns and Measures in a Tabular Data Model

Perform Predictive Analysis with Data Mining

Overview of Data Mining
Create a Custom Data Mining Solution
Validate a Data Mining Model
Connecting to and Consume a Data Mining Model
Using the Data Mining add-in for Excel

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
All courses are delivered by Industry Veterans
Get jumpstarted from newbie to production ready in a matter of few days

Trained more than 50,000 Corporate executives across the Globe
All our trainings are conducted in workshop mode with more focus on hands-on sessions

Microsoft SQL Server Analysis Services (SSAS)

COURSE AGENDA