MSBI(Microsoft Business Intelligence)


SSAS Course Objectives

Module 1: Understanding BI and Data warehousing
Data warehouse concepts,

Data warehouse Architecture

Difference between Ralph Kimball and Bill Inmon’s


What is Business Intelligence?

Difference between OLTP vs. OLAP


Module 2: Architecture and Understanding Analysis Services
Understanding of OLAP, MOLAP, ROLAP

What is SSAS? Need for SSAS

SSAS Architecture

Understanding of CUBE Structure


Understanding of Schemas (Star, Snowflake)

Data Source usage, Data Source View

Computed and Named Queries


Module 3: Designing and Creating Dimensions
Understanding of Dimension Table

Creating Dimension Table

Understanding of Parent – Child Dimension


Building Levels, Understanding of Fact Table

Creating Fact Table


Module 4: Designing Measures, Measure Group and Aggregations
Measures and Additives, Semiadditive Measures

Understanding of Aggregation

Designing User Hierarchies

Optimizing Aggregation, Query Log

Usage Based Optimization

Cube Operations – Dimension usage and Flexible cubes

Building Fact-Dimension, Creating Calculation,

MDX Scripting for Calculation


Defining KPI’s and usage

Partitioning, Perspective and usage

What is MDX? Need of MDX

MDX Basics, Complex MDX Queries,

MDX Functions

What is Data mining? Need for Data Mining

Data mining structures and Algorithm

Data mining levels, operating predictions

Prediction Functions and Analysis

Module 5: Implementing Security and Managing Deployment
Using Role based security, Object level access

Drill through Security, Windows Level Authentication, Security Audits.

Deployment phases: OLAP Database Backups, Compression and Encryptions


Restore Option, Write – Backs in Cube

Automating Database Processing using SSIS

Verification Techniques

Managing Deploy Process

Best Practices in SSAS, Real Time Scenario Discussion

After completing of this course students will able to do: Design CUBE -OLAP DB


SSRS Course Objectives                                                                                        

Module 1: Architecture and Introduction to SQL Server Reporting Services.
Understanding of Reports,

Introduction to SSRS,

Need for SSRS

Reporting Services

SSRS three phase Lifecycle



SSRS Architecture

Reporting components, Tools, Web Service Requirements and usage

SSRS and IIS, and SQL Server Web Services

Requirement for Virtual Directories

Module 2: Designing and Implementation of Reporting Services Projects
Report planning, Data Sources,

Enterprise and Adhoc-reports

Optimizing Data Sources

Configuring connection and Data providers

SSRS Expression,

Parameter and Multi valued Parameter

Filters in Data source

Report Designer: Wizard based reports, custom reportsUsing Table and Matrix

Chart based report and images


Sub Reports, Reporting Option,

Tabular Reports

Exporting Reporting data


Module 3: Use report models to implement reporting for business users
Understanding of Report models

Designing Report models

Identifying Entities


Identifying different Attributes

Numerical Aggregation,

Time Aggregation


Module 4: Configure report publishing and execution settings
Deployment Option

Build and Deploy, publishing reports


Configuration Option

Managing Configuration Files

Module 5: Implementing subscription for reports
Creating Standard Subscription

Data Driven Subscription

Subscription Logging options

Benefits of SSRS Logging


Server Level Logging Options

Report level logging

Audit reports execution


Best Practices in SSRS, Real Time Scenario Discussion

After completing of this course students will able to do: Design Reports, publish reports subscription of the reports.

After completing of MSBI course students will able to give solution to Business and handle the MSBI Projects, will become MSBI Developer

Powered by Sunsys Technologies