Download unemployment trend data for your custom areas

In Local Insight, you can explore how unemployment has evolved over the past year for all your custom areas. You can download this trend data for any area using the dashboard. This article provides a step-by-step of how to do that. 

Background

The unemployment benefit (JSA and Universal credit) indicator, often referred to as the ‘claimant count’, is published at LSOA level every month by The Department of Work and Pensions. In turn, Local Insight is updated to include the latest monthly snapshot. 

Since March 2020, rather than overwriting the previous timepoint, we have been adding each monthly snapshot as a new indicator. As a result, you can look at the month on month changes from March 2020 up to the latest published data (March 2021 at the time of writing this article).

Youth unemployment

You can also view the monthly data for youth unemployment (aged 18-24). This indicator shows the proportion of people aged 18-24 receiving Jobseekers Allowance (JSA) or Universal Credit for those who are out of work (in the ‘searching for work’ conditionality group) aged 18-24 (as a % of all 18-24 year olds).

Use the dashboard to download the month on month data for your custom areas

Follow these steps to build a dashboard displaying the individual unemployment claimant count datasets for each month for your areas. 

  1. Open the Dashboard tab 
  2. Use the Areas button to select the areas you would like to display
  3. Click on the Data button and select build a custom dashboard 
  4. In the search bar type Unemployment benefit (JSA and Universal Credit) or Youth unemployment (18-24 receiving JSA or Universal Credit)
  5. On the right hand side it will now display all the different timepoints
  6. Select the timepoints in the order in which you want them to display 
  7. Click Done

Once you have created your dashboard, you can either view it on Local Insight or export it to Excel. 

You can also copy and paste the dashboard into Excel and keep the colour scale

Create a chart in Excel to show how the data has changed over time

Once you have exported the raw data from the Dashboard, you can then import it into other data visualisation tools such as Power Bi or create charts and graphs directly in Excel.

Round up decimals

Firstly, you may want to round up decimals. You can use the shortcut option here on the Home tab under the ‘Number’ section circled below. These two options allow you to either increase/decrease the decimal places displayed. 

Line chart for time-series data

To visualise the data, a line chart is the most effective way to display changes over time. You can create a line chart in Excel to show the Unemployment time-series data for each of your areas.

Creating a line chart

  • Select the cells from your dashboard export that you want to include in the chart (it is best to do this for a small number of areas/comparators as the chart will look crowded otherwise).
  • Go to the Insert tab and locate the options for Charts, click on Recommended Charts, this will bring up the charts Excel recommends as appropriate, in this case, it’s a line chart which is the most effective way to display time-series data. Click OK to create the chart.

  • You can format the chart however you like by selecting the chart and bringing up the Formatting sidebar – use this to give the chart a title, change the colour, axes display, and much more.
  • You can paste the chart into a document as an image, copy the chart and paste, and on paste options, there is an option for ‘Picture’ that pastes it as an image.

Please note, currently when you export the Dashboard the national comparator data is not in the CSV. To add it in, you can copy and paste it directly from the dashboard. 

Metadata

When exporting data from Local Insight to use in other reports we would always recommend taking the metadata too. Metadata is contextual information about the dataset covering; the methodology, the time period the data relates to, the update frequency and the publisher. 

To see the metadata for a dataset on the Dashboard click on the dataset name. 

View the unemployment trend data on the map

You can view each monthly snapshot of the unemployment data on the map.

  1. Navigate to the map page
  2. Click on the Data button
  3. Search Unemployment using the search bar
  4. You will see the most recent Unemployment benefit (JSA and Universal credit) indicator for the month of March 2021 and the 11 historic timepoints listed beneath

View the count data alongside the percentage figures 

When you view a dataset on the map you can see the count data within the data for more areas popup. To view and download the count data you can do the following: 

  1. Click on the Data button on the map page 
  2. Locate the indicator you are after by searching Unemployment benefit (JSA and Universal credit)
  3. Select to view the dataset on the map
  4. Click on the Info button in the top right corner
  5. Click on the Data for your areas button 
  6. Click Download this dataset in CSV format

