johnkul/TdhKe-helpdesksDashboard

Streamlit-based helpdesk visualization dashboard for Tdh Kenya operations in Dadaab and Kalobeyei settlements. # Tdh Kenya Helpdesk Data Dashboard An interactive **Streamlit** dashboard for exploring Terre des hommes (Tdh) Kenya protection-helpdesk records. It loads a cleaned Excel workbook, derives demographic and disability indicators (including Washington Group Short Set scoring), strips personally identifiable information, and presents filterable charts, cross-tabs, a GPS map, caseworker (CPV) productivity, and a searchable record viewer. > **Developed by John Kul, MEAL Officer – Tdh.** · *ImpactLens Africa — Turning Data Into Human Impact.* --- ## Table of contents - Features - Screens / tabs - Project structure - Requirements - Installation - Adding your data and logo - Running the app - Input data contract - How the analysis works - Filters & session behaviour - Privacy & safeguarding - Configuration reference - Troubleshooting - Deployment - Known notes - License & attribution --- ## Features - **KPI header** — valid records, protection concerns, information requests, partner referrals, follow-ups required, and disability records, each with a rate delta. - **Quick-insight cards** — busiest helpdesk, top request type, top protection concern, top impairment type. - **Eight sections** (Overview, Disability, Concerns, Information, Referrals, Map, CPV Work, Records). - **Gender-disaggregated** charts and pivot tables throughout, with consistent colour coding and totals. - **Washington Group (WGQ) disability analytics** for adults plus a separate child disability path, person-level prevalence, multiplicity, severity, and a reconciliation table. - **GPS validation** — coordinates are parsed, range-checked, and geofenced against expected Turkana West and Dadaab operational areas, with an outlier-review table. - **Cascading sidebar filters** (date → camp → helpdesk → demographics → request) that prune stale selections automatically. - **PII stripped** from everything the dashboard displays or exports. - **CSV export** of the filtered (and optionally searched) records. - …