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://goo.gl/OVYcsM
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://goo.gl/T3oM6Y
Lab 3 :- For loop,Debugging , variables and parameters. Trailer
https://goo.gl/IBQRvo
Lab 4:-
Packaging and Deployment,
File component and running
SSIS package as a task. Trailer
https://goo.gl/pvgOlA
Lab 5: - For dimension, measures, star schema, snow flake, shared connection managers & packages tasks. Here is the trailer for the video
https://goo.gl/Ry08Or
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://goo.gl/6hxNpU
Lab 7 for Lookups ,
Optimizing datatype conversion and how to update changes in MSBI.Here is the trailer for the video
https://goo.gl/5nAqyW
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://goo.gl/LAkgqP
Lab 10 :- SSAS
Time series and
Excel display of SSAS Cube.
https://goo.gl/GORhiw
Lab 11 :-
Transaction and Checkpoints in MSBI. For trailer
https://goo.gl/14NT3m
Lab 12 :- Creating a simple
SSRS report and implementing
Matrix,Tabular,Parameters,Sorting,
Expressions in SSRS
https://goo.gl/79a3K9
Lab 13:- Using Data Profiling task to check data quality (
20 Minutes) Trailer
https://goo.gl/EzT3IM
Lab 14:-
Dimension Hierarchies (SSAS) (
30 Minutes) Trailer
https://goo.gl/RI4iU9
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://goo.gl/WKJHvR
Lab 17:- SSAS
KPI (
Key Performance indicators)(15 Minutes) Trailer
https://goo.gl/Wlkb1H
Lab 18:-
Pivot, UnPivot and Aggregation (20 Minutes) Trailer
https://goo.gl/gZzJkC
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://goo.gl/XNMuFJ
Lab 21:-
Reference and Many-to-Many Relationship(30 Minutes) Trailer
https://goo.gl/jYbGfd
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://goo.gl/SUrjxO
Lab 25 :- SSAS Partitions (30 Minutes) Trailer
https://goo.gl/aZ13Kh
Lab 26:-
CDC (
Changed Data Capture) in SSIS. (35 Minutes)Trailer
https://goo.gl/rkcvsU
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://goo.gl/oTSxdK
Lab 29:-How to impliment Multithreading in SSIS? Trailer
https://goo.gl/7IHZTP
Lab 30 :- SSAS Cube background Processing. (Trailer)
https://goo.gl/X1pN3z
Lab 31 :- Asynch and Blocking SSIS components. (Trailer)
https://goo.gl/HifAEP
Lab 32 :- SSRS Architecture and Deployment
Lab 33 :-
DQS(
Data Quality Services ) Trailer
https://goo.gl/s60hSO
Lab 34 :- Tabular
Model and
Power Pivot (SSAS) Trailer
https://goo.gl/BRik9A
Lab 35 :-
MDX (
Multidimensional Expressions) Queries. Trailer
https://goo.gl/vmnzjM
Lab 36 :-
Data Mining (Fundamentals and
Time Series Algorithm).Trailer
https://goo.gl/ylNccY
Lab 37 :-
Page Split and Performance issues with (SSIS). Trailer
https://goo.gl/eKPkO1
Lab 38 :- Aggregations in SSAS.(Trailer)
https://goo.gl/OsxiDE
Lab 39 :-
ROLAP .
MOLAP and
HOLAP. (Trailer)
https://goo.gl/PcItbL
Lab 40 :- Instrumentation using Data
Taps (SSIS).
In this video we will talk about Data Taps.
MSBI doubt session 1 :- SSAS Multi dimensional cube deployed on Tabular issue.
https://goo.gl/5dRp4T
Learn MSBI
Step by Step.
http://goo.gl/L3BGlL
We are also distributing a
200 page Ebook "Learn MSBI (SSIS, SSRS, SSAS)
Step by step". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on questpond@questpond.com with the shared link and we will email you the
PDF.