Project based MSBI & SQL Training step by step

28 Hours Live Training | By Shivprasad & Guru

Project based MSBI & SQL Training step by step

Batch : 5 Students

Trainer : Shivprasad & Guru

Training Starts : 15th November 2020    Total Training Hours : 28 Hours

Training Process

On Weekdays : Monday & Wednesday 10:00 AM - 11.00 AM

On Weekends : Saturday & Sunday 10:00 AM - 11.00 AM

37000 OR 530

: (+91) 99675 90707, (+91) 96198 42789, (+91) 9769000232

Buy now

What you'll learn :

It is a 45 Days combined Training & Practicals on MSBI (SSIS, SSRS & SSAS) & SQL Server.
8 Months Video Subscription Program.
Doubt clearing related to Training Program.

Our Demo Video :


Our Demo Video 2 :


Learn MSBI in 45 Days(Project Based) -

Theory (30 Minutes) -
  • Introduction of MSBI (SSIS, SSAS, SSRS), MSBI Tools.
Installation (60 Minutes) -
  • MSBI Installation like Vsiual Studio, SQL Server, SQL Server Management Studio, SSDT Tools.
Practicals (24 Hours) -
  • Lab 1 - ETL process (Extracting Data From Excel or CSV and Adding it Dataware House SQL Server DB).
  • Lab 2 - SSIS Conditional Split, Derived Component and Data Conversion Component.
  • Lab 3 - SSIS Error Handlings.
  • Lab 4 - Understand SSIS Loops
  • Lab 5 - SSIS Parameters, Environment Variables, File System Task, Package Deployment, Scheduling SSIS Package From SQL Server.
  • Lab 6 - Understand Sort and Types of Joins in SSIS and Insert Update Data using Merge Join.
  • Lab 7 - Understand OLAP, Star Schema, SnowFlake, Dimension and Facts and SSIS SCD and Lookup.
  • Lab 8 - SSIS Data Profiling Task and Check Data Quality.
  • Lab 9 - Designing Star Schema in SSIS.
  • Lab 10 - Adding SSAS cube with Time Series to Star Schema with Excel Display
  • Lab 11 - SSAS Hierarchical Dimensions.
  • Lab 12 - Adding SSRS Report to Star Schema.
  • Lab 13 - SSRS Reports (Matrix Tabular, Expression Parameters).
  • Lab 14 - SSRS DrillDown and Subreports.
  • Lab 15 - SQL Execute Task (SSIS).
  • Lab 16 - SSAS KPI, Calculations and Many-to-Many Relationship in (SSAS).
  • Lab 17 - Understand MDX (Multidimensional Expressions) Queries.
  • Lab 18 - SSRS Bar Chart, Gauge and Indicators.
  • Lab 19 - Understand Simple demo of WebServices and XML Task using WCF C# Code
  • Lab 20 - SSIS DQS (Data Quality Service).
  • Lab 21 - Script Component and Mailing.
  • Lab 22 - CDC in SSIS.
  • Lab 23 - SSAS Pivot, UnPivot and Aggregation.

Learn SQL Server Step by Step -

  • Lab 1 - Introduction to SQL Server, RDBMS.
  • Lab 2 - Installation of SQL Server and SQL Management Studio (Optional).
  • Lab 3 - Security Windows and SQl Server authentication.
  • Lab 4 - Basic Fundamentals Create DataBase and Create Tables, Rows and Columns.
  • Lab 5 - Data Types in SQL, Auto Increment Primary Key / Unique Key / Referential Integrity and Constraints.
  • Lab 6 - SQL Query writing  : Create, Select, Insert, Alter, Delete, Update, Order By, Where Clause, Group By, AND, OR, NOT, Between, IN, Aliases, Having.
  • Lab 7 - SQL Wildcards.
  • Lab 8 - SQL Mathematical functions like Min, Max, Avg, Sum, Count, ABS, Round, Ceil and many more.
  • Lab 9 - SQL JOINS .
  • Lab 10 - SQL Stored Procedures.
  • Lab 11 - SQL Normalization and Denormalization (OLTP  and OLAP).
  • Lab 12 - Star Schema and SnowFlake.

Best Seller
  • Project based MSBI & SQL Training step by step


  • Email: questpond@questpond.com
  • Phone: (+91) 99675 90707, (+91) 96198 42789, (+91) 9769000232