Lab 1: - MSBI Fundamentals, Data flow, Control Flow, ETL, Dataware house(60 minutes)

In lab 1 we have covered the below topics :-

Basic fundamental of what is BI.

Difference between data and information.

Importance of Dataware and Datamarts.

Understanding how SSIS , SSAS & SSRS fit in BI cycle.

Installation of MSBI ( SQL Server and SQL Server data tools)

Control flow vs Data flow.

Understanding concepts like connection manager and data viewers.

Figuring our errors and issues in SSIS.


Complete and Continue