leveraging alteryx and tableau at discovery communications
TRANSCRIPT
Discovery Communications, LLC
Leveraging Alteryx & Tableau to Measure Operational
Success Rate
Bernardo Roschke
Manager, Reporting & Planning
@bernardo_12
http://dataknightrises.com
1
Discovery Communications, LLC 2
Discovery Communications, LLC
Media Technology, Production & Operations
3
Global Content Supply Chain
What
Receive, process, and distribute content for broadcast and streaming
>800 employees in Silver Spring, Sterling, New York, Los Angeles, London, Miami, Munich and Singapore
Operate 187 TV networks Edit 23k hours of programming, customize 83k
hours of content in 45 languages, process 254k promos & commercials, and create 32k digital media assets annually
Who
How much
Discovery Communications, LLC
Production Center North
4
Silver Spring, MD
Post Production 52 Edit suites 6 Audio suites
New York City
Media Operations Center Duplication Authoring Digital Media Technical Evaluation
Post Production 5 Edit suites
Discovery Communications, LLC
Reporting & Planning
5
Facility and operational
metrics reporting
Expense planning for
cost recovery areas
Chargeback operations
Corporate Tableau Server Administrators
Key Function
s
Leverage 58 unique data sources for reporting, analysis, and planning responsibilities
Discovery Communications, LLC
Media Operations Center (MOC)
6
Old Method Tedious, multiple manual excel calculations Not visual
MGMT struggled to measure Duplication Success Rate
New Method Departmental and individual technician
level Differing success rate for differing
denominatorsAlteryx & Tableau to the rescue!
Challenge Disparate data sources Drill down capability
Discovery Communications, LLC
Alteryx Module
7
Discovery Communications, LLC
Select, Formula & Filter Tools
8
Discovery Communications, LLC
Union Tool
9
Align data on similar dimensions and measures
Output to Tableau Data Extract (TDE) file
Discovery Communications, LLC
Technician Success Calculation
10
Discovery Communications, LLC
Dashboard
11
Discovery Communications, LLC
MOC Manager
12
“Connecting our disparate volume and error log data sources enables us to drill down in each individual operator's success rate while maintaining a meaningful overview of our entire team's performance.
This data set provides a clear visual picture of our success to the business while allowing our line-level Supervisors to better identify and quickly manage error trends.”
Discovery Communications, LLC
Thank you
Bernardo Roschke
Manager, Reporting & Planning
@bernardo_12
http://dataknightrises.com
13