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.