This will open up a data table containing all the percentage data in the first column and the count data in the second column. 

Reports

In the reports you can see how the data has changed over a much longer time period (2004 to 2021) in charts (page 10).

Local unemployment data is useful for…

The unemployment benefit data gives the most comprehensive figures at a local level of those that are currently unemployed. You can explore the raw LSOA data from The Department of Work and Pensions but in Local Insight you can see the data aggregated for any area that you create in the tool.  

Read more about different measures of unemployment and how the data should and shouldn’t be used. 

Want more time-series data in Local Insight?

We are looking at options to include more time-series data within Local Insight. Please email support@ocsi.co.uk with any suggestions.

 

Introducing the revamped Help Centre in Local Insight

The Local Insight Help Centre has had a makeover. It is now easier to find the information and support materials you need to help you get the most out of Local Insight. 

You can access the Help Centre from the Support tab at the top of Local Insight. 

What’s new?

Alongside aesthetic improvements we have added some new features:

  • Getting started video series  
  • New articles
  • Webinar programme 
  • User permission information 

Getting started video series

The video selection can be found in the carousel at the bottom of the Help Centre. The videos are short demonstrations of how to do some of the basics in Local Insight. This is a useful resource for people who are new to Local Insight at your organisation.

Currently, there are videos on: 

If you have any suggestions for more videos let us know on support@ocsi.co.uk 

New articles

We have added lots of new articles. This includes in depth articles on the data processes and mechanics that underpin Local Insight in the new Data and geographies category.

There is also a new section on how data is calculated for different custom areas. This is a question we get asked a lot and so, we wanted to publish the information so that everyone can understand how custom areas are defined. Find these articles under the Areas category.

Webinar programme 

We run monthly webinars that are open to all users of Local Insight. You can sign up through the Webinars tab found at the bottom of the Help Centre page.

This will redirect you to the Local Insight Eventbrite page that lists all the upcoming webinars. 

User permission information 

Not every user has access to all the features in Local Insight. There are 3 different levels of access permission. To help you understand the features you can and cannot access, there are now user permission notes at the top of relevant articles.

There is also an article that shows you how to understand the user permission level you have

Get in touch

The Help Centre is a great place to look if you have a question about Local Insight. However, you can still contact us on support@ocsi.co.uk if you need help. 

We are always looking to improve Local Insight and the support materials. So any feedback on the tool or article suggestions are welcome!

 

Office Christmas closure

OCSI will be closed from Monday 21 December to Friday 1 January inclusive.

We will not be able to respond to any Local Insight support requests during this time. We will answer emails when the office re-opens Monday 4 January.

We hope you have a lovely break over the festive period!

Download all the data in Local Insight at MSOA level

We have extended the All Data Download feature so that you can now download all the data (more than 1000 datasets) in Local Insight at MSOA level as well as at LSOA level. 

We hope that access to the raw data at both LSOA and MSOA level will make further analysis even easier. 

How to download the data 

Both the MSOA and the LSOA data downloads are accessible as CSV files on the Reports tab. The files will be updated on a quarterly basis, so that you always have the latest data at your fingertips. We will send an email notification to all users every time the files are updated.

Please note, the All Data Download is not available for public access sites

What does the file contain?

Data download for all LSOAs in England – This file contains data for all the indicators in Local Insight at LSOA level, as well as the associated metadata (e.g. name, description, date, source).

Data download for all MSOAs in England – This file contains data for all the indicators in Local Insight at MSOA level, as well as the associated metadata (e.g. name, description, date, source). 

How to find the MSOAs you care about

Column E indicates the Local Authority each MSOA resides in. You can filter this column to show only the MSOAs for a selected Local Authority / number of Local Authorities. This will make the file more manageable. 

Further analysis

