Data Warehouse project

? From Raw Data to Business Insights — My Data Warehouse Journey

Transform raw, scattered data into meaningful insights that support real business decisions.

?️ What I built:

? Designed a full Medallion Architecture (Bronze, Silver, Gold)

? Integrated data from multiple sources (CRM & ERP systems)

? Cleaned, standardized, and transformed raw data into analytics-ready datasets

? Created business-driven SQL reports for customers and products

? Built an interactive dashboard to visualize performance and trends

? Key Insights:

? Generated $29.4M in revenue with strong growth trends

? Customers aged 45–59 contributed the highest revenue

? VIP & New customers drive the majority of sales

?‍♂️ Bikes category dominates with 98% of total revenue

? Top products (Mountain-200 series) are the main revenue drivers

?️ Strategic Impact:

▫️ Focus on VIP retention through loyalty programs

▫️ Expand in high-potential markets (UK & Germany)

▫️ Leverage top-performing categories to boost cross-selling

?️ Tools & Technologies:

-Microsoft SQL Server

-Power BI

-Data Warehouse Modeling(draw.io)

-GitHub

-Notion

✨ This project helped me bridge the gap between data engineering and business analytics, and strengthened my ability to turn data into actionable insights.

? Check out the full project:

? GitHub: [https://lnkd.in/e-cPSqUG]

? Notion : [https://lnkd.in/egvJXZSJ]