A modern data warehouse project designed to transform raw ERP and CRM data into business-ready insights. This project demonstrates how structured data pipelines and modeling can support business reporting, KPI tracking, and decision-making.
This project focuses on building an end-to-end data warehouse using Medallion Architecture (Bronze, Silver, Gold) and leveraging it for business analytics.
The goal was to convert raw, unstructured data into a clean, structured, and analytics-ready format to enable insights into customer behavior, product performance, and sales trends.
- Consolidate data from multiple sources (ERP & CRM)
- Clean and transform raw data for analysis
- Build a structured data model for reporting
- Enable KPI tracking and business insights
- Support data-driven decision-making
This project follows Medallion Architecture:
- Stores raw data from ERP and CRM systems
- No transformation applied
- Data cleaning, standardization, and transformation
- Prepared for analysis
- Data modeled into fact and dimension tables
- Optimized for reporting and analytics
- Extracted data from CSV sources
- Transformed and cleaned datasets
- Loaded structured data into different layers
- Designed star schema
- Created:
- Customer Dimension
- Product Dimension
- Sales Fact Table
- Built summary tables for reporting
- Performed SQL-based analysis to extract insights
- Generated datasets for KPI tracking and dashboards
- Supported business use cases like:
- Customer segmentation
- Product performance
- Sales trend analysis
- SQL Server
- SQL (Joins, CTEs, Window Functions)
- Data Modeling (Star Schema)
- ETL Concepts
- Identification of high-value customers and segments
- Analysis of product performance across categories
- Tracking of sales trends over time
- Creation of summary tables for reporting and dashboards
data-warehouse-project/ │ ├── data/ # Raw and processed datasets ├── docs/ # Architecture, data models, documentation ├── scripts/ # SQL scripts (Bronze, Silver, Gold layers) ├── README.md
- Enables structured reporting and KPI tracking
- Supports data-driven business and product decisions
- Provides a scalable foundation for BI dashboards
- Bridges raw data and business insights
This project demonstrates the ability to design data pipelines, structure data for analytics, and support business decision-making — making it relevant for Business Analyst, Product Analyst, and BI Analyst roles.
Hi, I’m Mehak Mehta — a Business & Product Analyst with hands-on experience in SQL, Power BI, Excel, and Data Modeling.
I enjoy transforming raw data into meaningful insights that drive business decisions.
📬 Let’s connect:
https://www.linkedin.com/in/mehak-mehta-621714260/