The All Data Download makes further analysis easier outside of Local Insight. For example, anybody within your organisation could very quickly and easily:

  • Use Excel or other visualisation tools to produce your own charts and tables for use in your analysis.
  • Identify which (if any) of your LSOAs/MSOAs are in the 10% most deprived nationally for the index of multiple deprivation.

Or you could delve even further into the data, using the Rank command in Excel for benchmarking or using conditional formatting to see whether the areas you care about score relatively high or low compared to other areas. 

Download data for other geographies  

To download data for your custom areas in Local Insight you can build a custom dashboard and export the data.

Full guidance and feedback

For more information on using the All Data Download, please read through the Help Centre.

If you have any thoughts and feedback on this new addition then get in touch on support@ocsi.co.uk. We’d love to hear how you are going to use the All Data Download and if there is anything we can do to make the process of accessing and analysing data any easier.

Time series data for unemployment benefit in Local Insight

Explore how unemployment is changing during the COVID-19 pandemic and subsequent lockdowns with times series data in Local Insight. 

The Department for Work and Pensions publishes Unemployment benefit (JSA and Universal credit) every month. In turn, we update the data in Local Insight  to show the latest monthly snapshot. 

Given the dramatic changes to unemployment and the effects that it may have on your communities, we have added in the previous 3 months unemployment benefit data as individual indicators, so that you can see the month-on-month change for your areas. These datasets can be displayed on the map and downloaded for your custom areas.

Alongside the usual monthly updates for Unemployment (June 2020), we have added 3 historical time-points for the indicator Unemployment benefit (JSA and Universal credit):

  • March 2020
  • April 2020
  • May 2020

How to view this data on Local Insight

The map

  1. Click on the Data button
  2. Search Unemployment using the search bar
  3. You will see the most recent Unemployment benefit (JSA and Universal credit) indicator for the month of June 2020 and the 3 historic timepoints listed beneath

Click on image to see full size

Download the data for all 4 timepoints for your custom areas

  1. Click on the Data button
  2. Search Unemployment using the search bar
  3. You will see the most recent Unemployment benefit (JSA and Universal credit) indicator for the month of June 2020 and the 3 historic timepoints listed beneath
  4. Select the first time point
  5. Click on the Info button
  6. Click Data for your areas (this will open up a popup with data for your custom areas)
  7. Click Download this dataset in CSV format
  8. Repeat this process for the other 3 timepoints 

Click on image to see full size

Please note in the Data for your areas popup the table of data has two columns. The first column shows the percentage figure, the second column shows the count data. When you export the data to a CSV only the percentage figure is exported. Adding the count data to the export is one of the development priorities for Local Insight in 2020 and will be coming soon. 

Download the time series data for your custom areas using the dashboard

Select the data you want to show 

  • Open the Dashboard tab 
  • Click on the Data button 
  • Select Build a custom dashboard
  • Type in Unemployment benefit (JSA and Universal Credit) into the search bar
  • You will then see all the time points available listed 
  • Select the time points that you want to show in (they will show in order of selection) 
  • Once you have selected all the time points click Done

Select the areas you want to show 

  • Click on the Areas button 
  • Select the area you want to show 
  • Click Done 

Export the data 

Click on the export button to export the data into a CSV.

In the reports 

This data has not been added to the reports. The reports do however already contain a chart that shows how Unemployment benefit (JSA and Universal credit) has changed since 2004 (page 10).

Figure: Unemployment benefit (Jobseekers Allowance/Universal Credit) claimants Source: Department for Work and Pensions

Figure: Unemployment benefit (Jobseekers Allowance/Universal Credit) claimants
Source: Department for Work and Pensions

Would you like to see more time series data in Local Insight?

We are looking at options to include more time series data within Local Insight. Please email support@ocsi.co.uk with any suggestions for what would be useful and to register interest in taking part in future user research on this topic. 

Removed Monthly Change in Unemployment Indicator

