This repository contains SQL scripts for analyzing business data from the Gold Layer of my AdventureWorks Data Warehouse. It focuses on answering real-world business questions and demonstrating analytical SQL skills.
This project is inspired by DataWithBaraa's SQL Data Analytics Project and uses the Gold Layer from my own AdventureWorks Data Warehouse project.
The project performs business analysis using dimensional and fact tables in the Gold Layer, including customer, product, date, and sales data. It showcases common analytical techniques such as:
- Sales Analysis
- Customer Analysis
- Product Performance
- Time-Based Trends
- KPI Reporting
This project uses the Gold Layer from my SQL Data Warehouse project, which follows a Star Schema with Fact and Dimension tables optimized for analytics.
Related Project: 🔗 sql-data-warehouse-adventureworks
- SQL Server
- T-SQL
- AdventureWorks
- Git & GitHub
sql-data-analytics-adventureworks/
│
├── dataset/
├── scripts/
│ ├── advanced-analytics/
│ ├── exploratory-data-analysis/
│ └── init_database.sql
│
├── LICENCSE
└── README.md
This project is based on the excellent SQL Data Analytics Project by DataWithBaraa. I adapted the concepts using the Gold Layer from my own AdventureWorks Data Warehouse to practice SQL analytics and build my portfolio.
Original Project: 🔗 https://github.com/DataWithBaraa/sql-data-analytics-project
This project is licensed under the MIT License.