The shapefile importer is here!

 

We know this development was one of the top priorities from the Local Insight user group, so we’re excited to announce that you can now create custom areas by importing shapefiles!

What can you do with this new functionality?

Consider the situation where you have:

  • An area of interest stored away in another GIS platform but can’t recreate the area exactly in Local Insight
  • 100s of areas you would like to import into Local Insight, but know it would take considerable effort to import each area individually

Well, now you can solve both of these problems with the shapefile importer tool.

How to use this functionality

To import a shapefile you will need to:

  • Head to Group admin and then Manage custom areas
  • Alongside Add custom area and Add category you will find Import shapefile
  • Follow the onscreen instructions to make sure you’ve provided the right files and information
  • You’re ready to import!

Top tip: Your areas will all be added to the category ‘Uncategorised’, so we recommend moving any areas you have here already into another category.

Now, your new areas will magically appear in your list of custom areas!

See our shapefile importer documentation for a full description what’s needed and what to expect.

Let us know

Any feedback on the process would be greatly appreciated. Do let us know at support if you have any questions.

Happy importing!

 

 

Data updates in Local Insight

As promised, our second round of data updates this month!

The below table is a snapshot of some of the key datasets which have been updated. To see a full breakdown of all datasets added and updated this month, see our knowledge base article containing a list of all the datasets available in Local Insight.

Updated indicators

Indicators on Source Reports Maps
Average house price Land Registry Yes Yes
Number of property transactions Land Registry Yes Yes
Anti-social behaviour Police UK (Police recorded crime figures) Yes Yes
Children in poverty HM Revenue and Customs/Department for Work and Pensions (DWP) Yes Yes
Children in families receiving Support HM Revenue and Customs (HMRC) Yes Yes
Average consumption of domestic gas (per household) Department for Business, Energy and Industrial Strategy Yes Yes
Households not connected to the gas network Department for Business, Energy and Industrial Strategy Yes Yes

 

Current indicators available within Local Insight

To see a list of all of the current indicators available in Local Insight check out this knowledge base article containing a list of all the datasets available in Local Insight

Want to see more indicators within Local Insight?

We are always looking to add new indicators to Local Insight. So if you have any ideas of particular indicators you would like to see then let us know. Provided that the data is open data and published at small area level, so below Local Authority level, we will load the data in for you.

Get in touch!

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

Custom area boundary changes for Local Insight


We are always looking for ways to improve our tool, and a big part of what informs this is gathering feedback. One example of this is how we’ve heard from our users that they’d like the way custom areas are shown on the map to be more intuitive.

Well, we’ve taken that feedback on board and we’re making some important changes to how you view areas on the map.

What does this mean for me?

From now on, if you create a custom area using draw on the map or from a standard area, when displayed on the map:

  • The area will be outlined in black
  • The area will remain clear (and not filled in with a light grey colour)
  • You will be able to hover over or select LSOAs within your area

        

We’d love to hear from you!

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

 

Data updates in Local Insight

Data updates

This month we will have two data updates for you, with more coming at the end of the month. For now, we have updates from the Department for Work and Pensions (DWP):

  • Youth unemployment (18-24 receiving JSA or Universal Credit)
  • Unemployment benefit (JSA and Universal Credit)
  • Jobseekers Allowance claimants, claiming for over 12 months
  • Unemployment benefit (JSA and Universal Credit), female
  • Unemployment benefit (JSA and Universal Credit), male
  • Unemployment benefit

New Indicators

We’ve added two new indicators from HM Revenue and Customs (HMRC)/Department for Work and Pensions (DWP):

  • Children (0-15) in out-of-work families (includes families claiming Universal Credit)
  • Children and young people (0-18) in out-of-work families (includes families claiming Universal Credit)

Feature indicators in the reports

For those of you who are interested in the feature indicators which we have been adding over the past year, here is a breakdown of where those indicators can be found in the reports.

  • 10 year percentage change in house price – Page 25
  • Ratio of residential property transactions to the number of private dwellings – Page 25
  • Housing affordability measures – Page 26
  • Domestic energy consumption – Page 28
  • Energy efficiency- Page 29
  • Musculoskeletal conditions (arthritis) – Page 38
  • Physical activity among adults – Page 40
  • Household debt – Page 45
  • Broadband – Page 53
  • Community dynamics measures – Page 56
  • Greenspace coverage – Page 58
  • Big Lottery funding – 59

Current indicators available within Local Insight

To see a list of all of the current indicators available in Local Insight and also a list of the most recent round of updates check out this Knowledge Base article.

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