We have removed the indicator Monthly Change in Unemployment. The new indicators for Unemployment benefit (JSA and Universal credit) for the last four months supersede this indicator. For those groups who had it assigned to a theme, it will no longer be available. 

Further reading

If you are interested in how COVID-19 has affected employment and the economy more broadly, take a look at some of our recent analysis: 

Improvements to Local Insight to help save you time

One part of our current development plan is to improve Local Insight so you spend less time searching for data and more time using data.

We are excited to introduce two new improvements that enable you to:

  • Search for indicators on the map more easily
  • Identify your areas with ease using MSOA names 

Search for indicators on the map more easily

One of our users described Local Insight as their ‘Data Dictionary’. We love this description as it captures the breadth of data available in the tool (over 1000 indicators in fact!). With so much data available, being able to find what you are looking for quickly is important.

We have added a search bar to the Data dropdown on the Map page so that you can hone in on what you are interested in, in far fewer clicks.

Data search bar

How to use

  1. Click on the Data button to open the menu of themes and their indicators 
  2. The search bar is at the top. Type in any text and the indicators that contain that string of text will be displayed under their theme heading
  3. Click on an indicator name to view it on the map
  4. To show the full menu of indicators again, delete the text in the search bar 

Please note: Not all indicators within Local Insight are shown within the Data menu by default. There are over 1000 datasets in Local Insight and the Group Admin user(s) select which ones are shown. If a user searches for an indicator that is available in Local Insight but not assigned to a theme then nothing will come up in the search.

 

Identify your areas with ease using MSOA names 

MSOAs are an integral geography in Local Insight. You can view indicators on the map at MSOA level and you can create custom areas out of MSOAs. However, MSOA codes are not easily recognisable – they are made up of two parts: The parent Local Authority and a string of numbers. For example, Westminster 018. 

Meaningful Names

The House of Commons Library has created a set of meaningful names for MSOAs (also available on an interactive map). We have added these names into Local Insight to make it easier for you to find the areas you are interested in. As part of this, we have also changed the LSOA names to incorporate the name of the parent MSOA to help you have a better idea of where the LSOA is located.

 

Previous MSOA code New MSOA names 
Westminster 018 Strand, St James & Mayfair – Westminster 018
Westminster 019 Knightsbridge, Belgravia & Hyde Park – Westminster 019
Westminster 020 Central Westminster – Westminster 020


Where can you see these new names?

The names can be found in two places on Local Insight: 

  • When hovering over areas on the map
  • When creating custom areas out of MSOA or LSOA areas

 

When hovering over areas on the map

  1. Choose an indicator from the Data button and select to display it on the map 
  2. Zoom in to view the data at either MSOA or LSOA level (the Info popup will inform you at which level you are viewing the data)
  3. Minimise the Info popup, and then hover over the areas on the map
  4. In the top right hand corner will be a small box that displays the MSOA/LSOA area name and the value for that area

MSOA hover

 

When creating custom areas out of MSOA or LSOA areas

In Local Insight, you can create areas made up of MSOAs and LSOAs. The new names will now display in the custom area creation popup. 

  1. Click Group Admin Manage custom areas
    1. Click Add custom area
    2. Select Custom Area Type Based on standard area
  2. Select to browse the list of MSOAs or LSOAs

MSOA names

Please note: Only Group Admin and Power Users can create custom areas in Local Insight.

If you are unfamiliar with the terms LSOA and MSOA, these are statistical geographies created for the Census. Read more about them in our blog: LSOAs, LEPs and lookups : A beginner’s guide to statistical geographies.

Get in touch!

If you have any questions, please do not hesitate to get in touch with us on support@ocsi.co.uk or give us a call on 01273 810270

Learn how to upload your grant data to Local Insight

At the end of 2019 we extended the services functionality in Local Insight, which can be used to upload and overlay grant data alongside the standard socio-economic datasets within Local Insight. 

Join us for a training webinar here if you want to learn more about layering funding data on the Local Insight maps.

