Data Warehouse Design and Analysis: Applied Project 2 Solution

This document presents a comprehensive solution to a data warehouse design and analysis assignment. The assignment focuses on the Global Trading Company, which utilizes a data warehouse to store sales, customer, and product information across its Australian locations. The solution begins with an analysis and description of the dimension tables, including CompanyDim, CustomerDim, DateDim, ProductDim, and WarehouseDim, detailing their purpose within the star schema. It then outlines the primary and foreign keys used to establish relationships between tables. A database diagram visually represents the schema. The core of the solution includes several SQL queries designed to extract and manipulate data from the warehouse. These queries demonstrate the retrieval of customer information, data insertion, and aggregation of sales data by year and product, showcasing the practical application of SQL in a data warehousing context. The assignment concludes with a bibliography.