Data Management Project: Implementing a Waste Data Warehouse at LSBU

This data management project details the construction of a data warehouse using SQL Server Management System and SSIS. The project begins with schema design using Kimball's Dimensional Modeling technique on a Local Authority waste management dataset. The solution then demonstrates the ETL process using SSIS, involving the creation of a database, importing data from an Excel file, and applying transformations such as Union All and Conditional Split to handle null values. Furthermore, the project involves creating multiple data flow tasks to split columns into specific tables using Aggregate and Multicast functions, along with the creation of SQL scripts to generate tables and populate them with data. The final stage of the ETL process uses the lookup function to integrate various tables stored in the database. The document provides a detailed, step-by-step guide to the entire process, including figures and code snippets.