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