Restaurant Database Design and Data Warehouse Development

Designed and implemented a data warehouse for a restaurant management system using Microsoft SQL Server and T-SQL. The project involved designing a Star Schema with fact and dimension tables, implementing ETL processes to extract, transform, and load data from the source database, and creating a date dimension for time-based analysis. It also included data integration, handling missing values, defining table relationships, and calculating sales metrics to support reporting and business analysis.