VIDEO: Using SIMD Data to Showcase Startup Performance in Deprivation Areas

Last Updated: Thursday, December 14, 2017 by Fraser Campbell

Executive Summary

See how easy it is to link SIMD data for understanding startups in deprivation areas:
  -> combining your efforts and results with deprivation (by location) data   -> use it in showcasing and charting startups as they relate to deprived areas
  -> employ different charts to analyse performance  Approx. Skim Time: 1min 30sec ~ 220 words Full Read Time: 4min 30sec ~ 1280 words

 

What is SIMD Data and Why Does it Matter?

The Scottish Index of Multiple Deprivations (SIMD) is one of the key "Big Data" repositories of the Scottish Government for relating efforts and outcomes to those living in areas of deprivation, generally at a postcode level.

Whether you're seeking to establish where you are making efforts, or showcasing the results of your efforts, by mapping your data against SIMD data, you'll be able to understand your programme effectiveness in reaching your population areas experiencing the highest levels of deprivation and share it with your key stakeholders clearly, whether they're the general public, economic development programme management, local authority, central government or beyond.

Link your data to SIMD data to boost relevance and draw meaningful conclusions on programme efforts and outcomes.


SIMD Details - Pick The Scale That Suits Your Needs for Understanding Startups in Deprivation Areas

Depending on how it's used, SIMD data groups households together who are in close proximity into zones, then scores those zones based on a number of socio-economic factors.  The scoring system can vary, based on how granular the results are which you're trying to achieve.

  • quintiles - there are 5 possible scores, with the total 100% population broken down into 20% segments each
  • deciles - there are 10 possible scores, broken down into 10% segments each
  • vigintiles - there are 20 possible scores, broken down into 5% segments each
  • percentiles - there are 100 possible scores, broken down into 1% segments each
  • SIMD rank - there are 6505 possible scores, broken down into .0015% segments each

Below is a vigintile graph showing the distribution of deprivation across 20 segments for our fictitious data, the local authority of Halcyon.  It illustrates the count of startups which are located within all areas of the authority, with special attention given to those in the 3 hardest hit areas.

Please note that throughout this document, we'll be using vigintiles exclusively from here on out. 

The bottom 3 areas represent the 15% of postal codes considered highest deprivation.

vigintile column chart of deprivation scores

Choose your scale, depending on need, and use SIMD vigintiles to find the deprivation areas most in need of attention.

 

How to Link to SIMD Data?

Start with your existing data on efforts, outcomes and performance results, such as:

  • event attendees by postcode (use their demographics, geolocation and business status, in particular)
  • expert help recipients by postcode (again using their geographic location, business status, boosted revenue and jobs created)
  • grand and loan recipients by postcode (similar data as per above)

By looking up the deprivation status for each of these instances, deprivation scoring or a yes/no indicator, can be supplemented onto tabular data.

Start with basic data about the company and owner, including location data.

basic spreadsheet

 

Link to, or supplement, basic data with SIMD data using postal code lookup.

basic spreadsheet with deprivation data

 

Link your data with SIMD to boost relevance and enable analysis of programmes targeting deprivation areas.


Find Your Baseline Percentage of Startups in Deprivation Areas

Pie charts aren't great for many occasions, but when you're wanting to know the relationship between segments and the whole, such as between startups inside vs outside of deprivation areas, pie charts are ideal.

  • quickly see the count of startups inside and outside of deprivation areas 
  • create a benchmark reference for what % of startups are inside vs outside deprivation areas
See the # and % of startups inside and outside of deprivation areas.

pie chart showing startups in deprivation

Use a pie chart to easily compare startups from inside deprivation areas as compared to those outside.

 

Monitor Performance Over Time

Now that we've established our baseline expectations, the next step is to track performance over time, to see how many new startups have happened in our target areas.

  • see the trend for all startups over time
  • group by quarter to make trend-spotting easier
See startups in deprivation areas over time.

line chart showing startups in deprivation over time

Use a line chart to easily track startups in deprivation areas, and group by quarter to quickly spot the trend.

 

Monitor Your Performance vs All Startups Over Time

Spotting the trend is helpful, but sometimes we need to know how we're doing in deprivation areas, as compared to all our startups.  This is good to find movements which reflect the effect of events we've put on, or advertising campaigns, to attract startups in these areas.

  • see the trend for all startups over time
  • quickly compare all startups with just those startups in deprivation areas
See startups as a whole vs deprivation area starts.

area chart showing startups in deprivation over time

Use an area chart to easily track, over time, startups from inside deprivation areas as compared to all new starts.

Compare Number of Starts with Target Areas

At a glance, we're able to spot several relationships, or lack thereof, between our raw # of starts and our % of starts in deprived areas, such as:

  • see the relationship between # and %
  • find out if recent efforts are increasing our deprivation area starts
  • determine areas needing more investigation (by clicking into the dashboard charts) for more facts
See #'s vs %'s to find relationships and anomalies.

area chart showing number versus percentage

Use an area chart plus line to easily track, over time, the count vs percentage behaviour.

 
Are We Doing Better Than Last Year?

By using a year-on-year comparison chart (two areas graphed together), we can stay abreast of our performance compared to previous periods, such as the year prior.

  • see the progress to date this year, as compared to the previous year
  • identify whether we're on track to beat the year prior
Compare this year with last to see how well the deprivation areas are responding to ads and PR.

area chart showing this year vs prior

Use a year-to-date area chart to quickly compare historical and spot improvements.

 

Get a Breakdown of Where Our Startups are Starting Up (Ward Area)

A donut chart can be a useful way of getting the segment vs segment comparison of where our startups are located.

  • compare the startup # or % breakdown, when only a few are present
  • see what wards have the deprivation starts
Find out which wards have the most deprivation area starts.

donut chart showing starts by ward

Use a donut chart to showcase geographic distribution of deprivation starts.


Conclusion and Takeaways

Linking to SIMD data, and using it to explore performance in deprivation areas, is a great way to expand your capabilities with a minimum of effort.

1. Link, or import, SIMD data, based on startup postal code.

2. Create baselines to set expectations for deprivation area as a % of the whole.
3. Plot the historical trend, using quarterly grouping, to determine if tracking to improvement. 
4. Compare deprivation area # of starts vs all starts for segment relative performance.
5. Examine % vs # to spot anomalous behaviour.
6. Use cumulative year-to-date vs prior to know if we're improving.
7. Link to ward / geospatial data and find concentrations of deprivation area starts.  

 

Consider dashboard data management software for always up-to-date visualisations to save time spent in Excel each month, improve effectiveness and reduce re-keying errors.


See the Target Dashboard Tailored Solution for Economic Development in a Guided 20 Minute Demonstration

banner
See It In Action
Find out how easy it is to manage your Economic Development with Target Dashboard software. Improve your efficiency and effectiveness, today.