This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis
This project demonstrates a comprehensive data analytics solution, from understanding a data warehouse to generating actionable insights from it. it highlights industry best practices in data analytics.
The data architecture for this project follows Medallion Architecture Bronze, Silver, and Gold layers
- Bronze Layer: Stores raw data as-is from the source systems. Data is ingested from CSV Files into SQL Server Database.
- Silver Layer: This layer includes data cleansing, standardization, and normalization processes to prepare data for analysis.
- Gold Layer: Houses business-ready data modeled into a star schema required for reporting and analytics.
This project involves:
- Data Architecture: Understanding a designed Modern Data Warehouse Using Medallion Architecture Bronze, Silver, and Gold layers.
- ETL Pipelines: Understanding how Extracting, transforming, and loading of data from source systems into the warehouse has happened.
- Data Modeling: Understanding fact, dimension tables and the relations between them to proceed for analytical queries.
- Analytics & Reporting: Creating SQL-based reports and dashboards for actionable insights.
- Datasets: Access to the project dataset (csv files).
- MY SQL Workbench : GUI for managing and interacting with databases.
Develop SQL-based analytics to deliver detailed insights into:
- Customer Behavior
- Product Performance
- Sales Trends
These insights empower stakeholders with key business metrics, enabling strategic decision-making.
I am an aspiring Data Analyst looking for a career transition, with a background as an Engineer in Project Sales. Passionate about transforming raw data into meaningful insights, I aim to leverage analytical skills to drive data-driven decision-making.
Connect with me on LinkedIn or explore more projects on GitHub.
If you like this project or have suggestions, feel free to connect with me or leave feedback!