Learn MSBI, SSIS, SSRS, And SSAS Step By Step

This course teaches you MSBI from basic level to advanced level. Covers all 3 concepts SSIS, SSAS, and SSRS.

What you’ll learn

  • Should be able to work on professional MSBI projects. Design database using star schema and snow flake, Create ETL using SSIS, Cubes using SSAS and display reports using SSRS.
  • Learn SSIS Data flow, control flow, error handling, variables, for loop containers, SCD, Sort, Merge, merge joins, lookup, transactions, and checkpoints.
  • Displaying the report in SSRS, Tabular reporting, Matrix reporting, report parameters, sorting, interactive sorting, expressions, running total, cascading dropdowns and importance of RDL files.
  • In SSAS you will learn MDX, tabular, hierarchical dimension, KPI, Calculated members, Aggregations, perspectives, translations, Many to many relationships, reference relationship and processing SSAS cubes at the background.


  • Basic knowledge of SQL would help.
  • No past knowledge of BI or MSBI needed.


If you are thinking about mastering MSBI then you have reached the ultimate tutorial. Yes , i mean by it 🙂 .This course teaches MSBI using 43 extensive labs as listed below. It goes in depth in to all the three important pillars of MSBI i.e. SSIS , SSAS and SSRS.

Lab 1 :- MSBI Fundamentals, Data flow, Control Flow, ETL, Dataware house. (SSIS)

Lab 2:- Conditional split, Data conversion and Error handling. (SSIS)

Lab 3:- For Loop, Variables, Parameters and Debugging. (SSIS)

Lab 4:- Packaging and Deployment, File component and running SSIS package as a task.(SSIS)

Lab 5: – For dimension, measures, star schema, snow flake, shared connection managers & packages tasks.(SSIS)

Lab 6:- SCD, Type 0, Type 1, OLEDB Command and Unicode conversions.(SSIS)

Lab 7:- Lookup, Data conversion optimization and updating SSIS package.(SSIS)

Lab 8:- Sort, Merge and Merge Joins.(SSIS)

Lab 9 :- Creating SSAS Cube. (SSAS)

Lab 10:- SSAS Time series and Excel display.(SSAS)

Lab11: – What are Transactions and CheckPoints in SSIS? (SSIS)

Lab12: – Simple SSRS report & implementing Matrix, Tabular, Parameters, Sorting, Expressions. (SSRS)

Lab 13:- Using Data Profiling task to check data quality. (SSIS)

Lab 14:- Hierarchical Dimensions. (SSAS)

Lab 15:- WebServices and XML Task. (SSIS)

Lab16:- DrillDown and Subreports. (SSRS)

Lab17 :- SSAS KPI (Key Performance Indicators). (SSAS)

Lab 18:- Pivot, UnPivot and Aggregation. (SSIS)

Lab 19 :- SSAS Calculation.(SSAS)

Lab 20:- SQL Execute Task. (SSIS)

Lab 21:- Reference and Many-to-Many Relationship. (SSAS)

Lab 22 :- Script Task and Send Mail Task. (SSIS)

Lab 23 :- Script component(SSIS)

Lab 24 :- Bar chart, Gauge and Indicators.(SSRS)

Lab 25:- Partitions in SSAS. (SSAS)

Lab 26 :- CDC(Changed Data Capture) in SSIS. (SSIS)

Lab 27:- Additive, Semiadditive and non-additive measures in SSAS.(SSAS)

Lab 28:- Buffer Size Tuning (SSIS)

Lab 29 :- How to implement Multithreading in SSIS?(SSIS)

Lab 30:- Processing SSAS cube in background.(SSAS)

Lab 31 :- Explain Asynchronous, Synchronous, Full, Semi and Non blocking Components. (SSIS)

Lab 32 :- SSRS Architecture and Deployment (SSRS)

Lab 33 :- DQS( Data Quality Services ) (SSIS)

Lab 34 :- Explain Tabular Model and Power Pivot (SSAS).

Lab 35 :- MDX (Multidimensional Expressions) Queries.(SSAS)

Lab 36 :- Data Mining (Fundamentals and Time Series Algorithm).(SSAS)

Lab 37 :- Page Split and Performance issues with SSIS.(SSIS)

Lab 38 :- Aggregations in SSAS.(SSAS)


Lab 40 :- Instrumentation using Data Taps (SSIS).

Lab 41:- Lookup caching modes and Cache Transform. (SSAS)

Lab 42: – Perspectives & Translations. (SSAS)

Lab 43 :- Tabular Training 1 :- Installation, Xvelocity, Vertipaq, DAX,Creating cubes,measures, KPI, Partition and Translation?Who this course is for:

  • Developers would want to learn MSBI ( Microsoft SQL Server Business Intelligence)
  • Developers who want to learn SSIS , SSAS and SSRS.
  • If you want to learn how to do ETL with SSIS.
  • if you want to learn Cube making with SSAS.
  • Want to learn SSRS reporting.

Created by Shivprasad Koirala
Last updated 5/2019

Size: 9.91 GB

Leave A Reply

Your email address will not be published.