Environmental Data Analyst

📊 𝗬𝗮𝗺𝘂𝗻𝗮 𝗪𝗮𝘁𝗲𝗿 𝗤𝘂𝗮𝗹𝗶𝘁𝘆 𝗠𝗼𝗻𝗶𝘁𝗼𝗿 (𝟮𝟬𝟭𝟯 - 𝟮𝟬𝟮𝟰)
Can data tell the story of a river’s survival?

📉As an aspiring Environmental Data Analyst/MIS Reporting, I recently completed an end-to-end analysis of 11 years (2013-2024) of CPCB water quality data for the Yamuna River using Power BI to diagnose the systemic pollution trends gripping the Yamuna River basin.
The visual insights reveal exactly where and why the river basin transforms into an "ecological dead zone" as it encounters urban corridors.
🔍 𝗧𝗵𝗲 𝗖𝗿𝗶𝘁𝗶𝗰𝗮𝗹 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 (𝗪𝗵𝗮𝘁 𝘁𝗵𝗲 𝗗𝗮𝘁𝗮 𝗧𝗲𝗹𝗹𝘀 𝗨𝘀):
🛑 𝗧𝗵𝗲 𝟭𝟬𝘅 𝗕𝗿𝗲𝗮𝗰𝗵: The river's average Biochemical Oxygen Demand 𝗕𝗢𝗗 stands at an alarming 𝟮𝟵.𝟭𝟭 𝗺𝗴/𝗹 nearly 𝟭𝟬𝘅 times higher than the CPCB's maximum safe bathing standard of 𝟯.𝟬𝟬 𝗺𝗴/𝗹.

🦠 𝗦𝗲𝘃𝗲𝗿𝗲 𝗦𝗲𝘄𝗮𝗴𝗲 𝗟𝗼𝗮𝗱: Total Coliform counts sit at 𝟭.𝟰𝟬 𝗕𝗶𝗹𝗹𝗶𝗼𝗻 and Faecal Coliform reaches 𝟮.𝟴𝟰 𝗧𝗿𝗶𝗹𝗹𝗶𝗼𝗻. This staggering microbial load is clear diagnostic proof of massive, untreated domestic sewage ingress.

📉 𝗧𝗵𝗲 𝗢𝘅𝘆𝗴𝗲𝗻 𝗗𝗲𝗽𝗹𝗲𝘁𝗶𝗼𝗻 𝗖𝘆𝗰𝗹𝗲: By modelling an inverse scatter plot (𝗕𝗢𝗗 vs 𝗗𝗢), the data captures the exact point where organic waste spikes (𝟰𝟬-𝟱𝟬 mg/l) and forces Dissolved Oxygen (𝗗𝗢) down to near 0 mg/l at the Nizamuddin and Okhla Barrages. 𝘈𝘲𝘶𝘢𝘵𝘪𝘤 𝘭𝘪𝘧𝘦 𝘤𝘢𝘯𝘯𝘰𝘵 𝘴𝘶𝘳𝘷𝘪𝘷𝘦 𝘩𝘦𝘳𝘦.

🧼 𝗧𝗵𝗲 𝗖𝗵𝗲𝗺𝗶𝗰𝗮𝗹 𝗙𝗼𝗼𝘁𝗽𝗿𝗶𝗻𝘁: It isn't just sewage. High concentrations of Surfactants (𝟲.𝟬𝟬 mg/l) and Phosphates (𝟭𝟵.𝟭𝟬 mg/l) in specific sectors provide concrete evidence of commercial detergents and household greywater bypassing municipal treatment entirely.

🚀 𝗗𝗮𝘁𝗮-𝗗𝗿𝗶𝘃𝗲𝗻 𝗦𝗼𝗹𝘂𝘁𝗶𝗼𝗻𝘀:
The data shows that a generalized approach across the entire basin is inefficient. To maximize ecological return on investment, remediation policies and Sewage Treatment Plant (STP) resources must immediately prioritize the 4 absolute drainage bottlenecks:
📍 Ghazipur Drain (Agra Canal)
📍 Shahdara Drain
📍 Najafgarh Drain Confluence
📍 Okhla Barrage Zone

💼 I am actively seeking opportunities to bring these data storytelling and environmental analysis skills to a forward-thinking team. Let's connect if you are hiring for roles in Environmental Reporting, Data Analytics, or Sustainability!

- Github Link [https://lnkd.in/gBThSPkz]

✨ Check out the high-definition analytical infographic layout attached below, designed to integrate seamlessly into my interactive reporting dashboards! #EnvironmentalDataAnalyst #PowerBI #DataStorytelling #WaterQuality #YamunaRiver #GreenTech #SustainabilityData #HiringAlert #DataAnalytics #DelhiDevelopmentAuthorit #GreenIndia #CPCB #WaterQualityAnalysis #EnvironmentalMISReporting