(1) MSBI

Everything you need to know to master in MSBI

Course Curriculum

First Section

Available in days

days after you enroll

First Lecture
1.Introduction to MSBI (95:50)
Installation Part 1 (23:03)
Installation Part 2 (58:09)
2. FlatFile Export (31:19)
3.Conditional Split and Derived Column (34:04)
4. Data Conversion (16:36)
5. Lookup,Aggregate and Sort Functions (26:30)
6.Merge and UnionAll (16:10)
7.Merge Join and Audit (15:01)
8.SCD and Multicast (15:39)
9.Fuzzy Lookup (18:48)
10.Term Extraction and Copy Column (12:01)
11.Term Lookup and Character Map and Cache Transform (14:26)
12.Pivot and Unpivot (10:29)
13.CS and DC (33:47)
14.WMI Event Watcher Task (20:04)
15.For Each Loop Container Flat file (21:37)
16.For Each Loop Container Single Excel File With Multiple Sheets (8:12)
17.For Each Loop Container Multiple Excel Files (13:02)
18.For Each Loop Container Multiple Excel File With Multiple Sheets (10:59)
19.Data Profiling Task (13:52)
20.Job Scheduling (5:22)
21.Package Deployment (36:05)
22.Scenarios Part 1 (65:34)
23.Scenarios Part 3 (56:00)
24.Scenarios Part 4 (49:43)
25.Scenarios Part 5 (42:14)
26.Scenarios Part 6 (36:34)
27.Scenarios Part-7 (21:03)
28.Data warehousing (49:11)
29.Multidimentional Cube (48:26)
30.MDX (17:55)
31.Multidimentional Vs Tabular Cube (61:02)
32.SSAS Task Execution through SSIS (24:14)
33.Data Mining (36:58)
34.SSRS Introduction (29:47)
35.SSRS Reports (32:09)
36.SSRS Report Deployment (5:09)

Frequently Asked Questions

When does the course start and finish?

The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.

How long do I have access to the course?

How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own

Can I share my login with others?

No! Sharing login details with others is strictly prohibited. If detected we will revoke your access to the site without prior notice