I will create custom dashboards and report
Excel and BI Specialist
About this Gig
Project Completed:Comprehensive Air Quality Analysis: Environmental, Health & EV Impact Study
Over the past few days, I worked on an end-to-end data analytics project focused on Air Quality, Public Health, and EV Adoption trends across India.
This project helped me go beyond just building dashboards I focused on real insights and decision-making.
What I analyzed:
Most & least polluted areas (AQI trends)
Pollutant composition across regions
Weekday vs Weekend AQI patterns in metro cities
Seasonal AQI trends + Bengaluru case study
Impact of air quality on disease occurrence
EV adoption vs AQI comparison
Key Insights:
Certain regions consistently show high AQI, indicating structural pollution issues
Minimal variation between weekday and weekend AQI in metro cities
Strong seasonal impact AQI peaks during specific months
Higher AQI regions show increased disease cases
EV adoption alone does not guarantee better air quality other factors like industrial activity and population density play a major role
Tools Used:
Power BI | DAX | Data Modeling | Data Cleaning
This project improved my understanding of:
Data storytelling
Building dynamic dashboards
Converting raw data into meaningful insi

