All in One Offer! | Access Unlimited Courses in any category starting at just $29. Signup today. Offer Ends in: 6 Days!

Browse Library

Get Unlimited Learning Access
$29
6 days left at this price!
30-Day Money-Back Guarantee

It Includes

  • Get Full Access to the platform
  • Access to 16000+ online courses
  • High Quality Recorded Lectures
  • Learn Online from Mobile/PC/Tablet
  • Assignments & Projects
  • Online iLab Access
  • Certificate of Completion
  • Download for offline viewing
  • Free Instructor Support
  • Access valid for 1 user only
  • Cancel Anytime
$29
  • With this course you will be able to create Customer Sales Data Warehouse project.

The training syllabus covers below labs -
 
Lab 1 :- MSBI Fundamentals, Data flow, Control Flow, ETL, Dataware house. (SSIS)
Lab 1.1 MSBI Installation in Details (Upgrade Lab)
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)
Lab 11: - What are Transactions and CheckPoints in SSIS? (SSIS)
Lab 12: - 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)
Lab 16:- DrillDown and Subreports. (SSRS)
Lab 17 :- 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.
Lab 42: - Perspectives & Translations. (SSAS)
Lab 43 :- Tabular Training 1 :- Installation, Xvelocity, Vertipaq, DAX,Creating cubes,measures, KPI, Partition and Translation?

  • This training help you learn MSBI from scratch with all installations.
  • No experience required