This blog gives some examples of what you could upload including a mini case study from Oxfordshire Community Foundation.

What kind of data can you upload?

The Services feature enables you to upload your grant data. In fact any data held at postcode level can be uploaded using this feature. Once uploaded it will show as markers on the map, which can be clicked on for more information.

There is support material available on the Help Centre on how to format and upload data to Local Insight using this feature.

An example of how data must be formatted in a CSV for it to be uploaded to Local Insight.

An example of how data must be formatted in a CSV for it to be uploaded to Local Insight.

 

Image caption: Once uploaded, the data shows as icons on the map, which can be selected on and off using the services button.

Once uploaded, the data shows as icons on the map, which can be selected on and off using the services button.

Use cases

Upload grants awarded data for your organisation 

Uploading all your grants awarded data for a particular funding round or financial year is a quick and easy way to visualise where your grants have been made.

The new functionality allows you to provide more context, such as the amount awarded, details on the organisation and when the grant was made. This can help your team understand whether particular types of organisations are being under-represented or whether there are any areas missing out on funding. 

You can use the Display Mode to enter full screen and then take a screenshot of the maps to add into presentations.

Image caption: In this example the grant data has been catagorised (using the service type column) by year awarded.

 In this example, the grant data has been categorised (using the service type column) by year awarded.

 

Image caption: The tick boxes next to the year awarded date can be selected/unselected to edit what is displayed on the map.

The tick boxes next to the year awarded date can be selected/unselected to edit what is displayed on the map.

Upload all the grants awarded by major funders in your patch 

Alongside your own data, you can also upload grant-making data from other funders in your area to better understand who is funding what and where, as well as whether there are any funding gaps. 

Lots of organisations publish their grant data using 360 Giving’s data standard, which is made available to explore easily via GrantNav. This data can be filtered and exported by region, district, funders, amount awarded and award year. Once exported, a little reformatting is required and then this can be uploaded into Local Insight (we have put together guidance on how to format data to help you). 

Image caption: This shows GrantNav filtered by district.

 This shows GrantNav filtered by district.

 

Image caption: In this example the grant data has been categorised (using the service type column) by the name of the funding organisation.

 In this example, the grant data has been categorised (using the service type column) by the name of the funding organisation.

 

Image caption: The tick boxes next to the funding organsation names can be selected/unselected to change what is displayed on the map.

The tick boxes next to the funding organisation names can be selected/unselected to change what is displayed on the map.

 

Join us for a webinar at 2pm on Tuesday 17 March where we will run through how to filter, export and reformat data from GrantNav for Local Insight.

Upload a round of grant applications for a panel

Upload a round of grant applications for a specific programme in order to aid decisions on how well they address fund criteria.

This can be used as additional guidance during panel meetings. At a click of a button, the panel can find out more information about the organisation applying for the grant, including potential beneficiaries and whether the organisation has received funding previously. You can of course also compare the grant application to data on the local need that is already preloaded into Local Insight for you.

Alongside the expertise of your grant panel, access to this contextual information can help ensure that grants are awarded to maximise the positive impact of your funding in the community. 

Image caption: dummy grant application data. In this example, the application is for a project to support employment for young people in the area.

Dummy grant application data. In this example, the application is for a project to support employment for young people in the area.

Image caption: The indicator youth unemployment (18-24) receiving JSA or Universal Credit is overlaid alongside the grant application to demonstrate the need in the area.

The indicator youth unemployment (18-24) receiving JSA or Universal Credit is overlaid alongside the grant application to demonstrate the need in the area.

How Oxfordshire Community Foundation used this new functionality? 

We caught up with Simon (Community Impact Analyst) from Oxfordshire Community Foundation (OCF) to see how they are using the new functionality. 

OCF wanted a way to map all the charities they have funded and then layer that data alongside the deprivation data on Local Insight. The aim was to identify both the needs of an area and the services already available that meet that need.  

