Dashboard: scc-pi.github.io/asc-localities-insight
Project board: github.com/scc-pi/asc-localities-insight/projects/1
The purpose is to provide some baseline statistics and mapping around Sheffield's ASC (Adult Social Care) localities for the ASC strategic needs analysis project.
SLI (Sheffield Local Insight) is used to obtain the data. An API for SLI is estimated to be available August 2022. Until then, the data for a bespoke dashboard is exported manually for each SLI theme e.g. population. To create a bespoke dashboard to export you need an SLI login.
SLI is geared towards providing information one area at a time. This dashboard is geared towards comparing the ASC localities against each other.
There are 7 ASC localities and they are identical to the Local Area Committees which are already on SLI.
The process is:
asc_sli_etl.Rprepares the SLI data.sli_measures_meta_etl.Rprepares the indicator metadata.sli_measures.xlsis used to specify which themes and indicators to include.asc_sli_dashboard.Rmdproduces the flexdashboard HTML file.
It will not take the inclusion of too many indicators to make the HTML file too big and slow it down. If a lot of measures need to be included it would be better as a Shiny dashboard, and because the data is publicly available it could be hosted on shinyapps.io.
The different_areas_xlsx_etl.R script produces a separate spreadsheet of all indicators with different sheets for ASC localities, Wards and neighbourhoods.
The code in this repo is largely derived from:
- Let’s Make a Map in R blog by Trafford Data Lab (February 2018)
- Dynamically Rendered Flexdashboard Pages Using RMarkdown Childs blog by SOMTOM (January 2019)
A similar debt is owed to the books R for Data Science and Geocomputation with R.