No-Code Continuum Project Hack:11 Submission

The Continuum team recently took on the challenge of the Project Hack:11 Hackathon which was hosted last Thursday and Friday both in-person in London and virtually.

The mission was to get all the best thinkers in the world of data and analytics together to see if any ingenious solutions can be devised for a variety of different challenges provided by the event’s sponsors.

We elected to tackle a challenge for the NHS project professionals team, they wanted to understand the composition of their workforce and see if certain diversity groups are being under or overrepresented.

MASTERFLOW.png

Over the course of two days, we were provided with Excel exports which illustrated to us the composition of this workforce by a variety of different data points, such as their Gender, Sexual Orientation, Ethnicity, and Disability Status.

Naturally, we took straight to Alteryx Designer to read this data in, prepare it, and cleanse in no time, ready for analysis!

Once this was done, we enhanced this with online data from NHS Trust’s and UK's Office of National Statistics datasets based on Ethnicity and Diversity. We discovered the same diversity split both NHS-wide and across the entire UK.

Once all this supplementary data was joined up it was just a matter of a few clicks to get this output into a beautiful Power BI dashboard to allow the data to be easily represented and understood.

Here are a couple of examples…

Ethnicity.png
Biological Sex.png

In as little as a day the team was able to produce a re-runnable application to show the split of diversity across the NHS project team - now that's fast!

Naturally, we wanted to take this analysis one step further for them and we decided to uncover the number of NHS job postings by UK region back from 2016 and forecast the job vacancy demand in the future.

We then enriched this dataset for the same year and region with the population, average age, hospital locations, and the number of Covid deaths since 2019.

Using a great specialist time series forecasting tool named TIM from our friends at Tangent Works, configuring these predictions only took a few clicks.

TIM, or Tangent Information Modeler, is an automatic predictive model building engine that automates the forecasting process by analysing time series data and generating accurate models based on the patterns it detects - very accurate, and super easy to use!

What was the result? Take a look at our submission video here…

Winners are announced on 20th October - fingers crossed!

Previous
Previous

Join McLaren and Mindy Kaling at the next virtual Alteryx event

Next
Next

Data Competency: Should we Have Better Skills or Better Systems?