This project delves into the creation of a data warehouse/data mart using dimensional modeling techniques. It begins by establishing the rationale for subject area selection, identifying key stakeholders, and defining the vision, goals, and requirements of the data warehouse. The project then focuses on developing and presenting a suitable schema, with detailed explanations for the design choices made. Implementation involves using Microsoft SQL Server to create tables and perform the Extract, Transform, and Load (ETL) process, utilizing tools like SSIS or writing SQL statements. The project also covers the concepts of dimensional modeling, star schema, and the differences between ETL and ELT processes. The solution explains the advantages and disadvantages of the star schema and provides examples of queries. Furthermore, it explores the use of SSIS and ELT for data integration, highlighting the benefits of each approach, particularly in the context of big data scenarios.
![[object Object]](/_next/static/media/star-bottom.7253800d.svg)
