Skip to content

sjdatascientist/india-air-quality

Repository files navigation

Project Link Below:

https://public.tableau.com/app/profile/shubham.jangra/viz/india-air-quality-data/MainDashboard

Or you download the .twbx file from repository

NOTE: Convert xlsx file to csv with same name then workbook will work perfectly

About the Project

Air Quality Data (Tableau)

Context:
Since industrialization, there has been an increasing concern about environmental pollution. As mentioned in the WHO report 7 million premature deaths annually are linked to air pollution, air pollution is the world's largest single environmental risk. Moreover as reported in the NY Times article, India’s Air Pollution Rivals China’s as World’s Deadliest it has been found that India's air pollution is deadlier than China's.
You can explore India’s air pollution levels more granularly using this dataset.

Content:
This data is combined(across the years and states) and is largely a clean version of the Historical Daily Ambient Air Quality Data released by the Ministry of Environment and Forests and Central Pollution Control Board of India under the National Data Sharing and Accessibility Policy (NDSAP).
Building a Tableau Dashboard for the India Air Pollution dataset involves several steps. Below are the key components and steps that you can follow: Can we relate the air quality changes to changes in Environmental policy in India?

Brief About Dataset:
This data is combined (across the years and states) and is largely a clean version of the Historical Daily Ambient Air Quality Data released by the Ministry of Environment and Forests and Central Pollution Control Board of India under the National Data Sharing and Accessibility Policy (NDSAP).

  1. Stn_code (Dimension): Stores Particular Station Code for states or cities.
  2. Sampling_Date (Dimension): Stores particular month and air quality report code.
  3. State (Dimension): Stores Name of States.
  4. Location (Dimension): Stores Name of Cities.
  5. Agency (Dimension): Local Authority name which collected report.
  6. So2 (Measure): Level of Sulphur dioxide.
  7. No2 (Measure): Level of Nitrogen dioxide.
  8. Rspm (Measure): Level of Respirable Suspended Particulate Matter.
  9. Spm (Measure): Level of Suspended Particulate Matter.
  10. location_monitoring_station (Dimension): Place from Air quality measured.
  11. pm2_5 (Dimension): Level between 2 and 5.
  12. Date (Dimension): Stores date monthly from 1987 to 2000.
  13. Type (Dimension): Stores zone in which air quality measures like industrial, residential.

For more info read 'Air Quality Data.docx'!