MSBI Step by Step Training

Learn step by step MSBI using 43 extensive labs.

MSBI Step by Step Training

Learn step by step MSBI using 43 extensive labs.
798
views
1
Save
Share the link to this page
Copied

About the Class

In this step by step training will be covering the following lessons -

  • 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, snowflake, 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 an 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 the 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 the 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?

Author

Quest Pond

Renowned Trainer and Author MR SHIVPRASAD KOIRALA and Questpond make a team of top MVP recognized professionals in the Microsoft domain. Since 2001, we have trained many professionals in technologies like OOP, ASP.NET, SQL Server, WCF, WPF, WWF, Silverlight, LINQ, Azure, Architecture and Project Management. Questpond is famous for online...

School

Quest Pond's School

Requirements

You should have basic knowledge of SQL.

Class Contents

One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€67.09
List Price:  €95.85
You save:  €28.75
£55.67
List Price:  £79.54
You save:  £23.86
CA$100.61
List Price:  CA$143.73
You save:  CA$43.12
A$111.94
List Price:  A$159.93
You save:  A$47.98
S$94.87
List Price:  S$135.54
You save:  S$40.66
HK$544.46
List Price:  HK$777.83
You save:  HK$233.37
CHF 62.54
List Price:  CHF 89.34
You save:  CHF 26.80
NOK kr792.28
List Price:  NOK kr1,131.88
You save:  NOK kr339.60
DKK kr500.54
List Price:  DKK kr715.08
You save:  DKK kr214.54
NZ$123.72
List Price:  NZ$176.75
You save:  NZ$53.03
د.إ257.07
List Price:  د.إ367.26
You save:  د.إ110.19
৳8,361.37
List Price:  ৳11,945.33
You save:  ৳3,583.95
₹5,945.38
List Price:  ₹8,493.77
You save:  ₹2,548.38
RM315.51
List Price:  RM450.75
You save:  RM135.24
₦108,452.30
List Price:  ₦154,938.50
You save:  ₦46,486.20
₨19,476.23
List Price:  ₨27,824.38
You save:  ₨8,348.15
฿2,393.75
List Price:  ฿3,419.79
You save:  ฿1,026.04
₺2,463.20
List Price:  ₺3,519.01
You save:  ₺1,055.81
B$425.95
List Price:  B$608.53
You save:  B$182.58
R1,281.50
List Price:  R1,830.80
You save:  R549.29
Лв131.12
List Price:  Лв187.32
You save:  Лв56.20
₩101,234.93
List Price:  ₩144,627.53
You save:  ₩43,392.60
₪255.76
List Price:  ₪365.39
You save:  ₪109.63
₱4,117.86
List Price:  ₱5,882.91
You save:  ₱1,765.05
¥10,950.28
List Price:  ¥15,643.93
You save:  ¥4,693.65
MX$1,405.25
List Price:  MX$2,007.58
You save:  MX$602.33
QR255.07
List Price:  QR364.41
You save:  QR109.33
P967.09
List Price:  P1,381.63
You save:  P414.53
KSh9,046.20
List Price:  KSh12,923.70
You save:  KSh3,877.50
E£3,561.31
List Price:  E£5,087.81
You save:  E£1,526.49
ብር8,934.81
List Price:  ብር12,764.56
You save:  ብር3,829.75
Kz64,250.82
List Price:  Kz91,790.82
You save:  Kz27,540
CLP$69,230.60
List Price:  CLP$98,905.10
You save:  CLP$29,674.50
CN¥510.67
List Price:  CN¥729.56
You save:  CN¥218.89
RD$4,260.81
List Price:  RD$6,087.13
You save:  RD$1,826.32
DA9,439.27
List Price:  DA13,485.25
You save:  DA4,045.98
FJ$162.13
List Price:  FJ$231.62
You save:  FJ$69.49
Q539.13
List Price:  Q770.23
You save:  Q231.09
GY$14,638.94
List Price:  GY$20,913.67
You save:  GY$6,274.72
ISK kr9,737.70
List Price:  ISK kr13,911.60
You save:  ISK kr4,173.90
DH704.21
List Price:  DH1,006.07
You save:  DH301.85
L1,285.64
List Price:  L1,836.70
You save:  L551.06
ден4,129.86
List Price:  ден5,900.06
You save:  ден1,770.19
MOP$560.15
List Price:  MOP$800.26
You save:  MOP$240.10
N$1,288.20
List Price:  N$1,840.36
You save:  N$552.16
C$2,574.79
List Price:  C$3,678.42
You save:  C$1,103.63
रु9,517.84
List Price:  रु13,597.49
You save:  रु4,079.65
S/260.55
List Price:  S/372.23
You save:  S/111.68
K283.74
List Price:  K405.36
You save:  K121.62
SAR262.92
List Price:  SAR375.62
You save:  SAR112.69
ZK1,936.44
List Price:  ZK2,766.46
You save:  ZK830.02
L333.95
List Price:  L477.10
You save:  L143.14
Kč1,686.22
List Price:  Kč2,408.98
You save:  Kč722.76
Ft27,781.13
List Price:  Ft39,689.03
You save:  Ft11,907.90
SEK kr772.16
List Price:  SEK kr1,103.13
You save:  SEK kr330.97
ARS$71,509.21
List Price:  ARS$102,160.40
You save:  ARS$30,651.18
Bs483.51
List Price:  Bs690.76
You save:  Bs207.25
COP$305,137.08
List Price:  COP$435,928.80
You save:  COP$130,791.72
₡35,302.85
List Price:  ₡50,434.81
You save:  ₡15,131.95
L1,776.18
List Price:  L2,537.51
You save:  L761.33
₲545,595.73
List Price:  ₲779,455.88
You save:  ₲233,860.15
$U3,131.93
List Price:  $U4,474.38
You save:  $U1,342.44
zł286.05
List Price:  zł408.66
You save:  zł122.61

What's Included

Language: English
Level: Beginner
Skills: Error Handling, Multidimensional Expressions, MDX, Hierarchical Dimension, SSIS, Data Mining, KPI, Data Conversion, MSBI Fundamentals
Duration: 22 hours 39 minutes
44 Videos
1
Save
798
Views
This class has not been saved

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.