Powerful insights driving growth for global brands

Robust, scalable data pipelines with AWS infrastructure

26 August 2022 | Noor Khan

Robust, scalable data pipelines with AWS infrastructure

Key Challenges

Our client were looking to collate large amount data from various sources with high data accessibility and accuracy to provide a speedy turnaround time for their end customer.

Key Details

Service

Data Engineering

Technology

AWS - S3, Athena, CloudWatch, Cloudformation, Cloudfront, Managed Airflow, EMR, Batch, SNS, EC2, Bitbucket (Version Control), Airflow

Industry

Market Research

Sector

Entertainment, Media

Key results

  • High accessibility of data
  • Robust pipeline infrastructure
  • Speedy processing of large volumes of data
  • Expert technology recommendations

Well-established market research company

Our client are a well-established market research company offering a number of services including market research insights on tv audience data. The company has been providing data to end customers to help them make well-informed decisions on marketing, business strategy and approaching their target audience. With almost 35 years of experience, they look to expand and grow their services and we are proud to help them on their journey to achieve that.

Robust, scalable data pipelines - Powerful insights driving growth for global brands

Collecting, processing and enriching a variety of data

We have worked with our client on a number of data projects, so when they needed robust, scalable pipelines built to deal with large volumes of data, Ardent was the data engineering provider of choice. Our client wanted to ingest data from several sources, collate it and enrich it for their data science teams to generate deeper insights that inform smarter decisions for their end customers.

Robust, scalable pipelines

Our engineers with their rich experience and expertise in delivering data engineering excellence for over a decade built robust, scalable data pipelines to deal with the large volumes of data being ingested. We built the data pipeline infrastructure to collate data from three main sources including; TV data from a leading provider of automatic content recognition (ACR) technologies and cross-screen metrics, mobile data from a global leader in mobile location data, POI data and corresponding compliance services as well as pixel data. Each source of data provides the data in various formats, which was cleansed, processed, validated and enriched by joining tables based on set queries with intelligent algorithms. This provides the client with a fuller picture of their data. 

Robust, scalable data pipelines - Powerful insights driving growth for global brands

One of the key technical challenges that our team overcame was dealing with large volumes of mobile data which varied between 100 GB to 300 GB per day. This data needed to be processed swiftly, therefore our teams were able to recommend and employ EMR (Elastic MapReduce) to significantly reduce the processing time so our client could access the data quickly.

Robust, scalable data pipelines - Powerful insights driving growth for global brands

High data accessibility and data accuracy  

Our client can access hourly reports based on their data, which is processed quickly and efficiently. This allows their data science teams to provide quick turnaround to their end client on data reports and insights, empowering them to provide excellent service to their clients. We continue to work with our client on managing their data pipelines with our operational monitoring and support service. Read the full success story on how we enable them to avoid data delays and data gaps.

If you are looking to create data pipelines or have existing data pipelines which require maintenance, need updating or better infrastructure, or are looking to build data secure, scalable and robust data pipelines then get in touch to find out how we can help.


More Success Stories

Automating data collection with OCR technology (1)

Success Story

Automating data collection with OCR technology

Market Research | Retail

Accelerating market research by automating data collection with OCR technology. [...]

Read More... from Powerful insights driving growth for global brands

Ensuring timely data availability for real time mission critical data

Success Story

Monetizing broadcasting data

Media | Media

A market leader, internationally renowned media and broadcasting company Founded in 2002, our client has been around for over two decades and is an internationally known company dealing with broadcasting data for commercial use. With a mission of making high-quality technology and content affordable for everyone, they have established themselves as a market leader. [...]

Read More... from Powerful insights driving growth for global brands

Fine art storage & preservation software

Success Story

Making logistics simple

Logistics | Logistics, Software

Leader logistics software provider Our client is a leading logistics software provider in the UK. With over 3 decades of experience in the industry, they continuously look to innovate with technology. Their range of software products includes a warehouse management system and removal management software. They aim to remove the complexity of software and bring [...]

Read More... from Powerful insights driving growth for global brands

Ardent Insights

Overcoming Data Administration Challenges, and Strategies for Effective Data Management

Businesses face significant challenges to continuously manage and optimise their databases, extract valuable information from them, and then to share and report the insights gained from ongoing analysis of the data. As data continues to grow exponentially, they must address key issues to unlock the full potential of their data asset across the whole business. [...]

Read More... from Powerful insights driving growth for global brands

Are you considering AI adoption? We summarise our learnings, do’s and don’ts from our engagements with leading clients.

How Ardent can help you prepare your data for AI success Data is at the core of any business striving to adopt AI. It has become the lifeblood of enterprises, powering insights and innovations that drive better decision making and competitive advantages. As the amount of data generated proliferates across many sectors, the allure of [...]

Read More... from Powerful insights driving growth for global brands

Why the Market Research sector is taking note of Databricks Data Lakehouse.

Overcoming Market Research Challenges For Market Research agencies, Organisations and Brands exploring insights across markets and customers, the traditional research model of bidding for a blend of large-scale qualitative and quantitative data collection processes is losing appeal to a more value-driven, granular, real-time targeted approach to understanding consumer behaviour, more regular insights engagement and more [...]

Read More... from Powerful insights driving growth for global brands