Loading...
Home 2017-04-04T13:47:51+00:00

SERVICES

We create solutions that allow our clients to manipulate and visualise their data. This enables them to gain valuable insights from it as well as tell compelling stories and have an impact.

How we do it

We work closely with you to understand the key messages you want to get across. We then present you with different designs & story boards to help you clarify your message, before cleaning and manipulating your data ensuring that it is in a peak state to support your data visualisation.

Got some data but don’t know how to get the best out of it ?

Let’s talk

CASE STUDY

“The new system has allowed me to spend more time engaging with clients and grow the business. “

Tania Gauder, Project Support Officer

Background

The Training Effect (TTE) runs the ‘Risk avert’ project, which surveys many schools each year and identifies pupils who are vulnerable to multiple risk-taking behaviours. TTE presents the survey analysis in reports to schools and local commissioners.

Before this project, however, TTE’s processes for scoring surveys and producing reports were laborious and prone to human error. Datachronicle therefore developed and implemented automated survey scoring and report generation, and an internal data dashboard for tracking key performance indicators.

The project reduced the time TTE spent creating reports by 30%, allowing staff more time to focus on growing the business.

How Datachronicle helped

TTE has been using Google Forms for delivering its surveys. In order to aid automation and promote simplicity, Datachronicle decided to create a solution using entirely Google products, which included Google Forms, Google Sheets, Google Slides and Google Data Studio.

We used Google Sheets to create a process that automatically scored and colour-coded the survey responses once the sheet was attached to a Google survey form. This not only eliminated the need for staff to manually run a scoring process, but also meant summary tables and charts that are essential to the reports were created automatically.

We also created a self- contained process for generating reports automatically. These reports pull information from the included survey data. All staff now need to do is save the report as a PDF file and email it to clients. This eliminated the need to construct the report in MS Word.

Collating and aggregating all their survey data had been an arduous task for TTE, but Datachronicle simplified the process using a data management tool called Talend.

The final project deliverable was an interactive data dashboard for key performance indicators which Datachronicle built using Google Data Studio. This allowed TTE to have a macro view of all their survey data and to interact with or filter the data easily for an enhanced data analysis experience.

The Training Effect uses Datachronicle to transform their data analysis and cut reporting times by 30 percent

Client

Founded in 2011, TTE provides services to the UK public sector. It specialises in the development of school-based programmes, consultation projects and surveys that improve the understanding of child and adolescent health and experiences..

The challenge

TTE scored its ‘Risk avert’ surveys manually using an Excel macro and TTE’s proprietary scoring system. The process was difficult as the macro completed only a small part of the scoring process. Staff found working with their survey data even more challenging when they needed to combine it all to look for correlations, spot trends, etc.

This data analysis is critical to TTE as it shares its findings with local commissioners. Each year, TTE creates about 100 reports for 50 schools and these numbers is growing. The reports combine summary tables, charts and explanatory text in an easy to understand format.

The report creation process was, however, also laborious, time-consuming and prone to human error. It required staff to use a combination of Excel, Word and PowerPoint, going back and forth between applications and updating data in one to reflect changes in the other. Sometimes the charts in PowerPoint would crash or show erroneous data and the process would have to start all over again.

“Datachronicle have great knowledge of data presentation and were really interested in the service we provided.”

Aaron Bowes, Project Support Officer

Results, return on investment and future plans

TTE gathers a lot of data, far more than its competitors. Using the new system frees up more time for staff to draw insights from their data and respond to client queries. The improved data insights have allowed staff to improve their relationships with schools as well as improve their service offerings to new prospects early on in the selling cycle.

Staff reported a reduction in the time taken to complete each report. The old process required two members of staff, but now just one can run the whole process. On average, each survey report used to take about 120 minutes to complete. The average completion time is now 84 minutes.

That’s a 30% reduction in the time needed. It means TTE has effectively gained an extra day each month for staff to concentrate on growing the business!

Have a data story to tell but don’t know how to do this ?

DROP US A LINE

ABOUT

Communicating data effectively

We are an analytics and data visualisation consultancy. We help clients better understand and tell stories with their data. This takes many forms and processes including :

  • Analysing their data by peeling back its layers and selecting only vital information

  • Cleaning and reformatting it to improve quality and usability

  • Combining charts, and text to tell highlight key messages and increase their impact

Our mission is to help our clients tell better stories with their data to support their business, research or articles.

‘We decided to work with Datachronicle due to the professionalism and enthusiasm shown by Soti from our first meeting. Soti not only quickly understood our project, he suggested real world solutions that worked with our current software systems.

This was hugely important to us as it ensured that changes to our existing processes were kept to a minimum.  As a result,  the time needed  for staff training on the new system was minimised.

The impact of Soti’s work has significantly improved the quality of the reports  and data visualisations we send to our clients as well as  created genuine cost savings across the organisation.

We will certainly be working with Datachronicle again on several additional projects and as such would not hesitate to recommend them to others.’

Mark Bowles, The Training Effect

“We approached DataChronicle because we needed to give our students a good understanding of the way data visualisation is being used by organisations to support business making decisions.

 

Soti helped us by running a training session focused on understanding and developing data visualisation techniques for our level 3 and level 4 students.

 

He also worked with our technology apprentices to develop skills which they then used in placements to support professional data analysis. 

 

We were impressed by his professionalism and ability to explain complex topics in a clear and understandable way.  This allowed those he had worked with to apply what they had learnt to real world situations.

 

We would recommend DataChronicle to any organisation that needs to interpret and analyse information to gain practical results. “

Joseph Hanke, Nescot College

CONTACT

Follow DATACHRONICLE On Social Media

BLOG

Writings about data visualisation

Load More Posts

Datachronicle HQ

27 Old Gloucester Street
London
WC1N 3AX

Phone: +44 (0) 7756099116
Email: hello@datachronicle.co.uk
Web: www.datachronicle.co.uk