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

Browse Library

  • Business Solutions
  • Become an Instructor
  • 0
    Shopping Cart

    Your Cart is empty. Keep shopping to find a course!

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

This plan includes

  • Instant access to 11,000+ online courses
  • Play & Pause Course Videos
  • HD Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Instructor Chat Support
  • Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
$348 $244 a year Save 30%
5 days left at this price!
Buy Now
30-Day Money-Back Guarantee

This plan includes

  • Instant access to 11,000+ online courses
  • Play & Pause Course Videos
  • HD Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Instructor Chat Support
  • Cancel Plan Anytime
$29
Buy Now
$244

What you'll learn?

  • With this course you will be able to create Customer Sales Data Warehouse project.

Course Overview

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?

See More

Pre-requisites

  • This training help you learn MSBI from scratch with all installations.

Target Audience

  • No experience required
View More...

Curriculum 44 Lectures 22:34:02

  • 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.

Our learners work at

Frequently Asked Questions

  • How do i access the course after purchase?

    It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.

  • 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 certificate for the courses?

    Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.

  • For how long can i access my course on the platform?

    You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.

  • Is there any free trial?

    Currently, we do not offer any free trial.

  • Can i cancel anytime?

    Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

Instructor

Shivprasad Koirala,

0 Course Views

Courses

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...

Student Reviews 4.6

  • Unmatched Variety and Value!
    Learnfly's monthly subscription offers unlimited access to a vast range of courses. Affordable pricing, compared to competitors, makes it the ultimate choice for continuous learning.
    Jessica M.

    4.7

    JM
  • Top-Notch Quality, Affordable Rates!
    High-quality courses with certified instructors make Learnfly stand out. The affordable pricing is a game-changer for those seeking premium education.
    Alex P.

    4.5

    AP
  • Certified Excellence Every Time!
    Learnfly's courses, taught by certified instructors, ensure top-notch learning experiences. The course completion certificates add significant value to one's skill set.
    Sarah R.

    4.3

    SR
  • Round-the-Clock Support!
    Learnfly goes the extra mile with 24/7 course support. Their dedication to helping students succeed is commendable.
    Ryan K.

    4.1

    RK
  • Learn Anywhere, Anytime!
    Whether on mobile, PC, or tablet, Learnfly's platform offers flexibility. Learning on the go has never been easier.
    Emily S.

    4.7

    ES
  • Job-Ready Skills!
    Learnfly's job-oriented courses equip learners with practical skills for the workplace. An investment in career growth!
    Jake M.

    4.2

    JM
  • Budget-Friendly Brilliance!
    Learnfly's pricing is a steal for the quality and variety of courses offered. Quality education without breaking the bank.
    Olivia T.

    4.5

    OT
  • Instructor Excellence Unleashed!
    Learn from the best with Learnfly's certified instructors. The platform ensures that knowledge is imparted by industry experts.
    Daniel L.

    4.0

    DL
  • Achievement Unlocked!
    Learnfly not only offers courses but also recognizes your efforts with course completion certificates. A sense of accomplishment with every course finished.
    Maya H.

    4.6

    MH
  • Learning Revolution!
    Learnfly's platform is a revolution in education. Access to unlimited courses at affordable rates is a game-changer.
    Ethan W.

    4.7

    EW

Students also bought

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

    Infinite Scroll Project AJAX MySQL ...

    By : Laurence Svekis

    Lectures 19 Beginner 1:26:34
  • learn-to-build-sql-query-ultimate-sql-and-database-concepts

    Learn to Build SQL Query Ultimate S...

    By : Jazeb Akram

    Lectures 24 Beginner 2:11:45
  • sql-server-101-microsoft-sql-server-for-absolute-beginners

    SQL Server 101 : Microsoft SQL Serv...

    By : Rashid Khan

    Lectures 44 Beginner 3:47:42
  • sql-nosql-big-data-and-hadoop

    SQL, NoSQL, Big Data and Hadoop

    By : Michael Enudi

    Lectures 129 All Level 19:51:53

Students learning on Learnfly works with Fortune 500 companies around the globe.

Sign Up & Start Learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password
Enter your email address and we'll send you a link to reset your password.