Skip to content

README.md

Latest commit

 

History

History
116 lines (85 loc) · 3.38 KB

README.md

File metadata and controls

116 lines (85 loc) · 3.38 KB

📊 Data Analysis Practice Projects

Welcome to my Data Analysis Practice Repository!
This space is dedicated to learning and experimenting with real-world datasets using SQL, Power BI, and other data analysis tools.

Whether you're a beginner or looking to sharpen your analytics skills, this repository is designed to be educational and reusable—feel free to clone it, modify it, and use it as a guide for your own learning journey.

🧠 About This Repository

This repository contains practice projects focused on:

  • Strengthening SQL and Power BI skills
  • Solving analytical problems using real-world datasets
  • Developing data storytelling through visualizations
  • Practicing business intelligence techniques
  • Preparing for data analyst and BI developer roles

🔧 Tools & Technologies Used

  • SQL Server / T-SQL
  • Power BI
  • Kaggle Datasets
  • Git & GitHub

🧪 Projects Covered

✅ Titanic Survival Analysis (SQL + Power BI)

  • Dataset: Titanic Dataset on Kaggle
  • Tasks:
    • Survival rate analysis
    • Passenger demographics
    • Fare, family, embarkation insights
    • Socioeconomic status classification
    • SQL-based rule predictions
    • Power BI dashboard

✅ Netflix Shows Analysis (Power BI)

  • Dataset: Netflix Shows Dataset on Kaggle
  • Tasks:
    • Genre distribution
    • Country-wise content trends
    • Content rating patterns
    • Time-based release analysis
    • Power BI visuals and filtering

✅ Advanced Flight Delay Analysis (SQL + Power BI)

  • Dataset: Flight Delays Dataset on Kaggle
  • Tasks:
    • SQL-based data transformation
    • Null handling, column formatting
    • Exploratory Data Analysis (EDA)
    • Delay pattern analysis (departure, arrival)
    • Airport/airline performance
    • Answering: "Which airline should you fly on to avoid significant delays?"
    • Power BI view creation and insights

📂 Folder Structure

Practice-projects-data/
├── Dataset/ 
│   ├── netflix/
│   ├── titanic/
│   ├── US_flight_delays_and_cancelation/
├── flight-delays/ 
│   │   └── Flight delay EDA.sql
│   │   └── US flight delay SQL project Data Cleaning.sql
├── Netflix project/ 
│   │   └── 02_Netflix_Symbol/
│   │   └── Netflix power bi dashboard.pbix
├── Titanic Project/ 
│   │   └── power bi/
│   │   └── Sql Analysis.sql
└── README.md

🚀 Learning Goals

  • ✅ Learn to clean and format real-world data using SQL
  • ✅ Practice joining, filtering, grouping, and window functions
  • ✅ Apply EDA to extract trends and outliers
  • ✅ Create insightful Power BI dashboards
  • ✅ Translate analysis into business insights
  • ✅ Prepare for data analyst interview questions

🙌 Contribution & Learning

This repository is open for educational use. Feel free to fork it, study the queries and dashboards, and build your own portfolio.

If you're new to data analysis, you can use this as a template for your learning. If you're experienced, you can contribute or suggest improvements.

📬 Contact

If you found this useful or want to collaborate on data-related projects, feel free to connect!

Happy Learning & Exploring! 📚🚀