Skip to content

Latest commit

 

History

History
71 lines (48 loc) · 2.36 KB

README.md

File metadata and controls

71 lines (48 loc) · 2.36 KB

🌍 Air Quality Analysis Dashboard

📖 Introduction

This repository hosts my Air Quality Analysis Dashboard, created using Power BI. It provides a comprehensive analysis of air quality metrics across different geographic locations using data sourced from data.gov.

📝 Background

The primary goal of this project is to assess air quality trends over time and across regions. It helps identify pollution hotspots and areas with cleaner air, supporting environmental initiatives and raising awareness. 🌱

🛠️ Tools I Used

  • 📂 Data Source: CSV files from data.gov
  • 📊 Visualization: Power BI

📈 Key Metrics and DAX Queries

  • 📌 Metrics:

    • 🌡️ Average Air Quality Index (AQI)
    • 🌆 Highest and lowest pollutant levels by location
    • 📅 Annual trends in air quality data

  • 💻 DAX Queries:
    Specific DAX formulas used for calculations, such as:

    • CALCULATE(SUM([DataValue]), YEAR([Date])=2024)

📊 Air Quality Dashboard Insights

  • Visual Representations:
    • 🗺️ Geographic heatmaps showcasing pollution levels.
    • 📈 Trend lines for air quality over years.
    • 📊 Bar charts comparing key metrics.

🔍 Key Insights

  1. 🌟 Regions with the best and worst air quality levels.
  2. 📉 Year-over-year improvement or decline in air quality.
  3. 🍂 Seasonal patterns influencing pollution metrics.

🎓 What I Learned

  • Gained expertise in integrating CSV data into Power BI. 💡
  • Improved proficiency in DAX for dynamic data analysis. 🧠
  • Enhanced understanding of air quality metrics and their societal implications. 🌍

✅ Conclusions

The analysis reveals critical trends and disparities in air quality. These insights can inform environmental policy-making and public health strategies. 🌿

💡 Additional Insights

  • 🌆 The impact of industrial zones on local air quality.
  • 🏞️ Comparison of urban and rural air quality metrics.

✨ Closing Thoughts

This project marks a significant milestone in my data analytics journey. I look forward to receiving feedback and contributing to similar impactful projects. 🚀

📂 Attached: Explore the insights further by checking out the PDF file in this repository.