Alteryx Case Studies Nielsen's Business Intelligence Revamp with Alteryx and AWS

Edit This Case Study Record

	Nielsen's Business Intelligence Revamp with Alteryx and AWS Alteryx

Nielsen's Business Intelligence Revamp with Alteryx and AWS

Alteryx

Technology Category	Networks & Connectivity - RFID Platform as a Service (PaaS) - Application Development Platforms
Applicable Industries	Equipment & Machinery Telecommunications
Applicable Functions	Quality Assurance
Use Cases	Time Sensitive Networking
Services	Cloud Planning, Design & Implementation Services System Integration
Challenge	Nielsen, a global leader in audience measurement, data, and analytics, faced a significant challenge in 2017. Their Business Intelligence (BI) process was disorganized, with many small, independent groups rather than clearly defined silos. The situation was further complicated by an aging BI solution that had been running silently in the background for nearly a decade. The subscription for this tool had ended years ago, and it was only a matter of time before it would shut off without warning. This system was unsustainable, and a solution was needed. The urgency of the situation was heightened when Nielsen's encoding verification solutions (EVS) department, which relies on next-day BI reports to track the encoding process and ensure correct broadcasting and encoding across all available markets, discovered that their reporting process was built on the very BI tool that was about to be turned off. They had less than 90 days to find a solution. Read More
About Customer	Nielsen is a pioneer in market research and a global leader in audience measurement, data, and analytics. The company is built on data insights and uses patented encoding technology across radio and television to enhance audience measurement. Nielsen's encoding verification solutions (EVS) department helps preserve, maintain, and document the accuracy of that encoding technology. One team in EVS focuses specifically on radio transmission across the United States. This team relies on next-day BI reports that track the encoding process and ensures that radio stations are broadcasting and encoding correctly across all available markets. Read More
Solution	Nielsen had already chosen AWS as its cloud infrastructure for its scalability and powerful computing engine. Wayne McClure, solution architect at Nielsen, saw an opportunity to find a self-service analytics tool that would integrate well with AWS while empowering business users across the organization to handle analytics. They chose Alteryx, a tool that would empower not only seasoned analysts but also business users to create a more inclusive use of their data. The team could house data in AWS, analyze the data in Designer, and schedule and automate workflows with Server, which Nielsen deployed on AWS. Users could also easily pop the data into Tableau for visualization. Utilizing Alteryx on the AWS platform, Wayne’s team was able to go into a rapid-fire testing process to get an end output. The team removed several redundant systems and cleaned up SQL queries. Using Alteryx, the team ended up with daily completed reports in a 4-minute process instead of 4 hours. Read More Log in to view content
Contents

Technology Category

Networks & Connectivity - RFID

Platform as a Service (PaaS) - Application Development Platforms

Applicable Industries

Equipment & Machinery

Telecommunications

Applicable Functions

Quality Assurance

Use Cases

Time Sensitive Networking

Services

Cloud Planning, Design & Implementation Services

System Integration

Challenge

Nielsen, a global leader in audience measurement, data, and analytics, faced a significant challenge in 2017. Their Business Intelligence (BI) process was disorganized, with many small, independent groups rather than clearly defined silos. The situation was further complicated by an aging BI solution that had been running silently in the background for nearly a decade. The subscription for this tool had ended years ago, and it was only a matter of time before it would shut off without warning. This system was unsustainable, and a solution was needed. The urgency of the situation was heightened when Nielsen's encoding verification solutions (EVS) department, which relies on next-day BI reports to track the encoding process and ensure correct broadcasting and encoding across all available markets, discovered that their reporting process was built on the very BI tool that was about to be turned off. They had less than 90 days to find a solution.

About Customer

Nielsen is a pioneer in market research and a global leader in audience measurement, data, and analytics. The company is built on data insights and uses patented encoding technology across radio and television to enhance audience measurement. Nielsen's encoding verification solutions (EVS) department helps preserve, maintain, and document the accuracy of that encoding technology. One team in EVS focuses specifically on radio transmission across the United States. This team relies on next-day BI reports that track the encoding process and ensures that radio stations are broadcasting and encoding correctly across all available markets.

Solution

Nielsen had already chosen AWS as its cloud infrastructure for its scalability and powerful computing engine. Wayne McClure, solution architect at Nielsen, saw an opportunity to find a self-service analytics tool that would integrate well with AWS while empowering business users across the organization to handle analytics. They chose Alteryx, a tool that would empower not only seasoned analysts but also business users to create a more inclusive use of their data. The team could house data in AWS, analyze the data in Designer, and schedule and automate workflows with Server, which Nielsen deployed on AWS. Users could also easily pop the data into Tableau for visualization. Utilizing Alteryx on the AWS platform, Wayne’s team was able to go into a rapid-fire testing process to get an end output. The team removed several redundant systems and cleaned up SQL queries. Using Alteryx, the team ended up with daily completed reports in a 4-minute process instead of 4 hours.

Impact #1	The implementation of Alteryx and AWS has transformed Nielsen's BI process. The company has been able to automate over 2150 processes and empower more than 3000 associates and leaders with data insights. The solution has also enabled over 250 self-service business end users, generating thousands of automated reports, processes, and tools for multiple thousands of end-users. The company has been able to create a more inclusive use of their data, allowing each organization to handle their analytics and rapidly iterate this across hundreds and thousands of people. The new BI process has also significantly reduced the time taken to complete daily reports, from 4 hours to just 4 minutes.

Impact #1

The implementation of Alteryx and AWS has transformed Nielsen's BI process. The company has been able to automate over 2150 processes and empower more than 3000 associates and leaders with data insights. The solution has also enabled over 250 self-service business end users, generating thousands of automated reports, processes, and tools for multiple thousands of end-users. The company has been able to create a more inclusive use of their data, allowing each organization to handle their analytics and rapidly iterate this across hundreds and thousands of people. The new BI process has also significantly reduced the time taken to complete daily reports, from 4 hours to just 4 minutes.

Benefit #1	2150+ processes automated
Benefit #2	250+ self-service business end users
Benefit #3	3000+ associates and leaders across the org empowered with data insights

Benefit #1

2150+ processes automated

Benefit #2

250+ self-service business end users

Benefit #3

3000+ associates and leaders across the org empowered with data insights

Download PDF Version

Overview

Nielsen's Business Intelligence Revamp with Alteryx and AWS

Operational Impact

Quantitative Benefit