4 ways to encourage self service using Local Insight

Local Insight is designed to be easy to use and accessible by all – so that you don’t need to be a statistician to gain useful insights. Local Insight can help answer a lot of the day-to-day questions that people have about local statistics, freeing up the time of analysts to focus on the important stuff.

As a Local Insight subscription covers unlimited users, there is no reason why it shouldn’t be being used right across your organisation and beyond. However, it can only be used if people know it is there and know how to extract the information they need.

We have put together a few tips on promoting Local Insight within your organisation and beyond. If you have any tried and tested tactics to add, please let us know.

Some of the tips below refer specifically to public sites; however everything is possible using the standard Local Insight subscription (there may be a bit more overhead in these cases for setting up and managing users!). If you would like to know more about public sites, please get in touch.

For support and more information on any of the suggestions here, please get in touch on support@ocsi.co.uk

Find the data champions

Scouting out the individuals that are already sympathetic to the benefits of instant access to local data is a great place to start in increasing uptake of Local Insight.

Take the opportunity to ask lots of questions. What will be the most appealing part of Local Insight to their team? What custom areas and services would be most useful to add? What are the potential barriers to others using Local Insight?

Use this to help shape your approach when talking to new teams, and ask your ‘data champions’ if their experiences can be used as a case study.

In addition to your own organisational knowledge on potential data champions, do also look at your user logs in Local Insight, which could give you insight into your most active users. If you would like more information on who have been your most active users over the last 3 months, get in touch and we can provide some additional information for you.

Run mini training sessions

Offering mini lunchtime training sessions to specific services (for example; CVS, elected members or commissioners) is a great way to get the word out about Local Insight. In 30 minutes you can cover basic navigation of the tool, show people where they can access reports about their local areas and the breadth of data that is available.

Equally, scheduling regular “drop in” sessions for Local Insight related questions (whether these are virtual or in person) could help increase understanding of Local Insight and the data it holds.

And of course, providing some basic support materials (either printed copies or online) to go alongside the training. If you have a public site, we can add a basic user guide to the site for you. And if you do not have a public site, we can send a copy of this to you to distribute internally.

If you would like any advice on running short training sessions, or some help in putting support materials together, please get in touch and our team will be able to help you.

Using permalinks to signpost to specific datasets

We have recently updated Local Insight to allow you to directly share links to datasets on your maps. This is much easier for the end user if you have a public site (as they will not have to be set up as a user or logged in) but works for a standard Local Insight subscription too.

This makes it much easier to signpost users directly to datasets. For example;

  • Adding a direct link to the data in Local Insight in response to any data requests
  • Including hyperlinks to datasets in reports and presentations (please note, this example is better suited to public sites).

Internal bulletins / social media

“The rule of seven” is a concept used in advertising, that states a prospect needs to hear or see your message at least seven times before they’ll take any action. And this concept can be transferred to the many potential Local Insight users in your organisation.

Be repetitive, and be consistent with your promotion of Local Insight. Internal bulletins, social media, and your website are great channels to push your message through. For example

  • Highlight new datasets that have been added (using permalinks as above)
  • Pull out interesting statistics to include in social media posts
  • Add links to Local Insight in your email signature
  • Start a Local Insight User Group on LinkedIn or KnowledgeHub for your organisation
  • Signpost to Local Insight from any data / local statistics pages on your website

Disclaimer: Check with your comms teams that this is in line with your organisation’s policies.

If you have a public site, we can also provide you with monthly analytics on site usage. We can include information here on how people are reaching your site. This can help refine your approach and understand which channels are generating the most visits to your site. Get in touch if you would like us to set this up for you.

Your suggestions

What other tactics have you used to promote Local Insight within your organisation and beyond? What has worked well?

If you have any suggestions to add to these tips, please let us know at support@ocsi.co.uk

Data updates in Local Insight

As we get settled into the new year, we have plenty of data updates to get stuck into, with plenty from the Department for Work and Pensions (DWP), and several new indicators too:

New data

Percentage of children in poverty (after housing costs): End Child Poverty has published new figures on the level of child poverty in each constituency, local authority and ward in the UK. The Centre for Research in Social Policy makes these annual estimates for the End Child Poverty Coalition, allowing them to map the percentage of children in poverty at small area level for a snapshot of time (July – September 2017).

Please note: This dataset is not directly comparable to the previous Children in Poverty dataset included within Local Insight. As such, we have kept both datasets available. The previous indicator is called Children in poverty. Take a look at our blog for more on how the data was constructed and caveats for use.

