Citywide intelligence hub

About the CitywideIntelHub

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:

  • a profiler that allows users to compare and contrast metrics between different geographies and time periods using data tables, bar charts, line graphs and shape maps;
  • a correlator that shows the correlation between any two metrics; and
  • a comparator providing a double map for comparing metrics for small areas.

 

How to use the citywide intelligence hub

We have produced a set of e-learning masterclass videos on YouTube:

Technical information

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.

Insight

Email: [email protected]

Tel: Please email

Coventry City Council
PO Box 15
Council House
Coventry
CV1 5RR

Is there anything wrong with this page?