📊 Data Analytics Projects: Air Pollution & US Shooting Cases

🎯 Overview

Final project work for COMM-school Data Analytics training course, focusing on analyzing two significant public datasets:

1. Air Pollution in Seoul (2019)
2. Shooting Cases in the USA

📊 Project Highlights

• Comprehensive data analysis using PowerBI and MSSQL
• Trend identification and storytelling
• Visual representation of complex datasets
• Complete data analytics cycle implementation

🛠️ Tools Used

• Data Analysis: Microsoft PowerBI
• Database: Microsoft SQL Server
• Visualization: PowerBI Dashboard
• Data Cleaning: SQL Queries

📈 Datasets

1. Air Pollution in Seoul

• Source: Kaggle Dataset
• Time Period: 2019
• Key Metrics:
  • Pollution levels
  • Seasonal variations
  • Geographic distribution

2. US Shooting Cases

• Focus Areas:
  • Incident patterns
  • Geographic analysis
  • Temporal trends

📊 Visualization Techniques

• Time series analysis
• Geographic heat maps
• Trend comparisons
• Interactive dashboards

💡 Key Insights

1. Air Pollution Analysis:

   • Seasonal patterns
   • High-risk areas
   • Contributing factors

2. Shooting Cases:

   • Incident frequency
   • Location patterns
   • Temporal distribution