Sales Data Warehouse Development

This project involved designing and developing both a transactional SQL database and a data warehouse to manage and analyze sales data. The main objective was to facilitate efficient querying and enable insightful analysis of sales trends to support strategic decision-making.

Technical Overview:

Transactional Database: A SQL database was created to manage daily sales transactions, including product, customer, and sales details. This database was optimized for high-speed, daily operations.

Data Warehouse: A separate data warehouse was developed to organize and store historical sales data for long-term analysis. It includes various dimensional tables (e.g., DimCustomer, DimProduct, DimLocation) and a fact table (FactSales) to enable multi-dimensional analysis of sales data.

Features:

Sales Analysis: The data warehouse enables in-depth analysis of sales trends, such as identifying top-selling products and peak sales periods.

Query Speed Optimization: The data warehouse allows complex historical data queries to be executed without impacting the performance of the transactional database.

Decision Support: Provides precise analytical insights to assist management in making informed sales and marketing strategy decisions.

Integration Flexibility: The warehouse design supports integration with Business Intelligence (BI) tools for data visualization and reporting.

Tools Used: SQL Server, SSIS for ETL processes, Power BI for data visualization and analysis.