Fendix Media: Cloud Native Data Warehouse Delivers Cutting Edge Advertising Insights to the NHS

Fendix Media: Cloud Native Data Warehouse Delivers Cutting Edge Advertising Insights to the NHS

Fendix Media: Cloud Native Data Warehouse Delivers Cutting Edge Advertising Insights to the NHS

Challenge

Fendix Media, a digital media agency pride themselves with offering unrivalled digital access to the NHS, assisting trusts with
direct revenue generation through the placement of targeted adverts across the NHS intranet. Over the last couple of years,
Fendix Media have grown rapidly, and now offer digital media products to almost every major NHS trust in the UK. This
offers potential customers access to an enormous, yet well segmented market of almost 1.5 million UK employees.

As Fendix Media has grown, so to has it’s desire to increase the sophistication of its Ad placing strategies. This lead to a
requirement to centralise information about advert operations, sales, ad placement, clicks, click throughs as well as
information about end users. By centralising, analysing, and visualising this information, Fendix Media believe they will be
able to offer better targeting, pricing and placement strategies to their customers.

As is typical in a rapidly growing and evolving business environment, IT strategy struggled to keep up. This meant that data
was siloed in a large number of disparate and disconnected data sources. In order to improve their Ad Placement strategies,
all of this data needed to be connected in one central repository.

Colibri were approached to deliver a solution to this problem in the quickest and most cost effective fashion, leverage a
Cloud First, AWS native set of technologies.

Solution

After a set of initial workshops with key stakeholders and data owners we were able to craft the design for a cutting edge
integration layer, leveraging the very latest cloud native technologies including AWS Glue and Redshift. Having pitched the
solution delivery to Fendix Media’s IT and Business leadership we were given the green light to build the new integration
suite, data warehouse, and business intelligence layers.

In just six short weeks Colibri Digital was able to integrate ten different, completely disconnected, geographically dispersed
data sources into a centralised data warehouse and apply a business intelligence visualization layer on top.

Results

The delivery of a state of the art data warehouse and business intelligence suite allows Fendix Media’s sales and Ad Ops
teams to perform self-service analysis of ad performance and placement strategies in real time. Fendix Media are now able
to accurately forecast the performance and cost of different Ad placement strategies using the cutting edge analytics layer
delivered by Colibri Digital.

As an additional bonus, the sales team can now share real time dashboards with end customers illustrating the performance
of their Ad campaigns. Previously, a customer would have to telephone a sales representative who would then have to
request a manually generated report from an IT team.

By | 2019-07-15T15:23:13+00:00 June 27th, 2019|Categories: Case Studies|0 Comments

About the Author:

I love blogging about technology and working with the latest web technologies. Currently I work to help keep the Colibri Digital website and social media platforms in tip top shape.