Data on your local housing market: We have added two new measure of the local housing market:

  • Inflation adjusted 10 year house price change by house type (using the CPIH index)
  • Ratio of residential transactions to number of private dwellings – a measure of housing ‘churn’

Take a look at our blog for more on how these datasets were constructed and some headline trends.

New health measures: We have added data from Imperial College London, taken from a longitudinal study on a number of health conditions including:

  • Percentage of people aged 45+ with (severe) hip osteoarthritis
  • Percentage of people aged 45+ with (severe) knee osteoarthritis
  • Percentage of people with (severe) back pain

To add these new datasets to your maps and dashboards, you will need to use the Manage Indicators feature. Search in the Unassigned theme for the datasets and drag & drop to the theme you wish to display them in. If you have any trouble, get in touch on support@ocsi.co.uk

Data Updates

In addition to the new data, as always, we have ensured everything else is up-to-date, so that you can be confident you are using the most recent data available.

Indicators include:

  • DWP Claimants data
    • Attendance allowance (broken down by age, gender and higher / lower rate award)
    • Disability living allowance (broken down by age, gender and higher / lower rate award)
    • Employment and support allowance (broken down by age, gender, higher / lower rate and reason for claiming)
    • Income Support (broken down by gender and living arrangements)
    • Incapacity Benefit (broken down by age and gender)
    • Pension credit claimants
    • Unemployment benefit (JSA & Universal Credit)
    • Youth Unemployment
  • Life expectancy
    • Female life expectancy at birth
    • Male life expectancy at birth

And finally, due to Sport England’s correction for the Active Lives data, we have temporarily removed the indicator People physically active (at least 150 minutes per week in the past month) from Local Insight. When Sport England republish the data, which will also include a more recent time point, we will add this back into the tool.

Update your reports

Reports have been updated with the latest data. To see the latest data in your reports, you must generate new reports for your custom areas. You can do this one by one – or you can update all reports at once.

Please note: We recommend that if you are using the bulk update feature, to do this at the end of the day, then all reports will be ready and waiting for you the next morning.

Please read the full guidance on the Knowledge Base ahead of using this feature.

Current indicators available within Local Insight

Current indicators available within Local Insight. To see a list of all of the current indicators available in Local Insight and also a list of the most recent round of updates check out this Knowledge Base article.

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

Speed improvements

Our tech team have also been working away to improve overall site performance of Local Insight. The most recent updates have resulted in maps loading much faster with data – let us know if you have noticed any difference!

As always, if you have any questions at all on the data, please get in touch at support@ocsi.co.uk

Bulk update reports!

Update all your reports in one go

We strive to keep the Local Insight reports up-to-date, so that you can be confident that the data you are using is the most recent available.

Until now, this has meant a lot of laborious clicking to update your reports (especially if you have hundreds of custom areas!).

But we can do better that. We want Local Insight to be as easy to use and intuitive as possible. So, we are thrilled that you can now bulk update your reports!

This was one of the key feature developments requested by users at the Local Insight User Group. Alongside this brand new functionality, we have also made improvements in the background to ensure that the reports run as smoothly as possible.

How to use this feature?

  • Navigate to the Reports tab at the top of Local Insight (or navigate here)
  • There will now be showing a new button which looks like this (see below image)
  • Click the button and shazzam, all your reports will begin to update! (please see the ‘Top tip’ section below for the best times to update your reports)

How long will it take to update all reports?

The time it takes to update all your reports depends on how many you have. Roughly, each report takes around 10 minutes and they will appear in the Reports tab in sequential order. Please note, this will depend on how many other users have also updated all of their reports, so this may take longer during peak times (i.e. following monthly communication about updates to reports).

Top tip

If you are using the Update all reports button we recommend that you do this at the end of the day, then they will all be ready and waiting when you arrive in the morning. This will also help to ensure that reports run smoothly for other users.

Please note: You will not be able to generate/update any reports individually until the ‘update all reports’ task has fully completed (i.e. all your reports have updated). There is no queue jumping, so if there are a few reports you would like immediately, we would advise requesting those reports individually first and then pressing the Update all reports button.

Let us know

Any feedback on the process would be greatly appreciated. Do let us know at support if you have any questions.

Happy reporting!

Data Updates in Local Insight

Happy 2018! With this new year comes brand new indicators, along with a number of updated indicators too.

New metadata calculations

At Local Insight we’re continually developing our product, and we rely on input from our users. Some feedback we received from you was that you’d like to see more detailed metadata. Well, we’re pleased to say that we have updated our metadata structure so you can now see more clarity on the calculations used to derive the indicators.

