Welcome to my blog, where I present a comprehensive analysis of India's air quality. Using the dataset from Kaggle (kaggle.com/datasets/shrutibhargava94/india-..), I provide insights and visualizations that highlight the trends, patterns, and challenges related to air quality in India. Follow along for a data-driven exploration of this critical issue that affects the health and well-being of millions of people.
My Power BI report provides insights into India's air quality through three distinct sections:
Trend analysis of SO2 and NO2 levels
Comparison of average SPM, RSPM, and PM_25 levels across states
Location and Time wise analysis of SO2 and NO2 levels.
Discover the SO2 and NO2 levels trend in the Power BI report through the first tab. This section features two line charts that compare the levels of SO2 and NO2 before and after 2000, presenting a clear visual representation of the trends in air pollution.
The second tab of the Power BI report titled "Comparison of average SPM, RSPM, and PM_25 levels across states" showcases visually appealing treemaps that depict the average levels of SPM, RSPM and PM_25 pollutants across various states in India.
The third tab of the Power BI report showcases a comprehensive table featuring the top 20 cities with the highest RSPM levels along with their corresponding SO2 and NO2 levels. A map visualization also displays the average SO2 and NO2 levels across different cities. Users can easily filter the data by year and month using the slicers provided.
In conclusion, the Power BI report based on India's air quality data provides a comprehensive analysis of the air quality trends across different states and cities. The report clearly depicts the increase in pollutants like SO2, NO2, SPM, RSPM, and PM_25 levels over the years. It also highlights the cities with the highest RSPM levels and their corresponding SO2 and NO2 levels. By using this report, policymakers and stakeholders can make informed decisions and take necessary actions to address the issue of air pollution in India.
You can access the pbix file for this report on my GitHub page at this link: Air Quality Report