₹258 billion spent annually on Asthma treatment in India — yet most Indians don’t even know what AQI means. Who said that? Me. Who am I? Okay, so to answer that… I became Peter Pandey, a Data Analyst (at least for a few days). And A live 5 page Dashboard with summary on 3 pages for stakeholders, made by analyzing almost 4 large datasets (one is 300K rows),and 4-5 additional datasets whose data is manually collected by me. A 30 min. video presentation is made to explain the Analysis, Findings and Live Working of Dashboard. “AirPure Innovations” is a startup born out of India’s air quality crisis, with 14 cities ranking among the world’s top 20 most polluted. Before investing in production and R&D, they needed answers — and that’s where the dashboard came in. Dashboard Highlights: HOME Page: A compulsory Intro. AQI: Air Quality trends across regions. POLLUSCOPE: Pollution and its impact on health. MARKET: An exterior View or Big Picture of actual Existing Market of Air Purfiers. Extras.. Summary insights for stakeholders on 3 pages. • Key Insights Discovered: 1. PM10 & PM2.5 are the prime villains — filtration must target these. 2. "Population" is not proportional to "Pollution" — cities like Bengaluru prove policy matters. 3. Delhi is not the one, Byrnihat, a small area on the Meghalaya-Assam Border is more in danger. While Bahadurgarh or Haryana also emerges out as danger in last 6 months of the timeline. 4. Northern India desperately wants our shield — Delhi, Noida, Gurugram, Patna are launch hotspots. 5. Kids & seniors face the worst health risks — asthma, COPD, Bronchitis, mortality. 6. EV adoption doesn’t guarantee clean air — mixed results across states. 7. AQI awareness exists, but understanding doesn’t — especially in Tier 2/3 cities. 8. Pollution = sales spikes — Diwali(aka November Month) shows real-time demand surges. Google Trends never lies. • Strategic Roadmap: → Focus on PM2.5 + VOC filtration → Launch in High AQI,High population hotspots → Use the Prioritzation Quadrant of our Dashboard to make quick decisions. → Educate non-metro users on AQI → Leverage clean-air policies for growth [Also Made a product requirment document and A video presentation]

Skills & Tools Used:

Share this Project: