Data Visualisation for Social Research and Business Intelligence

Testimonial:

“It’s been a pleasure working on this project with Colin. Colin was able to quickly grasp the characteristics of our target audience, and adapt tone, style and content to fit both OCSI’s organisational brand as well as the needs of the audience.

Throughout, Colin has been an excellent communicator, diligent with the quality of work and bringing additional value to the work that we do.

I wouldn’t hesitate to collaborate with Colin again.”

Kimberley Anscombe, Marketing and Communications Manager.

Client:

  • Oxford Consultants for Social Inclusion (OCSI)

Brief:

  • To raise awareness with a target customer audience about OCSI’s Local community intelligence tool (Local Insight) through promoting data visualisation of small area housing affordability data

Requirements:

  • To raise awareness of Local Insight as a source of small area data on housing affordability issues
  • To promote the benefits of small area data for supporting evidence based decision making to business intelligence practitioners
  • To promote the benefits of using the right data, tools and techniques as an innovative solution to meet demand for insight now and in the future
  • To raise awareness of the benefits of data visualisation to engage the policy making audience and promote the value of research and intelligence

Solution:

  • Small area data on the affordability gaps of entry level and averagely priced housing were analysed in data visualisation software
  • Creating bespoke data visualisations of small area data about the housing affordability gap for both entry level and averagely priced housing within England and Wales
  • Writing a 2-part blog post promoting the benefits of visualising small area data to help balance demand for insights and raise awareness of the value of research
  • The blog post and visualisations were targeted at Business Intelligence practitioners through direct emails and online social media campaigns

Outcomes:

  • Increased awareness of the Local Community Intelligence Tool amongst the Public-Sector Business Intelligence community as demonstrated by 2 requests for demos following the mailout.
  • Insights into housing affordability issues both at the national and local level
  • Raised awareness of the benefits of the right data, tools and techniques to provide quick and accurate insights to help balance the demand for insights now and in the future as demonstrated by 160 views of the blog within the first 3 days.
  • Raised awareness of how data visualisation can help engage the policy making audience to promote the value of research and intelligence.

The first data visualisation focusses upon entry level housing and is available on Tableau Public.

Entry Level Housing Affordability Dashboard 250917

The first part of the blog, can be found on the OCSI Website.

Colin was great to work with.  He provided a very personalised and flexible approach, giving us options to suit our needs and our budget.  Throughout the project, Colin kept in close contact and checked with us regarding key elements of the analysis to make sure the outputs provided the intelligence we needed to support decision making.  Everything was delivered on time and I found Colin very easy to work with.…Beverley Wilson (Insight and Intelligence Manager, Cheshire West and Chester Council“

Client:

  • Cheshire West and Chester Council (CWAC)

Brief:

  • To analyse the responses to a flexible mobile working staff survey and present the results back an operational steering group.

Requirements:

  • CWAC were keen to understand the perceptions of staff in relation to a new flexible and mobile working policy.
  • They had undertaken an online questionnaire emailed to all office staff – with an overall response of 1,108 employees. Themed staff workshops were held in key office locations.  Themes included; ‘travel’, ‘caring responsibilities’, ‘IT and technology’ and ‘Flexible and Mobile.’
  • Datawoj worked with the client to analyse the results of the survey and present back key findings to an operational steering group.

Solution:

  • Analysis of headline quantitative survey results including measures of; staff working patterns, staff priorities, as well as a respondent profile.
  • Summary presentation of qualitative survey results including measures of; benefits, opportunities and issues identified for flexible mobile working.
  • Subgroup analysis of headline survey results by location and service area.
  • Production of a presentation, which brought both quantitative and qualitative survey results together for an operational steering group consisting of Change Team, Human Resources, Research and Communications managers.

Outcomes:

  • Additional analytical capacity freed up the Research team to work on other projects at a time of organisational change.
  • Enhanced understanding of staff perceptions about flexible and mobile working including; priorities, issues and opportunities by both service area and location.
  • Quick delivery of accurate insights on staff perceptions of flexible and mobile working based upon data visualisation techniques.
  • Operational decision making based upon a robust evidence base.