MSBI

Course Overview:

Microsoft Business Intelligence Training makes you master Business intelligence and data mining tools. In this course, you will learn how to integrate, analyze, report the SQL server. MSBI course allows you to configure and use the business intelligence tools. This training injects you the required knowledge on ETL Solutions, SSIS packages, OLTP, OLAP, how to configure SSRS, etc. With the MSBI tools, companies can make the right decisions and can implement their plans immediately. 

Course Content:

Introduction

♦ What is a 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.

We can assure a 100% job guarantee and Placement. Contact us for Free - Demo.