The new functionality on Local Insight allowed them to upload the charity data and categorise it according to the theme it addressed (such as relief of poverty, community cohesion, health and wellbeing). For each charity, they uploaded additional information to show the name, beneficiaries, charity number and charity website. Alongside this, they could then overlay standard Local Insight datasets showing local need.  

The additional information they can now add into Local Insight means that the tool can be used to not only provide underlying data about local need, but also signpost users to other third sector organisations already working in that space. 

image 10

image 11

The maps OCF have created on Local Insight have already been useful, for example, they were approached by a local group looking to renovate a condemned church and turn it into a community asset. Using Local Insight, OCF were able to quickly display the location of the church and overlay the Community Needs Index (a composite indicator which measures social and cultural factors that can contribute to poorer life outcomes). They were also then able to layer the charities that work in that area and could provide the group with contact details and information on other groups working in this space.

Get in touch!

If you have any questions, please do not hesitate to get in touch with us on support@ocsi.co.uk or give us a call on 01273 810270

Local Insight in 2020

Local Insight is an evolving product and this year is no different. This blog outlines the Local Insight product plan for 2020.

The plan focuses on updates that will help save you time, get data for the areas you care about and be more confident in using the data. This is based upon feedback gathered during the Local Insight user group as well as feedback we receive throughout the year. 

Above and beyond the developments listed below, there is scope for additional improvements, so please keep voicing any development ideas you have. 

Save time

Spend less time searching for data and more time using data.

Search for indicators on the map more easily 

One of our clients described Local Insight as their Data Dictionary. We love this description as it captures the breadth of data available in the tool (over 1000 indicators in fact!). With so much data available, being able to find what you are looking for quickly is important. 

This year we will add a search bar to the Data dropdown on the Map page so that you can hone in on what you are interested in, in far fewer clicks.

Export the (N) values on the Data for more areas popup

This update will improve the export from the Data for more areas popup. You will be able to export total counts figures (where applicable) alongside percentage figures so that you can do further analysis or build your own visualisations.

Identify your areas with ease using MSOA names 

The House of Commons Library has created a set of recognisable names for MSOAs (also available on an interactive map). A number of users have requested that we add these names to Local Insight alongside the area codes so that standard areas display with more meaningful names. As part of this, we also propose changing the LSOA names to incorporate the name of the parent MSOA to help users have a better idea of where the LSOA is located.
This will make it easier to:

  • Identify local areas when hovering over the MSOA or LSOA data on the map
  • Find the MSOAs/LSOAs you want quickly when creating areas based on standard areas

MSOA names

See data for all the areas you care about  

No area is off bounds. 

Local Authority boundary changes

As of 1 April 2019, a number of new Unitary Authorities were formed. This spring, we are updating the Local Authority boundaries in Local Insight to reflect these changes.

Display multiple area boundaries on the map 

The current interface allows you to select a single custom area to view on the map at a time. With this update you will be able to view multiple custom areas, or even a whole category of areas, simultaneously. This will make it easier to see how your areas compare on different datasets within the map itself. 

Areas on the map

Be more confident in the data

Access resources and improved guidance so that you can be more confident using Local Insight. 

Revamping the Help Centre

We are improving the Help Centre to give you all the information you need to get the most out of Local Insight. You can look forward to more dynamic content including:

  • A new section on open data resources
  • More “how to” guides and blogs 
  • More information on how data is apportioned and aggregated

If you have any suggestions for resources you would like to see, please send them to support@ocsi.co.uk 

Help Centre

Lastly, if you would like to discuss any of the upcoming developments, please email support@ocsi.co.uk 

How to create custom areas based on top 10% most deprived LSOAs

Within Local Insight it is really quick and easy to set up any custom geography you are interested in – whether that is a ward, a local authority, parish or GP locality.

Another type of area that may be of particular use to you, is a composite area of all the LSOAs in your service patch that fall within the top 10% or 20% most deprived nationally, according to the Index of Multiple Deprivation.

