SEEK: How Codex empowered SEEK to generate custom market insight reports in hours, not weeks

  1. Home
  2. /
  3. SEEK: How Codex empowered SEEK to generate custom market insight...

Services provided

  • Discovery
  • UX/UI Design
  • Web App Development
  • Reporting & Data Visualisation

Key stats

  • Custom Development using R
  • 5500+ bespoke lines of code
  • 70+ bespoke files
  • 19 data models
  • 61 chart types

Engagement length

5 months

Client Background

Launched in 1998, SEEK is a market leader in online employment marketplaces, operating internationally with a large presence in the Asia Pacific region and Latin America. SEEK employs more than 3,000 people across the globe, and has exposure to 900 million jobseekers.

SEEK operates a range of subsidiaries, including SEEK Learning and SEEK Volunteer, and has stakes in other popular online employment marketplaces.
In addition to their investment in upcoming technologies, including artificial intelligence, SEEK operates a Growth Fund that invests in early stage businesses in the online education, HR SaaS and contingent labour industries.

Problem Overview

The Market Data & Customer Analytics (MDCA) team at SEEK are responsible for producing labour market insights and reports for external use by a variety of organisations, including hiring companies and government departments. These reports consist primarily of SEEK’s first-party data, and are usually distributed as PowerPoint presentations or PDF decks.

Producing these reports with insights at any level of granularity below standard dimensions (such as a role title, or group of role titles) was a ‘high touch’ bespoke exercise undertaken by a data analyst at SEEK. The process of generating a report could take up to six weeks, depending on the amount of data or complexity of reporting required.

Data analysts needed to manually extract data from databases using complex SQL queries, format and manipulate the outputs into usable structures in Microsoft Excel, and then generate charts using a collection of manually coded R visuals.

Although the outputs were high quality, the reach was limited due to the long production time and skilled expertise required to compile a report.

SEEK contracted Codex to develop a solution to streamline their processes and empower the MDCA team to produce high quality reports faster and more efficiently.

Phase 1: Discovery

Nicknamed ‘Project Hercules’, after the versatile and reliable Lockheed C-130 Hercules aircraft, the team at Codex began the engagement with a series of Discovery workshops.

Initial kick-off meetings with key stakeholders from the MDCA team allowed Codex to establish the functional and non-functional project requirements, with SEEK clearly articulating their must-haves. The overarching requirements for Hercules were that:

The reports must be exported directly into PowerPoint, to allow non-technical staff members to make changes and insert additional slides.
The graphs and charts needed to be client-ready – using the SEEK fonts, colours and standard terminology.
The data needed to be able to be filtered and customised. This included parameters like geographies, time periods and role groups.
The chosen solution should leverage SEEK’s existing technology stack, and not be a ‘black box’ with complex dependencies that are difficult to evolve.

The MDCA team at SEEK were familiar with Tableau, Power BI, Google Data Studio, and the programming language, ‘R’. With this in mind, Codex conducted a thorough investigation into available solutions, both custom and off-the-shelf.

Google Data Studio Logo
Power BI Logo
Tableau Logo
R Shiny Logo

The comparison involved evaluating each platform against the detailed functional and non-functional requirements, and scoring them accordingly. Aspects that were investigated included:

  • The preferred data model the systems operated in.
  • How scalable, efficient and easily maintainable they were.
  • The ability to further customise the platform through custom development.
  • Whether there was API support.
  • What environment it ran in, and whether the solution was easily shared.
  • The ability to have a nicely designed, custom user experience and interface.
  • The time required to develop, implement and train the SEEK team.
The results of the comparison identified Tableau and R Shiny as the top contenders, with the majority of the criteria being fulfilled as out-of-the-box functionality, or possible with custom development. Codex presented the findings and recommendations to SEEK, who requested that a deeper discovery be undertaken on the two viable solutions to determine which would be the most appropriate.

Phase 2 & 3: Design & Development

This deeper dive involved building a lightweight version of the Tableau reports (with a custom PowerPoint export and format script) and a lightweight R Shiny interface. Regular weekly stand-ups and fortnightly showcases allowed SEEK to provide timely feedback to Codex, which meant that both demonstrated solutions effectively met the needs of the MDCA team. The source files and custom code were delivered to SEEK to review, and the decision was made that the available customisation, flexibility, and functionality offered by the R Shiny web application was the most suitable for their needs.

With approval to proceed with the development of the R Shiny application, the Digital Experience team at Codex were brought into the project to design a custom user interface that functional, easy to use, and on-brand. Close collaboration between the Design and Data teams at Codex and the MDCA team at SEEK meant that the final production-ready solution was successfully delivered in 3 months.

The responsive web application now empowers Data Analysts at SEEK to:

Dynamically retrieve and filter data, with close to real-time visual outputs.
Build specialised data cohorts using an easy step-by-step process, that allows them to define related groups by classifications, subclassifications, role titles and geographic locations.
Define comparison periods based on custom date ranges.
Save, export and import data sets for future use.
Export visuals directly into SEEK branded PowerPoint templates, with the ability to customise content, including chart headings, axis, and page layout.

With each report now completed within a matter of hours, not weeks.

Exciting discussions about the next iteration of Project Hercules have already begun, with the opportunity to open the web app up to the rest of the business for custom reports next on the list.

19

Data Models

 

61

Chart Templates

 

120+

Charts per Report

Significant time & cost savings

Reports generated in minutes, not weeks

On-brand reports

Consistent designs direct into PowerPoint.

Future-proofed platform

Using a codebase that the MDCA team can develop on.

Improved team capacity & employee experience

The Key Takeaways When Building a Custom Web-based Reporting Platform

Project Hercules was delivered in 5 months with minimal issues or delays. Here are our three key takeaways from this project:

Deeper mini-discoveries at the beginning pay dividends

More often than not, teams jump straight to ‘solution mode’, implementing quick fixes based on current needs, without factoring in long-term business requirements. This frequently leads to systems that require significant amounts of ongoing maintenance, ultimately increasing costs and decreasing effectiveness.

Although SEEK had a preference for an existing skill set with R Shiny, they diligently engaged Codex for an unbiased external opinion, before deciding on a solution architecture. The results of our Discovery revealed two key platforms that could address the MDCA team’s needs now and in the future. SEEK’s decision to extend and engage in two ‘mini discoveries’ for both Tableau and R Shiny allowed them to see the powerful potential both solutions had to offer, and make an informed decision, minimising their risk.

Problems often appear larger prior to unpacking them in Discovery

Data problems can sometimes appear insurmountable upfront, especially when it’s an ongoing concern that impacts your daily work. Engaging a third party, like Codex, to conduct a comprehensive Discovery enables a fresh set of eyes to break down the problems into smaller, more manageable pieces without any bias. This also empowers organisations, like SEEK, to prioritise their needs and make decisions accordingly.

Reliable collaboration ensures a seamless transition from Discovery to Design and Development

One of the key drivers in Project Hercules success is what we like to call, ‘Reliable Collaboration’. As illustrated in the case study above, we don’t take a client’s brief, walk away, and come back with a solution after a few weeks. On Project Hercules, SEEK were actively engaged throughout the entire Discovery process, courtesy of regular stand-ups and end-of-sprint showcases, which allowed us to clearly define the requirements and functionality that led to the detailed investigation, recommendation and implementation of their R Shiny application.