The Story of Redbridge
The Story of Redbridge offers an extensive view of Redbridge covering various topics, it covers over 50 dashboard pages of resident data including topics such as health, business and public services.
The Story of Redbridge is the result of several months’ work in the business intelligence unit researching open source data about Redbridge residents, leading to development of a visually rich Power Bi dashboard.
It takes core themes such as population, ethnicity, education, health wellbeing, transportation and deprivation and enables the user to interact with a series of maps graphs and tables.
This helps services better understand potential issues or changes in the Redbridge population using data from the past, present and future.
Cllr Helen Coomb, Redbridge Council Cabinet Member for Transformation and Engagement, said:
‘The Story of Redbridge’ is set to be an invaluable tool to anyone with an interest in the area – including those thinking of moving to Redbridge. The easy-to-use tool shares information on a multitude of topics including population, business, income, ethnicity, education, transportation, health and wellbeing – all of which can help shape and improve decision making across all levels including from where to live to starting a new business in the area. Community groups, the voluntary sector and contractors interested in working in Redbridge are also set to benefit as the site provides up-to-date information on the urban landscape to help tailor procurement or commissioning bids. It also allows residents to view trends in their areas and enables users to interact with a series of maps, graphs and tables.'
Using the Story of Redbridge
The best way of starting to use the functionality in the Story of Redbridge is to simply start clicking. You can’t break it and if it freezes then you can just refresh your browse page and start using it again. Most visualisations like graphs or maps allow you to click on them and the data will contract to the item you are selecting.
For example, click on an area of a map and the data will only show you what data is there for all the visualisations on the page. Click on the outside of the map (just outside the boundary) and see the whole borough picture again. If you want to look at 2 wards and aggregate the data for these areas then hold down Ctrl + left click. You can do this as many times as there are areas.
(Note, on some pages specific graphs may not be responsive this is because the designer has turned off this functionality)
Why have we created the Story of Redbridge?
There is lots of open data out in the public domain. It enables anyone to answer their own questions. By joining data together using common geographical areas these mini datasets and stories become one that informs the borough about its collective identity.
Often this is raw open data requires technical knowledge to bring it to life. This is where the story of the borough comes in. Interactive data visualizations called dashboards begin to allow non-technical users to quickly explore data and facilitate their understanding.
What data has been used in the creation of the Story of Redbridge?
The story of Redbridge uses open data that has been taken from a range of areas such as the Census, Greater London Authority and Office for National statistics. These are referenced on each page of the dashboard.
Why does the of Redbridge show the old wards?
The Story of Redbridge uses datasets that are refreshed at different intervals. Legislation allows electoral boundaries including ward boundaries to be changed by Councilors and MPs to reflect population changes. A cross party review undertook this in Redbridge and wards changed in early 2018. When a change is made the new changes in data takes time to catch up and reflect these. Changes are therefore dependent on how frequent a dataset is refreshed by the data holder/creator.
What is the Indices of Multiple Deprivation (IMD)?
The IMD is the Government’s official measure of deprivation created from the Department for Communities and Local Government. The Indices shows that London remains an area of mixed fortunes, with some wealthier areas alongside pockets of deprivation across the capital.
A GLA Intelligence Briefing gives information about the components of the Indices and how they are constructed and an analysis of the results for London.
Local Insight is a community focused Geographical Information System (GIS) system that provides vital information on the communities you work in. Local Insight is based on the successful Community Insight platform, developed by OCSI and HACT for the social housing sector. It is a web-based service that accesses Oxford Consultants for Social Inclusion’s (OCSI) huge database of constantly updated public data. Its mapping base is Google’s well tested Google Maps technology.
Local Insight can be used to:
- Create in-depth community profiles for each of your neighbourhoods
- Export easy to use maps, charts and data to use in your own reports
- Track and understand change over time
- Identify “hotspots” where need is greater
- Access the information necessary to prioritise and target community investment
- Generate information to inform bids and tenders, or community consultations and neighbourhood planning
- Access new Census, welfare and other data on your communities as it is released
- Provide real world data to feed into social impact measurement and assessment tools.
Who can use it?
Local Insight is designed for easy use by staff across local authorities and community organisations. Anyone with an interest in understanding the communities they work in better can make use of it. From community development workers to commissioners, there are practical applications across the whole organisation. Councillors and senior managers and boards will also welcome its strategic overview of the communities they work in. We don’t limit the number or users per organisation.
How can I log-in?
Please contact Soumya Chatterjee by email who will set your account and access to the local insight portal.