For example, take the dataset ‘Unemployment benefit’. Previously you would have seen the description:

Shows the proportion of people receiving Jobseekers Allowance (JSA). JSA is payable to people under pensionable age who are out of work and available for, and actively seeking, work of at least 40 hours a week. Universal Credit data is not currently included in the counts.

We now have extra text to show the calculation, which in this case is:

Rate calculated as = (Jobseekers Allowance claimants (monthly))/(Population aged 16-64)*100

To see an indicator’s metadata, once the dataset is overlaid on the map click ‘info’ and then ‘about the indicator’. For more details see our help article, here.

New datasets

We’re always looking for new datasets to add into Local Insight that can support you in better understanding your communities. This month we’re very excited to bring you several new datasets!

Sport England have provided us with 3, courtesy of their Small Area Estimates survey:

  • People physically active (at least 150 minutes per week in the past month)
  • People not physically active (less than 30 mins activity in the past month)
  • Participation in physical activity at least twice in the last month

This is modelled, local level (MSOA) data that helps Local Authorities understand the diversity of participation in sport and other activities in their local area. Have a look at their overview of the survey and more information about the data modelling process, here.

We’ve also included some very interesting data on personal debt:

  • Mortgage debt per household
  • Personal debt (unsecured loans) per person aged 18+

This data is from UK Finance, who publish detailed figures for loan balances by postcode sector across mortgages, unsecured personal loans and SME loans. (We haven’t included SME data for now – but please let us know if this would be a useful addition!). In order to add personal debt to Local Insight, we have modelled the data to Output Areas, using apportioning based on population for personal debt data and number of households for mortgage debt data. For more information about how you might want to use these datasets, take a look at our blog post, here.

To add these new datasets to Local Insight, head to ‘group admin’, ‘manage indicators’ and then ‘unassigned’ to drag and drop the indicator into a theme. (If you have not customised your themes yet, click ‘start managing your indicators’, then head to unassigned). For more detail, see our knowledge base article on how to do this, here.

Data updates

There are also a number of regular datasets that have been updated in Local Insight:

  • Children and young people in out-of-work families (includes families claiming Universal Credit)
  • All crime datasets (we now use 12 month rolling average for maps and the dashboard as well the reports)

Updates to the monthly Department for Work and Pensions (DWP) data

The monthly data on unemployment from the DWP is being published a little later than usual this month. It will be published by the DWP early next week, we will then update it in Local Insight. This updated data will be live by the end of w/c 22nd January.

The reports will also reflect the above data updates by the end of w/c 22nd January.

Update (26/01/2018) The monthly data on unemployment from the DWP is now updated in Local Insight on the maps and reports.

Current indicators available within Local Insight

Current indicators available within Local Insight. To see a list of all of the current indicators available in Community Insight and also a list of the most recent round of updates check out this Knowledge Base article.

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

Christmas holiday

Office closure

 

Image credit: https://www.pexels.com/photo/cold-snow-holiday-winter-40541/

Image credit: https://www.pexels.com/photo/cold-snow-holiday-winter-40541/

 

We hope you have a lovely break over the festive period! This is just to let you know that OCSI will be closed Thursday 21st December – Wednesday 2nd January. We will not be able to respond to support requests during this time. We will answer any support requests when the office re-opens on Wednesday 3rd January.

As another year draws to a close, we would like to thank you for your continued support and interest in Local Insight. We are looking forward to what 2018 will bring!

 

Data updates in Local Insight

Monthly data updates

This month we have a number of updates from Land Registry, Police UK, Department for Work and Pensions and Ofcom, as well as updating the reports. Indicators included are:

  • Average house price, broken down by house type
  • Number of property transactions, broken down by house type
  • Incidents of crime, broken down by offence type
  • Recipients of unemployment benefit, broken down by age, time period and gender
  • Broadband speed

Please note: The ‘Low broadband speed’ indicators differ slightly from the old indicator it replaces. The new indicators give a % of broadband connections that have speeds < 2Mbits/s. The old indicator gave a proportion of postcodes with slow internet.

Greenspaces data in Local Insight

We have also added two Greenspaces datasets this month: Greenspace coverage, total (this show the percentage of an area that is covered by green space) and Greenspace coverage, public parks and gardens (this shows the percentage of an area that is covered by public parks and gardens). For more information on use cases and how the data was put together see our blog postor for more information on how to view the data in Local Insight and what’s included in the data, see our blog post here.

Current indicators available within Local Insight

To see a list of all of the current indicators available in Local Insight and also a list of the most recent round of updates check out this Knowledge Base article.

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