Welcome to my SQL Server Data Warehouse & Analytics Portfolio Project!
This end-to-end solution showcases how to build a modern data warehouse using SQL Server, implement ETL workflows, design analytical data models, and extract business insights through SQL-based reporting.
This project follows the Medallion Architecture pattern, organizing data into three structured layers:
- Bronze Layer: Raw data ingestion from ERP and CRM systems via CSV files into SQL Server.
- Silver Layer: Data cleansing, transformation, and normalization to ensure consistency and usability.
- Gold Layer: Business-ready data modeled into a star schema for efficient reporting and analytics.
Goal: Build a scalable SQL Server-based data warehouse to consolidate sales data and support business intelligence.
Key Tasks:
- Import and integrate data from ERP and CRM sources.
- Address data quality issues through cleansing and validation.
- Merge datasets into a unified analytical model.
- Focus on current data snapshots (no historization).
- Document the data model for both technical and business users.
Goal: Deliver actionable insights using SQL queries and dashboards.
Focus Areas:
- Customer segmentation and behavior analysis.
- Product performance metrics.
- Sales trend evaluation.
These insights empower stakeholders to make data-driven decisions with confidence.
This project highlights expertise in:
| Skill Area | Tools & Techniques Used |
|---|---|
| Data Engineering | SQL Server, ETL workflows, data cleansing |
| Data Modeling | Star schema, fact/dimension tables |
| Analytics & BI | SQL queries, KPI reporting, trend analysis |
| Architecture Design | Medallion architecture (Bronze/Silver/Gold) |
This project is released under the MIT License. Feel free to use, adapt, and share it with proper credit.
Hi, I’m Janani Priya R P — a passionate Data Engineer with hands-on experience in building scalable data pipelines and analytical solutions. I love turning raw data into meaningful insights and continuously strive to improve my craft.