How susai23/lincolnshire-adult-social-care-pipeline works
This repository implements a self-serve Lincolnshire Adult Social Care intelligence report: public population, outcomes and provider-quality data are cleaned, joined and aggregated, then presented in Power BI. The README documents the pipeline and report capabilities; no source excerpts were provided, so relationships below are limited to those documented there.
Main entry points: 02_build_dashboard_tables.sql Build dashboard tables · Lincolnshire Adult Social Care Data Pipeline.ipynb Cleaning notebook · Lincolnshire_Adult_Social_Care_Intelligence.pbix Interactive report · Cleaned data Tidy datasets
Components 14
Source data
- ASCOF outcomes
Raw data/ascof_2024_25.ods - Population estimates
Raw data/ons_population_2024.csv - Population projections
Raw data/ons_population_projections.xls - CQC directory
Raw data/cqc_lincolnshire_prefiltered.csv
Data preparation
- Cleaning notebook
Python/Lincolnshire Adult Social Care Data Pipeline.ipynb - Tidy datasets
Cleaned data
SQL aggregation
- Create tables
SQL/01_create_tables.sql - Build dashboard tables
SQL/02_build_dashboard_tables.sql - Demand dashboard data
Cleaned data/dashboard_demand.csv - Outcomes dashboard data
Cleaned data/dashboard_outcomes.csv - Provider dashboard data
Cleaned data/dashboard_providers.csv - Provider summary data
Cleaned data/dashboard_providers_summary.csv
Power BI report
- Interactive report
Power BI/Lincolnshire_Adult_Social_Care_Intelligence.pbix
Other components
- Report user
Connections 16
- ASCOF outcomes → Cleaning notebook: reads
README.md - Population estimates → Cleaning notebook: reads
README.md - Population projections → Cleaning notebook: reads
README.md - CQC directory → Cleaning notebook: reads
README.md - Cleaning notebook → Tidy datasets: writes tidy data
README.md - Tidy datasets → Create tables: loads cleaned CSVs
README.md - Create tables → Build dashboard tables: creates tables
README.md - Build dashboard tables → Demand dashboard data: builds dashboard data
README.md - Build dashboard tables → Outcomes dashboard data: builds dashboard data
README.md - Build dashboard tables → Provider dashboard data: builds dashboard data
README.md - Build dashboard tables → Provider summary data: builds dashboard data
README.md - Demand dashboard data → Interactive report: imports
README.md - Outcomes dashboard data → Interactive report: imports
README.md - Provider dashboard data → Interactive report: imports
README.md - Provider summary data → Interactive report: imports
README.md - Report user → Interactive report: views report
README.md