MS BI Online Training

Table of Contents

Introduction to BI Concepts

  • What is BI
  • Tools for BI
  • Goals of BI
  • Dimension and Fact Tables
  • Cube
  • Measure
  • Surrogate Keys
  • Data Warehouse Schemas
    • Star Schema
    • Snow Flake Schema
  • Cube Storage
    • ROLAP
    • MOLAP
    • HOLAP
  • Data Warehouse vs. Data Marts

Introduction to SSIS

  • Understand BIDS Components
  • DTS vs. SSIS
  • Control Flow
  • Data Flow
  • Event Handlers
  • Package Explorer
  • Connection Managers etc

Introduction to Control Flow Items

  • Containers
    • ForLoop Container
    • ForEachLoop Container
    • Sequential Container
  • Predecessor Constraints
  • Control Flow Tasks
    • Data Flow
    • Execute SQL Task
    • File System Tasks
    • DBA Related Tasks etc

SSRS

Introduction to SSRS

SSRS Architecture
Tools in SSRS

  • Report Designer
  • Report Manager
  • Report Builder
  • Tools available in the Market to create Reports
  • Scenarios to use SSRS
  • Lifecycle of the Report (Phases in the Report)
  • What is a Report
  • Data Sources
  • Data Sets
  • Shared Vs Embedded Data Sources/Data Sets
  • Steps to create a Report
  • SSRS Data Regions
  • Table
  • Matrix
  • List
  • Chart
  • Gauge
  • Image
  • Nested Data Regions
  • Sub Reports
  • Indicator etc

Types of Reports

  • Tabular and Matrix Reports.
  • Drill Down Reports.
  • Drill Thru Reports.
  • Parameterized Reports.
    • Single value Parameters.
    • Multiple Value Parameters.
  • Customized Reports using List Control.
  • Nested Data Region Reports.
  • Document Map Reports.
  • Chart, Gauge, Indicator, Image Reports.

SSAS

What Is Microsoft Business Intelligence?

  • Define Business Intelligence.
  • Understand the Cube Structure.
  • Deploy and View a Sample Cube.
  • View a Cube by using Excel.
  • View a Cube by using SQL Reporting Services.

OLAP Modeling

  • Understand Basic OLAP Modeling (star schema).
  • Understand Dimensional Modeling (stars and snowflakes)
  • Understand Measure (fact) and Cube Modeling.
  • Model with SQL Server Business Intelligence Development Studio (BIDS).

Intermediate SSAS

  • Learn how to Create Key Performance Indicators (KPIs).
  • Discover how to Create Perspectives.
  • See how to Create Translations for Cubes and Dimensions.
  • Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting
Quick Entry