Transcript Tableau Software

Dallas Cowboys:
Sports Merchandising with Tableau
Bill Priakos
COO – Dallas Cowboys Merchandising
Bill Luisi, Jonathan Agee
Teknion Data Solutions
All rights reserved. © 2009 Tableau Software Inc.
Sports Merchandising
Session Agenda
• Introduction – Bill Priakos
• Case Study:
• The Cowboys Situation
• Teknion/Tableau Solution
• Results
• Keys to a Successful DW Project
• Q&A
All rights reserved. © 2009 Tableau Software Inc.
The Situation: Profile
Dallas Cowboys Merchandising Profile
All rights reserved. © 2009 Tableau Software Inc.
The Situation: Data Sources
Data Situation
CRM
eCommerce
Contact Management
Historical
Data
AX 4.0
RMS
Point of Sale
ERP system
Warehouse
• Disparate Sources
• Lacking cross-platform and cross-process reporting
• Each source had a different reporting system and paradigm
• Management relied on paper reports for daily insights
• Historical Data was missing
• Daly.Commerce data was not converted over in the upgrade
and was unavailable for reporting
All rights reserved. © 2009 Tableau Software Inc.
The Situation: What to Improve
Challenges
• General Challenges
• Lacking insight into data to answer even the basic questions
• Finding answers took forever (SSRS reporting cycle)
• Specific Business Challenges
• Margin was eroded because of late shipping.
• Lack of visibility into the warehouse order fulfillment process
• A lack of information made it difficult to hold vendors
accountable.
• Difficulty answering the question: What is available to sell?
• Difficult to identify Best- and Worst-sellers
All rights reserved. © 2009 Tableau Software Inc.
The Solution: Overview
Understanding the Challenges
• Disparate data sources with complex interrelated
processes
• Large amount of data
• Lost visibility into historical data
• Dependent on IT to build reports
• Need for end user analysis capability
All rights reserved. © 2009 Tableau Software Inc.
The Solution: Overview
Solution Summary:
• Proof of Concept
• “But what will our data look like in Tableau?”
• Obtained high level buy in
• Proposal:
• Tableau front end – To provide powerful visualizations
through a user friendly interface
• SQL Server back end – To provide a data warehouse
platform for data integration and aggregation
All rights reserved. © 2009 Tableau Software Inc.
A Basic Solution
Reporting Without Tableau
Buyers
ERP System
Sales Reps
Mgmt
Inventory System
Mgmt
Historical Data
Mgmt
All rights reserved. © 2009 Tableau Software Inc.
Operations
A Basic Solution
Reporting Without Tableau
Buyers
ERP System
Sales Reps
Mgmt
Inventory System
Mgmt
Historical Data
Mgmt
All rights reserved. © 2009 Tableau Software Inc.
Operations
A Better Solution
Tableau Reporting Directly From Source Systems
Buyers
ERP System
Sales Reps
Mgmt
Inventory System
Mgmt
Historical Data
Mgmt
All rights reserved. © 2009 Tableau Software Inc.
Operations
A Better Solution
Tableau Reporting Directly From Source Systems
Buyers
ERP System
Sales Reps
Mgmt
Inventory System
Mgmt
Historical Data
Mgmt
All rights reserved. © 2009 Tableau Software Inc.
Operations
The Best Solution
Tableau Enterprise Reporting
Sales Reps
Buyers
Mgmt
ERP System
Inventory System
Data
Warehouse
OLAP
Cube
Historical Data
Mgmt
All rights reserved. © 2009 Tableau Software Inc.
Operations
Solution: A Few Concepts
Dimensional Data Warehouse
“Dimensional modeling: A methodology for logically modeling data
for query performance and ease of use.... a fact table is surrounded
by a set of dimension tables describing precisely what is known in the
context of each measurement record.”
-- Ralph Kimball
Key Concepts
• What is a Dimension?
• What is a Fact?
• How do facts and
dimensions relate?
• Why is this the best
solution?
All rights reserved. © 2009 Tableau Software Inc.
Item
Sales Rep
Status
“Sales”
Fact Table
Location
Date
Customer
Solution: Analyze the Business
The Bus Matrix
“A bus matrix functions as a roadmap for the development of a set of
conformed dimensions and measure groups (facts) that span several
business processes. Each can be represented by a dimensional model.”
Sales Order
Invoice
Picking List
Address
Sales Rep
X
X
X
X
X
X
X
All rights reserved. © 2009 Tableau Software Inc.
X
X
X
X
X
X
X
X
Inventory Location
Sales Order Status
X
Warehouse Employee
Location
X
Vendor
Date
X
Purchase Order
Item
Sales
Inventory
Purchasing
Time
Customer
X
Business
Process
Purchase Order Status
Company
Common Dimensions
X
X
X
X
X
X
X
Solution: Extend the Concepts
OLAP Cubes
Data Warehouse / Data Marts
“An OLAP Cube is a multi-dimensional
database structure that is optimized
for high speed analysis and reporting
of a large amount of data.”
Why implement cubes?
• Simplified Security
implementation
• Improved Query Speed
• Simple end user connection
• Consistent metadata for a large
organization
• Allows correlation of measures
across business processes
All rights reserved. © 2009 Tableau Software Inc.
OLAP Cube
Solution: A Powerful Example
Correlating Sales and Inventory with a cube
All rights reserved. © 2009 Tableau Software Inc.
The Results: Monitoring KPI’s
Identifying at Risk Orders
All rights reserved. © 2009 Tableau Software Inc.
The Results: Powerful Analysis
Quick Insights into Large amounts of data
All rights reserved. © 2009 Tableau Software Inc.
The Results: Monitoring KPI’s
Understanding inventory value over time
All rights reserved. © 2009 Tableau Software Inc.
Solution: Success Points
To Summarize Our Approach:
Well Defined Methodology
• Started with a Proof of Concept – created high level buy-in
• Deliver early and deliver often – using an iterative approach
• Conducted analysis sessions with each department in order to ensure
that their specific needs are met
• Provided visualization templates to the Cowboys – giving them a
quick start to analysis
• Trained users to understand the data at their fingertips
All rights reserved. © 2009 Tableau Software Inc.
Solution: Success Points
To Summarize Our Approach:
Well defined data architecture
• Developed an enterprise data warehouse
• Used a Kimball dimensional modeling approach
• Created OLAP cube
World class data visualization tool
• And of course that was Tableau!
All rights reserved. © 2009 Tableau Software Inc.
Tangible Changes
Cowboys Merchandising Today
• Lower dependency on IT for reporting needs
• Near real time insights into game day merchandise sales
• Throughout the organization, users can find the answers to their
questions quickly and efficiently.
• Tableau gives business users a window into their data so that
they can make informed decisions. Priceless!
All rights reserved. © 2009 Tableau Software Inc.
Wrap Up
Follow on Contact Info
For copies of this presentation and additional inquiries:
1.
2.
This presentation is available in electronic format via the Tableau
website For more information, visit www.tableausoftware.com
(Conferences & Events, Presentations from Past Conferences and
Events)
If you have additional questions that were not covered during the
panel discussion, please feel free to contact any of the panel
members directly.
Bill Priakos
Chief Operating Officer
Dallas Cowboys
Bill Luisi
VP of Sales
Teknion Data Solutions
[email protected]
214-614-7601
Jonathan Agee
Senior BI Analyst
Teknion Data Solutions
[email protected]
All rights reserved. © 2009 Tableau Software Inc.
Wrap Up
Thank You
For Coming!
All rights reserved. © 2009 Tableau Software Inc.
Sports Merchandising with Tableau
All rights reserved. © 2009 Tableau Software Inc.
All rights reserved. © 2009 Tableau Software Inc.