MSBI(Microsoft Business Intelligence)

MSBI (MICROSOFT BUSINESS INTELLIGENCE) - SQL SERVER 2008 ( SSAS, SSRS)

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