Data Warehouse and Business Intelligence Labs
IDEs: Azure Studio, MS SQL Server Management Studio (SSMS), PowerBI, DAX Studio, Visual Studio (for SSIS)
- Lab1: SQL Queries and Data Modelling
- Lab2: SQL Pivot Tables
- Lab3: PIVOT, CASE, GROUP, VIEW in SQL
- Lab4: SQL, PowerBI data modelling and visualization
- Lab5: ETL Process using Import/Export Wizard and SELECT INTO
- Lab6: ETL Process using SSIS
- Lab7: Data Flow using SSIS
- Lab8: SSAS