Microsoft Business Intelligence - MSBI Online Training (LIVE, Instructor-Led)

This Online MSBI Training includes basic to advanced Business Intelligence, Data Warehouse (DWH) and Data Analytics (OLAP) concepts on SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). This training course will include 100% practical classes which includes all the transformations, report generation and cube designing. Complete practical and real-time MSBI Training course with 24x7 availability, Resume preparation, ONE Real-time Project with Interview & Placement Assistance.

Pre-requisites: Nothing, We will start training from Scratch

MSBI (SSIS, SSAS, SSRS) Training Plans

  COURSE A COURSE B
Description MSBI SQL with MSBI
Total Duration 4-6 Weeks 5-7 Weeks
SSIS: ETL in detail Check-Symbol-for-Yes Check-Symbol-for-Yes
Every Transformations,Tasks, Containers Check-Symbol-for-Yes Check-Symbol-for-Yes
Parameters and Environments Check-Symbol-for-Yes Check-Symbol-for-Yes
SSAS: DataWarehousing in Detail Croos-symbol-for-No Check-Symbol-for-Yes
Datawarehouse Design Croos-symbol-for-Yes Croos-symbol-for-Yes
Cube Design Croos-symbol-for-Yes Croos-symbol-for-Yes
Cube Deployment Croos-symbol-for-Yes Croos-symbol-for-Yes
SSRS: Report Generation Croos-symbol-for-No Check-Symbol-for-Yes
Report Deployment Croos-symbol-for-No Check-Symbol-for-Yes
Basic SQL, SQL Server, T-SQL Croos-symbol-for-No Check-Symbol-for-Yes
Joins, Queries, Stored Procedures Croos-symbol-for-No Check-Symbol-for-Yes
Projects Croos-symbol-for-Yes Check-Symbol-for-Yes
Resume Preparation Croos-symbol-for-Yes Check-Symbol-for-Yes
Total Course Fee INR 13,500
USD 200
INR 17,000
USD 250

Separate batch for every individual

Schedules for MSBI Training
S.No Timings (IST)   Trainer
1 6:30 to 7:30 AM Register Mr. Piyush Agrawal
2 7.30 to 8:30 AM Register
3 8:30 to 9:30 AM Register
4 9:30 to 10:30 AM Register
5 6:30 to 7:30 PM Register
6 7.30 to 8:30 PM Register
7 8:30 to 9:30 PM Register
8 9:30 to 10:30 PM Register
9 10.30 to 11.30 PM Register

MSBI Training (SSIS, SSAS, SSRS) Syllabus:

Register Today

  • SQL Server database Overview.
  • Different Types of Keys (PK and FK)
  • What is DDL, DML
  • Data Types
  • What are Constraints (Identity, Unique, Check, NULL, Default)
  • Aggregates
  • Where
  • Group by
  • Having
  • Temp tables
  • Table Variables
  • Select, Distinct, Top, (Ranking, Scalar Functions, Date Functions)
  • Joins
  • Sub Queries
  • Views
  • CTE
  • Cursor
  • Stored Procedures
  • User Defined Functions (String, Table value, Cross Apply)
  • Triggers
  • Introduction to SSIS Packages
  • Introduction of (BIDS) and Explanation of All tool boxes, Solution Explorer, Package
  • variables
  • Import and Export Wizard, Control Flow and Dataflow tasks
  • Control Flow tasks like Execute SQL Task, BULK insert tasks, File System tasks , The
  • FTP Task
  • Dataflow tasks and transformations introduction
  • Data sources, Data transformations, Copy column Transformation, Derived Column
  • transformation, Conditional Split and Aggregate Transformation, Sort
  • Transformation and Data Viewers.
  • Slowly Changing Dimension (SCD) Concepts and its Transformations.
  • How to implement Check points.
  • SSIS Package Deployment and Package Management like how to schedule package,
  • DTUtil and DTExec command.
  • Introduction to Data Warehousing, OLTP, OLAP
  • Understanding Dimension Modelling
  • Creating Data source and Data source views
  • Creating the Cube through Wizard and through UDM.
  • Creating Dimensions and Measures in SSAS and how to add those in Cube.
  • Partitions and Aggregations Design in cube and Processing Options in cube.
  • What is Build, Deploy and process in cube?
  • How to do Slice and Dice in the Cube.
  • How to retrieve the data in Cube i.e. Through MDX.
  • Different Options for Deploying a Cube.
  • How to take the report from Cube in Excel
  • What is the Terminology involved in SSRS, SSRS Architecture and how to configure
  • SSRS?
  • What is Shared Data source and How to Create an Ad-hoc Report from Wizard.
  • Creating Expressions and Conditional Formatting.
  • How to Calculate Total and Percentage and how to create Drill-Down reports.
  • Creating Report Parameter and Debugging Parameter issues.
  • How to create a Basic Matrix Report, Tablix Report and Charts.
  • How to Create a Standard and Data-driven Subscription and managing subscriptions.
  • Managing Reports, Security and how to use Web-based Report Manager.
Register Today For Free Demo Please Call Us Or Register In Our Website, We Will Contact You Soon.

Registration Form :

Name*
Email*
Mobile Number*
Course*
Experience*