Learn MSBI ( Microsoft Business Intelligence ) in 4 days ( SSIS , SSAS and SSRS)
Visit http://www.questpond.com for more such videos.
Want to know about Why MSBI
Career is good see this https://www.youtube.com/watch?v=8R9U334FiEY
Below is the full syllabus of
Lear MSBI in 4 days videos
Lab 1 :- BI
Life cycle ,
Data flow , control flow ,
error viewing and
ETL Demo
Lab 2 :-
Error handling , Conditional and data conversion.
Trailer https://www.facebook.com/Questpond/videos/vb.306222029419325/947145631993625/
Lab 3 :- For loop,Debugging , variables and parameters. Trailer
https://www.facebook.com/video
.php?v=950266935014828
Lab 4:-
Packaging and Deployment,
File component and running
SSIS package as a task. Trailer
https://www.facebook.com/Questpond/videos/vb.306222029419325/950685158306339
Lab 5: - For dimension, measures, star schema, snow flake, shared connection managers & packages tasks. Here is the trailer for the video
https://www.facebook.com/video.php?v=952786511429537
Lab 6:- For
Slowly Changing dimensions
Type 1 and Type 2 With and
Without Historical data
OLEDB Command Param and
Sequence in OLEDB command
Unicode and non-unicode characters. Trailer
https://www.facebook.com/Questpond/videos/vb.306222029419325/957498840958304
Lab 7 for Lookups ,
Optimizing datatype conversion and how to update changes in MSBI.Here is the trailer for the video
https://www.facebook.com/Questpond/videos/vb.306222029419325/963061903735331/?type=2&theater;
Lab 8:- Sort, Merge and Merge joins to combine data from different data sources and create a
Merged data.
Lab 9 :- Creating
SSAS Cube (
30 minutes) Trailer
https://www.facebook.com/Questpond/videos/972481196126735/
Lab 10 :- SSAS
Time series and
Excel display of SSAS Cube. https://www.facebook.com/Questpond/videos/vb.306222029419325/973519242689597
Lab 11 :-
Transaction and Checkpoints in MSBI. For trailer
https://www.facebook.com/Questpond/videos/978125298895658/
Lab 12 :- Creating a simple
SSRS report and implementing
Matrix,Tabular,Parameters,Sorting,
Expressions in SSRS https://www.facebook.com/Questpond/videos/vb.306222029419325/979132148794973/
Lab 13:- Using Data Profiling task to check data quality (
20 Minutes) Trailer
https://www.facebook.com/Questpond/videos/vb.306222029419325/981338688574319/
Lab 14:-
Dimension Hierarchies (SSAS) (
30 Minutes) Trailer
https://www.facebook.com/Questpond/videos/983083065066548/
Lab 15 :-
Webservice and XMLTask component. (
15 Minutes)
In this video we have explained how to consume a webservice task and read the
XML output using XML task
SSIS control flow task.
Lab 16:- DrillDown and Subreports (20 Minutes) Trailer
https://www.facebook.com/Questpond/videos/983982558309932/
Lab 17:- SSAS
KPI (
Key Performance indicators)(15 Minutes) Trailer
https://www.facebook.com/Questpond/videos/985505028157685/
Lab 18:-
Pivot, UnPivot and Aggregation (20 Minutes) Trailer
https://www.facebook.com/Questpond/videos/987271391314382/
Lab 19 :- SSAS Calculation
. (30 Minutes)
In this video we have discussed calculations, parent
function, measure group, display folder, calculation formating and visible property.
Lab 20:-
SQL Execute Task (30 Minutes) Trailer
https://www.facebook.com/Questpond/videos/992263770815144/
Lab 21:-
Reference and Many-to-Many Relationship(30 Minutes) Trailer
https://www.facebook.com/Questpond/videos/992266710814850/
Lab 22 :-
Script Task and
Send Mail Task(15 Minutes)
In this video we will talk about one of the important and useful task in SSIS called Script Task.
Lab 23:- Script component (SSIS)(45 Minutes)
In this video we will talk about Script component in Data
Flow Tab.
Lab 24 :- Bar charts , Pie charts and
Gauge report(20 Minutes) Trailer
https://www.facebook.com/Questpond/videos/996771643697690/
Lab 25 :- SSAS Partitions (30 Minutes) Trailer
https://www.facebook.com/Questpond/videos/996872973687557/
Lab 26:-
CDC (
Changed Data Capture) in SSIS. (35 Minutes)Trailer
https://www.facebook.com/Questpond/videos/1000249683349886/
Lab 27:- Additive, Semiadditive and non-additive measures in SSAS.(15 Minutes)
In this video we will discuss about different kinds of measures in SSAS.
Lab 28:-
Buffer Size
Tuning (SSIS).Trailer
https://www.facebook.com/Questpond/videos/1008487992526055/
Lab 29:-How to impliment Multithreading in SSIS? Trailer
https://www.facebook.com/Questpond/videos/1016986665009521/
Lab 30 :- SSAS Cube background Processing. (Trailer)
https://www.facebook.com/Questpond/videos/1019444438097077/
Lab 31 :- Asynch and Blocking SSIS components. (Trailer)
https://www.facebook.com/Questpond/videos/1019452338096287/
Lab 32 :- SSRS Architecture and Deployment
In this video we will be going in depth into SSRS and understand the Architecture and tools of SSRS.
Lab 33 :-
DQS(
Data Quality Services ) Trailer
https://www.facebook.com/Questpond/videos/1033799093328278/
Lab 34 :- Tabular
Model and
Power Pivot (SSAS) Trailer
https://www.facebook.com/Questpond/videos/1036604916381029/