It is fairly straightforward to work out which LSOAs fall within these deciles in your area and then create a custom area based upon these LSOAs through selecting from the standard areas dropdown.

Step-by-step guide

Here is a step-by-step guide for identifying the LSOAs to include, with the help of a handy tool from Swirrl.

1. Open the IMD Explorer tool

Visit http://imd-by-geo.opendatacommunities.org/imd/2019/area

2. Select the geography

Select the Local Authority or County that you are interested in from the list.

3. Select the index you are interested in:

Most organisations will likely be interested in the overall Index of Multiple Deprivation. However, if you are interested in a particular theme, such as health or employment, you can choose one of these domains instead.

4. Select the decile you are interested in:

If you are interested in the top 10% most deprived LSOAs, select decile 1 and download

If you are interested in the top 20% most deprived LSOAs, you will need to download the data for decile 1 and decile 2 separately

NB: If this produces an empty file, it means that there are no LSOAs within your service patch that fall within this decile.

The following steps assume you are looking at the top 10% most deprived (decile 1). You will need to repeat these steps for decile 2 if you are looking at the top 20% most deprived.

5. Remove duplicates

The file you have downloaded provides you with all of the postcodes that are in the top 10% most deprived alongside their corresponding LSOA codes. For this purpose, we are only interested in the LSOAs that are in the top 10% most deprived, so you need to remove the duplicates in the LSOA code column (column C). To do this:

  1. Click on the Data tab in the tool bar
  2. Select Remove Duplicates
  3. Select the ‘LSOA Code’ check box only
  4. This is now your list of individual LSOAs within your service patch that fall in the top 10% most deprived nationally.
remove duplicates

Click on image to see full size

6. Create your custom area in Local Insight

You can now create your custom area in Local Insight. Please note, you must be a Power User or Group Admin to be able to do this.

The easiest method to create the area in Local Insight is through the Create a custom area by selecting a standard area option. This guidance is for users looking at one local authority. If you are creating an area for a county, please see step 7.

  1. Provide a name and description for your area (Please note names cannot be longer than 255 characters)
  2. In the custom area type box, select create area based on standard area
  3. Select LSOA as the geography
  4. Select the local authority the LSOAs are in
  5. Select from the dropdown all the LSOA codes that correspond to those in your download (if you have a few LSOAs you can use Control+F, or Command+F on a Mac to find the codes you need)
  6. Save the custom area
create custom area

Click on image to see full size

7. Create custom area that spans multiple local authorities

If you are creating a custom area that spans multiple local authorities (such as a county), please send the full list of LSOA codes you would like included in your area to support@ocsi.co.uk and we can set this up for you.

8. Explore data for your custom area

Your custom area is now ready to use. You can now:

Add additional information to your services on Local Insight

We have made some major improvements to the Services feature on Local Insight so that you can now provide more contextual information to each of the individual service locations on the map.

GPs norfolk demo

 

The enhanced functionality allows you to add more locally held information to Local Insight so that you can signpost users to important information about their local services. As well as being able to say where a particular service is – you can also include contextual information quickly and easily in the same place. Coupled with the open data available within the system and the locally held datasets you can add in, this improved functionality contributes to making Local Insight a one-stop shop for local information for you and your strategic partners.

The developments focus on:

  • Enhancing the Services functionality to allow you to add additional information to your individual service locations
  • Improving the error feedback and the importing process so that you have a more streamlined experience

This blog is here to give you a rundown of all the changes including:

  • What’s new?
  • What has been improved?
  • Potential use cases

This functionality has been in the pipeline for a while and was voted a priority at the 2018 Local Insight user group so we are delighted that it is now up and running.

The developments & design were improved through the user testing period so a big thank you to everyone who spent time providing us with valuable feedback.

For step-by-step guidance, please read through the Manage Services section on the Help Centre.

What’s new in Local Insight?

