Powerful insights driving growth for global brands

Robust, scalable data pipelines with AWS infrastructure

26 August 2022 | Dev

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

recruitment software product

Success Story

Getting the job done

Technology | Recruitment, Software

Our client were looking to upgrade their existing software which was windows based and presented multiple limitations. They required expert skills to design and deliver software which would make the subscription-based software easier to deliver to end customer with improved features and functionality. [...]

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

Keeping data consistent with operational monitoring and support

Success Story

Making data science efficient

Market Research | Entertainment, Broadcasting

Our client required high data availability with no delays therefore, they needed to ensure that their data pipeline consisting of various sources were continuously and consistently running without errors. [...]

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

automate information security

Success Story

Protecting content for the biggest names in entertainment

Market Research | Entertainment

Our client were looking to automate their content security process for a service they offered end-clients. The company's existing process was time consuming and was prone to human error, therefore they required an intelligent, automated solution that Ardent delivered. [...]

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

Ardent Insights

Data Warehousing Architecture: Azure SQL vs Redshift

Data Warehousing Architecture: Azure SQL vs Redshift

There are quite a few different data warehouse technologies to choose from, and knowing where to start, what to look for, and what data warehouse service is going to be best for your business is key. Deciding on a data warehousing technology that is suitable to your business needs, goals and objective is essential as [...]

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

Data Warehouse vs Database: The key differences

Data Warehouse vs Database: The key differences

Cloud technology and advances in hybrid-storage technologies have meant that data storage is no longer left entirely to internal equipment and a single company-owned server. Finding a database management solution that works with the size and scale of your needs is not a task to be overlooked. [...]

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

Building data pipelines – a starting guide

Building data pipelines – a starting guide

Data visibility can be a huge driving factor for organisation growth. Poor data visibility can lead to a lack of compliance with data security, difficulty in understanding business performance and increased complexity in dealing with system performance issues. Developing secure, robust and scalable data pipelines can empower businesses to gain data visibility by connecting the [...]

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