The citywide intelligence hub is a business intelligence dashboard that provides up-to-date metrics about Coventry. The hub is intended to assist with the exploration and analysis of metrics and indicators to support local research and intelligence.
The citywide intelligence hub is made up of:
We have produced a set of e-learning masterclass videos on YouTube:
The system is designed by the Insight Team and ICT & Digital at Coventry City Council. It uses APIs to connect to a range of metrics about Coventry and relevant comparator areas from the internal Corporate Data Warehouse as well as external sources such as the Local Government Association's LGInformPlus and the Public Health England's Fingertips API. Metrics are stored in a data warehouse whereby any indicator with a defined geographical and time dimension can fit into the model. The citywide intelligence hub is built using Microsoft Power BI with additional features enabled through the TopoJSON shape maps derived from the Open Geography Portal and statistical analysis using the Craydec regression chart.