Skip to content

Advanced SQL data analysis project focused on exploring datasets, deriving KPIs, segmenting customers and products, and creating reusable views for integration with BI tools like Power BI to enable effective dashboarding and data-driven insights.

License

Notifications You must be signed in to change notification settings

Steffin12-git/EDA-SQL_Data_analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Advanced Data Analysis Project

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


🛠️ Getting Started

  1. Install SQL Server or any compatible SQL RDBMS.
  2. Clone this repository:
    git clone https://github.com/Steffin12-git/EDA-SQL_Data_analysis.git
  3. Import the dataset(s) provided in the datasets/ folder.
  4. Run the SQL scripts in queries.sql to explore and transform the data.
  5. Use the final views to plug into a BI tool of your choice for building dashboards.

📊 Objective

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

🙌 Credits

About

Advanced SQL data analysis project focused on exploring datasets, deriving KPIs, segmenting customers and products, and creating reusable views for integration with BI tools like Power BI to enable effective dashboarding and data-driven insights.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages