The Forcing Function: BI Reports for Encoder Verification Solutions
Nielsen 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.
As it turned out, the next-day reporting process was built on the very BI tool that was on its way out. And Wayne’s team suddenly found out that they had under 90 days before the tool was scheduled to be turned off.
Wayne begin to investigate the available information. He found that there was one whitepaper and a final UI requirement doc, but no additional documentation or transparency into the pipeline.
“That original BI tool that was used to aggregate all of the data, create all the metrics, and push all the essential reports out to everybody was a big ole black box. All the features and capabilities that were used to build the original system were locked behind a very long-forgotten SAAS subscription, which of course we no longer paid for,” Wayne said.
The Reboot: AWS + Alteryx
Wayne needed a solution and needed it fast.
Nielsen had already chosen AWS as its cloud infrastructure for its scalability and powerful computing engine. Wayne 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.
“We were looking for a tool that would empower not only our seasoned analysts but also business users to create a more inclusive use of our data. To allow each org to handle their analytics, and take information and questions and even challenges we hadn’t seen before, and rapidly iterate this across hundreds and thousands of people,” said Wayne.
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 can also easily pop the data into Tableau for visualization.