Water Quality Analysis Project
Analysis of water quality metrics across 3,276 water bodies to assess drinking water safety and health implications.
Project Overview
Created an analytical dashboard to evaluate water potability based on 9 critical parameters including pH, hardness, solids, chloramines, sulfate, conductivity, organic carbon, trihalomethanes, and turbidity.
Development Process
- Analyzed dataset containing 3,276 water samples with 10 key parameters
- Created stacked bar charts to visualize parameter distributions
- Developed comparative analysis between safe and unsafe water samples
- Implemented parameter-specific threshold visualizations
Data Analysis
pH Analysis
Evaluation of acid-base balance (WHO standard: 6.5-8.5)
Hardness Assessment
Calcium and magnesium salt concentration analysis
Total Dissolved Solids
Mineral content analysis (ideal: <500 mg/L, max: 1000 mg/L)
Chemical Parameters
Chloramines (<4 mg/L), Sulfates (3-30 mg/L), Trihalomethanes (<80 ppm)
Physical Properties
Conductivity (<400 μS/cm), Turbidity (<5 NTU)
Organic Content
Total Organic Carbon analysis (<2 mg/L treated, <4 mg/L source)
Tableau Dashboard
Technologies Used
SQLPythonTableauData AnalysisData Visualization