MSBI Training

MSBI Course Syllabus

Introduction of Data Warehouse

  • What is Data Warehouse?
  • Why choose MSBI?
  • Various Keys used
  • Star Vs Snowflake schema

Introduction to MSBI

  • ETL – SSIS
  • Reporting – SSRS
  • OLAP - SSAS

ETL – SSIS

  • Variables
  • Connection Managers
  • Control Flow
  • Data Flow Task
  • Data Sources, Destinations, Transformations
  • Data Viewer
  • FTP, emails, scripts
  • Breakpoints
  • Configuration and Deployment

Reporting – SSRS

  • Shared Data Sources, Data Sets
  • Parameters
  • Tables, Matrix, Charts, Graphs, Gauges, Indicators
  • Summary and Detail reports
  • Drill down, drill through, sub reports, nested data region reports
  • Report Manager
  • Reporting Services
  • Deployment

OLAP – SSAS

  • What is OLAP?
  • Multi-dimensional data structures
  • Cubes, Dimensions, Attributes, Members, Hierarchies, Relationships
  • MDX
  • Aggregations, Partitions, KPIs, Actions.
  • Deployment
Quick Enroll