Data Warehouse SQL and Analytics Project

Welcome to the Data Warehouse and Analytics Project repository🚀!! This project demonstrates a compressive data warehousing and analystics solution , from building a data warehouse to generate a actionable insights . Designed it as a potfolio project that highlights industry best pratices in data engineering and analytics.

📺Project Overview

This project Involves:

1. Data Architecture:- Designing a Modern Data Warehouse Using the Medallion Architecture Bronze , Silver and Gold layers.
2. ETL Pipelines:- Extracting, transforming and loading data from the source systems into the warrehouse.
3. Data Modeling:- Developing the fact and dimensions tables optimized for the analytics quereies.
4. Analytics & Reporting:- Creating A SQL-based reports and dashboards for the actionable insights.

🎯This repositiory is an excellent resource for professional and sudents looking to showcase your experties into the various fields as:

 - SQL Development
 - Data Architect
 - Data Engineering
 - ETL Pipeline Developer
 - Data Modelling
 - Data Anlytics

📺 YouTube Video

[SQL Data Warehouse Portfolio Project](https://www.youtube.com/watch?v=9GVqKuTVANE&list=PLNcg_FV9n7qaUWeyUkPfivtMbKlrff

🛠️ Tools & Resources

• SQL Server Express - Lightweight server for hosting your SQL database
• SQL Server Management Studio (SSMS) - GUI for managing ,version and collabrate your code.
• Git Repository - Setup a github account and repository to manage, version and collabrate on your codes.
• Draw.io - Design data architecture , models , flows and diagrams.
• Notion - All-in-one tool for project management and oragnising all the tasks.

🚀 Project Requirements

Building the Data Warehouse(Data Engineering)

Main Objective

Develop a modern data warehouse using a SQL Server to consolidate a sales data , by enabling the analytics reporting and informed decision making.

Specifications

• Data Sources : Import the data from the source systems through CRM and ERP provided as CSV Files.

• Data Quality : Cleanse and resolve the data quality issue prior to the analysis.

• Integration : Combine both the sources into the single, user friendly data models designed for the analytics queries.

• Scope : Focus on the latest datasets onl; Historization of the data is not really required

• Documentation: Provide a clean documents where all the data models details is to be provided to business stakeholder and analytics teams

  📊BI: Analytics & Reporting (Data Analytics)

  Objective

  Develop a SQL-based analytics to deliver a detailed insights into the:

  • Customer Behavior
  • Product Performance
  • Sales Trends
  • Meaningfull Insights

These insights empowers stakeholders with the key business matrics, enabling the startergic decision-making.

🏛️ Data Architecture

The Data Architecture for this project follows the Medallion Architecture Bronze, Silver and Gold layer

1. Bronze Layer:- It stores the raw data as-is from the system. Data is ingested from the CSV files ito the SQL Server Database.
2. Silver Layer:- This Layer inclued the data cleasing, standardization, and normalization processes to prepare data for analysis.
3. Gold Layer:- House business-ready data modelled into a star schema required for reporting and analysis.

🔶 Liscence

This project is liscenced under the MIT Liscence. You all are free to use , modify it and share this project with your proper contributions in it.

👩 About Me

Hi there! I’m Vanshika, a third-year B.Sc. (Hons.) Statistics student at Ramjas College, University of Delhi. I’m a passionate data enthusiast with a deep interest in data analysis, visualization, and storytelling through numbers. I love uncovering insights from raw data using tools like SQL, Excel, and Power BI, and transforming them into meaningful business solutions. I’m constantly exploring real-world projects to strengthen my analytical thinking and problem-solving skills.

Let's stay in touch 👇