MICROSOFT BI ONLINE TRAINING

KITS Online Training Institute provides best Microsoft BI online training by well trained and certified trainers. This course is designed to provide insights on different tools in Microsoft Suite (SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services). It also gives the practical knowledge on dataware housing  concepts and how these tools help in developing a robust end-to-end BI solution.  This course have 3 modules and they are SSAS, SSIS and SSRS. We are delighted to be one of the best leading IT online training with best experienced IT professionals and skilled resources . We have been offering courses to consultants, companies so that they can meet all the challenges in their respective technologies. Training given by KITS are of high quality and we also provide cost effective learning.

Microsoft BI Course Content

SSAS Course Content

Introduction to SSAS and BI Tool

Using SSAS in BIDS

  • Understanding the development environment
  • Creating Data Sources and Data Source Views
  • Creating cubes – using the UDM and the Cube Build Wizard
  •  Refining Dimensions and Measures in BIDS

Intermediate SSAS

  •    KPIs
  •    Perspectives
  •    Translations – cube metadata and currency localization
  •    Actions – regular, drill-through and reporting

Advanced SSAS

  • Using multiple fact tables
  • Modeling intermediate fact tables
  • Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, writeback dimensions
  • Modeling changing dimensions – Dimension Intelligence w/ Wizard
  • Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence, account intelligence

Cube Storage and Aggregation

  • Storage topics – basic aggregations, MOLAP
  • Advanced Storage Design – MOLAP, ROLAP, HOLAP
  • Partitions – relational and Analysis Services partitions
  • Customizing Aggregation Design – Processing Design
  • Rapidly changing dimensions / ROLAP dimensions
  • Welcome to the Real Time – Proactive Caching
  • Cube processing options

SSAS Administration

  • Best practices – health monitoring
  • XMLA scripting (SQL Mgmt Studio)
  • Security – roles and permissions
  • Disaster Recovery – backup / restore

Introduction to Reporting Clients

  • Excel 2007/  Power pivot
  •  SQL RS & Report Builder
  • Sharepoint Performance Point Services 2010

SSIS Course Content

Introduction to SQL Server Integration Services

Toggle Content goes here

SSIS for DBAs: Using SQL Server Management Studio

Toggle Content goes here

Business Intelligence Development Studio

Introduction to Control Flow

Advanced Control Flow

Introduction to Data Flow

Variables and Configurations

Debugging, Error Handling and Logging

SSIS Package Deployment

SSIS Package Management

SSRS Course Content

Introducing SQL Server Reporting Services

Toggle Content goes here

Creating Reports

Toggle Content goes here

Calculations and Formatting

Report Parameters

Grouping and Sorting

Creating Matrix Reports and Charts

Managing Reporting Services

Programming Reporting Services

Advanced Reporting Services Programming

Using the Reporting Services Web Service
Working with Custom Assemblies

Snapshots and Subscriptions

Request for demo

MSBI Training Video

Other Related Courses