This repository is dedicated to practicing and learning advanced data analysis using SQL. The project is based on the comprehensive YouTube tutorial by Data With Baraa, which walks through an end-to-end analysis pipeline.
🎥 Tutorial Reference:
🔗 Advanced SQL Data Analysis Project | Data With Baraa
- Install SQL Server or any compatible SQL RDBMS.
- Clone this repository:
git clone https://github.com/Steffin12-git/EDA-SQL_Data_analysis.git
- Import the dataset(s) provided in the
datasets/
folder. - Run the SQL scripts in
queries.sql
to explore and transform the data. - Use the final views to plug into a BI tool of your choice for building dashboards.
The main goal of this project is to:
- Perform deep exploration across all tables
- Derive meaningful metrics and KPIs
- Classify and segment customers and products
- Create views for smooth integration with BI tools
- Data With Baraa for the original tutorial and dataset walkthrough
📺 Watch the full video