Previously, you could upload your services, categorise them into a maximum of 30 types and then view those locations on the map. Now, along with assigning your services a type you can also add contextual information for each individual service, which can then be displayed on the map.

Adding metadata is optional and completely customisable. To add metadata to your service data you can input data in the 5 columns to the right of the postcode and service type columns.

2

Below is an example of how metadata will display on the map once uploaded.

3

For step-by-step guidance, please read through the Manage Services section on the Help Centre.

What has been improved?

We ran extensive beta testing on this new functionality to ensure it meets the needs of our user base. The below improvements have been informed by the beta testing.

You no longer have to add UPRNs
Previously when you uploaded services you needed to add a Unique Property Reference Number (UPRN) in the first column. The purpose of this was to inform Local Insight that each row was a separate service, even if postcodes were duplicated. Local Insight now intuitively knows that each row is a separate service so you don’t have to waste time putting in arbitrary UPRNS.

Please note. If your services have UPRNs that you wanted to keep in the tool, then get in touch at support@ocsi.co.uk as we have the UPRNs in the database and can send them to you. You can then add them back in as metadata if you wanted to still see the UPRNs on the map.

Removed copy and paste option
Previously, you could upload your services by either copying and pasting or uploading a CSV. We have removed the copy and paste option. Removing this option allowed us to focus on improving the error feedback and speeding up the upload process as these were highlighted as priorities during beta testing.

Better error feedback
We have improved the error feedback you receive when uploading services so that any formatting issues can easily be identified and rectified. This should make uploading services a smoother & less confusing process.

Potential use cases

Community Foundations

If you are a community foundation, you could upload the organisations you fund as Services and add metadata to provide additional information on the grants that they have applied for and received.

To illustrate this, the below example shows The Barrow Cadbury Trust grant data from GrantNav, reformatted and uploaded into Local Insight.

  • For the postcode column, the Recipient Org: Postal Code was used
  • For the service type column, the Grant Programme title was used
  • 4 columns of metadata were then added, including Grant Title, Grant Description, Amount Awarded and Recipient Org Name

The image below displays how the first row of data is formatted so it can be uploaded into Local Insight

4

The image below shows how that data will display on Local Insight when the service icon is clicked on.

5

Uploading this information would allow you to visualise all the grant applications geographically and then overlay the socio-economic datasets in Local Insight to gain an understanding of the characteristics of that area to explore whether local giving is going to the places most in need.

Local Authorities

If you are a Local Authority who has a public-facing Local Insight site then you could upload useful information about local services to help signpost information to public users.

To illustrate this, the below example shows GP surgeries in North Somerset published on Data.gov.uk by North Somerset Council reformatted and uploaded into Local Insight.

  • For the postcode column, the postcodes downloaded from Data.gov.uk were used
  • For the service type column, GP Surgery name was assigned for all postcodes
  • 3 columns of metadata were then added, including GP Surgery name, Address line and Telephone No.

The image below displays how the data is formatted so it can be uploaded into Local Insight

6

The image below shows how that data will display on Local Insight when the service icons are clicked on.

7

As it’s election day…

The services functionality has been designed to be completely customisable so it can be used to upload a whole range of information. As today is a general election, the below example shows all the polling stations in the London Borough of Hammersmith and Fulham.

The polling station data was downloaded from Data.gov.uk and published by London Borough of Hammersmith and Fulham

  • For the postcode column, the postcodes downloaded from Data.gov.uk were used
  • For the service type column, polling station was assigned for all postcodes
  • 2 columns of metadata were then added, including Location and Name

The image below displays how the data is formatted so it can be uploaded into Local Insight.

8

The image below shows how that data will display on Local Insight when the service icons are clicked on.

9

Feedback
Once again, thank you to all those users who took part in beta testing to help us develop this. We are always looking for more feedback and would also love to hear how you are using the improved Services functionality, so please do get in touch with us on support@ocsi.co.uk