SQL Data Analytics Project

This project demonstrates how to leverage SQL for data-driven insights. It is structured into two phases that guide the analytics journey, from initial exploration to more advanced business-oriented analysis.

---

📌 Project Phases

1. Exploratory Analysis

In this phase, we focus on understanding the dataset:

• Examining the structure of the data.
• Performing basic descriptive statistics.
• Identifying trends, anomalies, and distributions.

The goal is to generate preliminary insights that inform further deep-dive analysis.

---

2. Advanced Analytics

Here, we move beyond exploration to extract business-ready insights:

• Applying complex SQL queries.
• Building aggregated views and performance metrics.
• Delivering actionable insights for decision-making.

---

📊 Reports

The project generates two main reports:

• product_report.sql → Analyzes product-level data, performance trends, and key KPIs.
• customer_report.sql → Provides insights into customer behavior, segmentation, and retention metrics.

These scripts can be executed directly in your SQL environment to produce analytical outputs.

---

🛠️ Project Roadmap

For a detailed overview of the project workflow and stages, please refer to the roadmap.md.

---

🚀 Getting Started

1. Clone the repository:

   git clone https://github.com/your-username/sql-data-analytics-project.git
   cd sql-data-analytics-project
   
   

---

License

This project is licensed under the [MIT License]. You are free to use, modify, and share this project with proper attribution.

---

sql_data_analytics_project/
|-- datasets/
|   |-- gold.dim_customers.csv
|   |-- gold.dim_products.csv
|   |-- gold.fact_sales.csv
|-- docs/
|   |-- data_analytics_project_roadmap.png
|   |-- roadmap.md
|-- scripts/
|   |-- advanced_analytics/
|   |   |-- change_over_time.sql
|   |   |-- cumulative_analysis.sql
|   |   |-- data_segmentation.sql
|   |   |-- part_to_whole_analysis.sql
|   |   |-- performance_analysis.sql
|   |-- exploratory_data_analysis/
|   |   |-- database_exploration.sql
|   |   |-- date_range_exploration.sql
|   |   |-- dimension_exploration.sql
|   |   |-- magnitude_analysis.sql
|   |   |-- measure_exploration.sql
|   |   |-- ranking_analysis.sql
|   |-- init_database.sql
|   |-- reports/
|   |   |-- customer_report.sql
|   |   |-- product_report.sql
|-- LICENSE
|-- README.md

---