Learn MSBI , SSIS , SSRS and SSAS Step by Step (Udemy.com)
This course teaches you MSBI from basic level to advanced level . Covers all 3 concepts SSIS , SSAS and SSRS.
Created by: Shivprasad Koirala
Last updated July 2022
What you will 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 ,look up , transactions and checkpoints.
- Displaying report in SSRS, Tabular reporting , Matrix reporting , report parameters , sorting , interactive sorting, expressions, running total , cascading drop downs and importance of RDL files.
- In SSAS you will learn MDX , tabular , hierarchical dimension , KPI , Calculated members , Aggregations , perspectives , translations , Many to many relationship , reference relationship and processing SSAS cubes at background.
How it compares
Against the other 371 rated Udemy courses in Data Analysis on CourseDuck:
- Rating4.6 out of 5higher than 73% of them
- Reviews4,696#51 of 372 by number of reviews
- Length22.8 hourslonger than 94% of them
- Last updatedJuly 2022earlier than 79% of them
Course Description
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 39 :- ROLAP, MOLAP and HOLAP.(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?
Instructor Details
- 4.6 Rating
4,696 Reviews
Shivprasad Koirala
My name is Shivprasad Koirala, We love teaching and learning, We started the QuestPond website 15 years back with the one single goal of creating quality step by step IT programming related lessons.
We saw many lessons online, either they are done too fast or too slow or are too complicated.
The main goal of Questpond is to create Step by Step lessons on C#, ASP.NET , Design patterns , SQL and so on. As years moved on i added other step by step lessons like Angular , Sharepoint , MSBI, Azure and so on.
More courses by Shivprasad Koirala
.NET / C# Interview Questions with Answers. (2025)
4.6 (3,297 Reviews)
Provider: Udemy
Time: 9.2h
$74.99
Angular interview questions with answers (2023)
4.5 (2,822 Reviews)
Provider: Udemy
Time: 2.7h
$64.99
ASP.NET MVC Interview Questions with Answers (2023)
4.4 (1,211 Reviews)
Provider: Udemy
Time: 3.3h
$10.99
More Data Analysis courses
Complete neural signal processing and analysis: Zero to hero (2026)
4.8 (2,013 Reviews)
Provider: Udemy
Time: 46.9h
$12.99
Excel for Business Analysts Online Course (2023)
4.8 (636 Reviews)
Provider: Udemy
Time: 9.3h
$74.99
Alteryx Designer Advanced Certification Mega Bundle (2023)
4.8 (468 Reviews)
Provider: Udemy
Time: 16.9h
$69.99
Reviews
By Vito Schittone on 1/7/2023
I'm only half way through the course, I might amend this later ..... I feel like it started strong/ but through some of the middle videos (Lab 20) the presenter hasn't got things working first time, that's fine, he explained how to fix it, that's also fine. But from a learning process, it would be better to say "I am going to make a mistake here on purpose which will impact on this later, so you can understand how this process is working". I feel like the balance between 'learning it wrong' and 'learning it constructively' sometimes he is going the wrong way. In that, I don't need be shown the wrong way first time if doesn't work and don't let me think doing it right the first time, if presenter feels important, he needs to break it down. So, I finding that bit annoying it's fine balance, is a way to learn through mistakes, but it’s a balance, has to be constructively rather than “surprise! Error is here now we fix it” Maybe without those errors be more done with the course, could just like voice over current video leave pauses for longer if ever did do an update. I've put it 'Average/ Good' category .... if was cleaned up (I used to work presenting with data) it would be close to the 'Good, What I Expected' or even 'Amazing' - close to being excellent. These fractions, little things with screen not being in view (I can work around, seen the screen once, enough) difference between overall course rating of less then 4.5 or 4.5 or more than when added up
By Danielle Converse on 12/27/2020
I am starting this over for the third time in order to try and do what is required to complete the course (and I haven't been using the 2019 version of anything). It may be old enough that it should be replaced by a different course.
By Panagiotis Fiampolis on 12/20/2020
Very focused on the subject and very well explained.
By Masood Joukar Boneh Abedi on 12/20/2020
I am a junior BI developer. I recommend this course to anybody, who is starting this career. Topppp course !
By Nerusupalli Nagamohan Reddy on 12/17/2020
The course was really an expectation, but it took me nearly 20 days to complete while following each video and making my hands dirty with practices. Thank you to the team which has given me nice training. Cheers!!!!!
By Rabson Lungu on 12/13/2020
Valuable lecture delivered with clear explanation.
By Alok Srivastava on 12/6/2020
yes so far so good
By Bhagyashree Jonalagadda on 12/6/2020
There are so many things skipped in the video ,I need to look for those things outside. I really wish at least for the coming video the whole info is present .
By Somika Simlote on 12/6/2020
very nice
By Omar E Valerio on 11/27/2020
So far so good
Nice course structure
By Rohit Singh on 11/21/2020
Very nice content. One can learn SSIS, SSAS, SSRS in a very interesting way. The dedication of instructor is appreciable. Thanks a lot for such great videos. It was a very great experience learning MSBI.
By John Anane on 11/21/2020
After the first lesson I found it interesting and informative. It is something I will like to pursue further to my newly Data Analysis course. I think this first lesson was overview of what is to come in bits and pieces if I am right. Yes! I really want to follow this through. Thanks
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 92 / 100