View More...
  • Section 1 : Lab 1 :- MSBI Fundamentals, Data flow, Control Flow, ETL, Dataware house. (SSIS) 1 Lectures 00:50:15

    • Lecture 1 :
    • Lab 1 :- MSBI Fundamentals, Data flow, Control Flow, ETL, Dataware house. (SSIS) Preview
  • Section 2 : Lab 1.1 MSBI Installation in Details (Upgrade Lab) 1 Lectures 00:30:11

    • Lecture 1 :
    • Lab 1.1 MSBI Installation in Details (Upgrade Lab)
  • Section 3 : Lab 2:- Conditional split, Data conversion and Error handling. (SSIS) 1 Lectures 00:33:30

    • Lecture 1 :
    • Lab 2:- Conditional split, Data conversion and Error handling. (SSIS)
  • Section 4 : Lab 3:- For Loop, Variables, Parameters and Debugging. (SSIS) 1 Lectures 00:33:01

    • Lecture 1 :
    • Lab 3:- For Loop, Variables, Parameters and Debugging. (SSIS)
  • Section 5 : Lab 4:- Packaging and Deployment, File component and running SSIS package. 1 Lectures 00:30:04

    • Lecture 1 :
    • Lab 4:- Packaging and Deployment, File component and running SSIS package.
  • Section 6 : Lab 5: - For dimension, star schema, snow flake, packages tasks in SSIS. 1 Lectures 00:30:04

    • Lecture 1 :
    • Lab 5: - For dimension, star schema, snow flake, packages tasks in SSIS.
  • Section 7 : Lab 6:- SCD, Type 0, Type 1, OLEDB Command and Unicode conversions.(SSIS) 1 Lectures 00:47:26

    • Lecture 1 :
    • Lab 6:- SCD, Type 0, Type 1, OLEDB Command and Unicode conversions.(SSIS)
  • Section 8 : Lab 7:- Lookup, Data conversion optimization and updating SSIS package.(SSIS) 1 Lectures 00:39:36

    • Lecture 1 :
    • Lab 7:- Lookup, Data conversion optimization and updating SSIS package.(SSIS)
  • Section 9 : Lab 8:- Sort, Merge and Merge Joins.(SSIS) 1 Lectures 00:20:46

    • Lecture 1 :
    • Lab 8:- Sort, Merge and Merge Joins.(SSIS)
  • Section 10 : Lab 9 :- Creating SSAS Cube. (SSAS) 1 Lectures 00:40:08

    • Lecture 1 :
    • Lab 9 :- Creating SSAS Cube. (SSAS)
  • Section 11 : Lab 10:- SSAS Time series and Excel display.(SSAS) 1 Lectures 00:25:40

    • Lecture 1 :
    • Lab 10:- SSAS Time series and Excel display.(SSAS)
  • Section 12 : Lab 11: - What are Transactions and CheckPoints in SSIS? 1 Lectures 00:25:41

    • Lecture 1 :
    • Lab 11: - What are Transactions and CheckPoints in SSIS? (SSIS)
  • Section 13 : Lab 12 : - Simple SSRS report & implementing Matrix, Tabular, Parameters etc. 1 Lectures 01:01:14

    • Lecture 1 :
    • Lab 12 : - Simple SSRS report & implementing Matrix, Tabular, Parameters etc.
  • Section 14 : Lab 13:- Using Data Profiling task to check data quality. (SSIS) 1 Lectures 00:20:23

    • Lecture 1 :
    • Lab 13:- Using Data Profiling task to check data quality. (SSIS)
  • Section 15 : Lab 14:- Hierarchical Dimensions. (SSAS) 1 Lectures 00:25:59

    • Lecture 1 :
    • Lab 14:- Hierarchical Dimensions. (SSAS)
  • Section 16 : Lab 15 : - WebServices and XML Task. (SSIS) 1 Lectures 00:16:38

    • Lecture 1 :
    • Lab 15:- WebServices and XML Task. (SSIS)
  • Section 17 : Lab 16 : - DrillDown and Subreports. (SSRS) 1 Lectures 00:20:19

    • Lecture 1 :
    • Lab 16 : - DrillDown and Subreports. (SSRS)
  • Section 18 : Lab 17 :- SSAS KPI (Key Performance Indicators). (SSAS) 1 Lectures 00:13:24

    • Lecture 1 :
    • Lab 17 : - SSAS KPI (Key Performance Indicators). (SSAS)
  • Section 19 : Lab 18:- Pivot, UnPivot and Aggregation. (SSIS) 1 Lectures 00:18:30

    • Lecture 1 :
    • Lab 18 : - Pivot, UnPivot and Aggregation. (SSIS)
  • Section 20 : Lab 19 :- SSAS Calculation.(SSAS) 1 Lectures 00:31:35

    • Lecture 1 :
    • Lab 19 :- SSAS Calculation.(SSAS)
  • Section 21 : Lab 20:- SQL Execute Task. (SSIS) 1 Lectures 00:29:31

    • Lecture 1 :
    • Lab 20:- SQL Execute Task. (SSIS)
  • Section 22 : Lab 21:- Reference and Many-to-Many Relationship. (SSAS) 1 Lectures 00:35:40

    • Lecture 1 :
    • Lab 21:- Reference and Many-to-Many Relationship. (SSAS)
  • Section 23 : Lab 22 :- Script Task and Send Mail Task. (SSIS) 1 Lectures 00:15:20

    • Lecture 1 :
    • Lab 22 :- Script Task and Send Mail Task. (SSIS)
  • Section 24 : Lab 23 :- Script component(SSIS) 1 Lectures 00:43:34

    • Lecture 1 :
    • Lab 23 :- Script component(SSIS)
  • Section 25 : Lab 24 :- Bar chart, Gauge and Indicators.(SSRS) 1 Lectures 00:18:00

    • Lecture 1 :
    • Lab 24 :- Bar chart, Gauge and Indicators.(SSRS)
  • Section 26 : Lab 25:- Partitions in SSAS. (SSAS) 1 Lectures 00:24:49

    • Lecture 1 :
    • Lab 25:- Partitions in SSAS. (SSAS)
  • Section 27 : Lab 26 :- CDC(Changed Data Capture) in SSIS. (SSIS) 1 Lectures 00:35:46

    • Lecture 1 :
    • Lab 26 :- CDC(Changed Data Capture) in SSIS. (SSIS)
  • Section 28 : Lab 27:- Additive, Semiadditive and non-additive measures in SSAS.(SSAS) 1 Lectures 00:15:47

    • Lecture 1 :
    • Lab 27:- Additive, Semiadditive and non-additive measures in SSAS.(SSAS)
  • Section 29 : Lab 28:- Buffer Size Tuning (SSIS) 1 Lectures 00:32:31

    • Lecture 1 :
    • Lab 28:- Buffer Size Tuning (SSIS)
  • Section 30 : Lab 29 :- How to implement Multithreading in SSIS?(SSIS) 1 Lectures 00:39:09

    • Lecture 1 :
    • Lab 29 :- How to implement Multithreading in SSIS?(SSIS)
  • Section 31 : Lab 30:- Processing SSAS cube in background.(SSAS) 1 Lectures 00:20:12

    • Lecture 1 :
    • Lab 30:- Processing SSAS cube in background.(SSAS)
  • Section 32 : Explain Asynchronous, Synchronous, Full, Semi and Non blocking Components.(SSIS) 1 Lectures 00:27:11

    • Lecture 1 :
    • Explain Asynchronous, Synchronous, Full, Semi and Non blocking Components.(SSIS)
  • Section 33 : Lab 32 :- SSRS Architecture and Deployment (SSRS) 1 Lectures 00:22:24

    • Lecture 1 :
    • Lab 32 :- SSRS Architecture and Deployment (SSRS)
  • Section 34 : Lab 33 :- DQS( Data Quality Services ) (SSIS) 1 Lectures 00:43:32

    • Lecture 1 :
    • Lab 33 :- DQS( Data Quality Services ) (SSIS)
  • Section 35 : Lab 34 :- Explain Tabular Model and Power Pivot (SSAS). 1 Lectures 00:39:45

    • Lecture 1 :
    • Lab 34 :- Explain Tabular Model and Power Pivot (SSAS).
  • Section 36 : Lab 35 :- MDX (Multidimensional Expressions) Queries.(SSAS) 1 Lectures 00:54:14

    • Lecture 1 :
    • Lab 35 :- MDX (Multidimensional Expressions) Queries.(SSAS)
  • Section 37 : Lab 36 :- Data Mining (Fundamentals and Time Series Algorithm).(SSAS) 1 Lectures 00:30:00

    • Lecture 1 :
    • Lab 36 :- Data Mining (Fundamentals and Time Series Algorithm).(SSAS)
  • Section 38 : Lab 37 :- Page Split and Performance issues with SSIS.(SSIS) 1 Lectures 00:25:06

    • Lecture 1 :
    • Lab 37 :- Page Split and Performance issues with SSIS.(SSIS)
  • Section 39 : Lab 38 :- Aggregations in SSAS.(SSAS) 1 Lectures 00:49:33

    • Lecture 1 :
    • Lab 38 :- Aggregations in SSAS.(SSAS)
  • Section 40 : Lab 39 :- ROLAP, MOLAP and HOLAP.(SSAS) 1 Lectures 00:23:58

    • Lecture 1 :
    • Lab 39 :- ROLAP, MOLAP and HOLAP.(SSAS)
  • Section 41 : Lab 40 :- Instrumentation using Data Taps (SSIS). 1 Lectures 00:15:24

    • Lecture 1 :
    • Lab 40 :- Instrumentation using Data Taps (SSIS).
  • Section 42 : Lab 41:- Lookup caching modes and Cache Transform 1 Lectures 00:28:58

    • Lecture 1 :
    • Lab 41:- Lookup caching modes and Cache Transform
  • Section 43 : Lab 42: - Perspectives & Translations. (SSAS) 1 Lectures 00:13:28

    • Lecture 1 :
    • Lab 42: - Perspectives & Translations. (SSAS)
  • Section 44 : Lab 43 :- Tabular Training 1 :- Installation, Xvelocity, Vertipaq, DAX etc. 1 Lectures 00:55:46

    • Lecture 1 :
    • Lab 43 :- Tabular Training 1 :- Installation, Xvelocity, Vertipaq, DAX etc.
  • How do i access the course after purchase?

    Once you purchase a course (Single course or Subscription), you will be able to access the courses instantly online by logging into your account. Use the user name & password that you created while signing up. Once logged in, you can go to the "My Courses" section to access your course.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certification after completing the course?

    Yes. Once you succesfully complete any course on Learnfly marketplace, you get a certiifcate of course completion emailed to you within 24 hours with your name & the Learnfly badge. You can definately brag about it & share it on your social media or with friends as one of your achievement. Click here to view the sample certificate Click Here
  • For how long can i access my course after the purchase?

    If you buy a single course, that course is accessible to you for a lifetime. If you go for a premium subcription, you can access all the courses on Learnfly marketplace till your subscription is Active.
  • Whats the difference between Single Course Purchase & Go Premium option?

    With Single Course Purchase, you only get an access of one single course. Whereas, with premium monhtly or annual subscription, you can access all the existing or new courses on learnfly marketplace. You can decide what option suits you the best and accordingly you can make your purchase.
  • Is there any free trial?

    Currently, we don't have any free trial but it may be available in near future.
  • What is the refund policy?

    We would hate you to leave us. However, if you are not satisfied, you can ask for a full refund within 30 days & we will be happy to assist you further.

Shivprasad Koirala,

My name is Shivprasad Koirala ( thats my young time photo) , I love teaching and learning , I started QuestPond website 15 years back with the one single goal creating quality step by step IT programming related lessons. I 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.
View More...
  • managing-sql-business-intelligence-operations

    Managing SQL Business Intelligence ...

    By : Microsoft

    Lecture 7
  • infinite-scroll-project-ajax-mysql-api-php-jquery

    Infinite Scroll Project AJAX MySQL ...

    By : Laurence Svekis

    Lecture 19
  • learn-to-build-sql-query-ultimate-sql-and-database-concepts

    Learn to Build SQL Query Ultimate S...

    By : Jazeb Akram

    Lecture 24
  • sql-server-101-microsoft-sql-server-for-absolute-beginners

    SQL Server 101 : Microsoft SQL Serv...

    By : Rashid Khan

    Lecture 44
Sign up and start learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password Request
Enter your email address and we'll send you a link to reset your password.