tableau your data! roadshow speech portland tug - nike 02112014

Dan Murray

Director of BI Services

InterWorks, Inc.

February 11, 2014

Portland TUG - Nike

I’m thrilled to be here!

Topics

• My first Tableau Project

• The data flood

• Being an evangelist/getting buy-in

• Deployment strategies

• Building effective dashboards

My First Tableau Project

Rapid Deployment

• Sales

• Inventory

• Accounts Receivable

• Accounts Payable

• Purchasing

Dimensionally-Conformed Spreadsheet

Lessons Learned

•Start quickly

•Spreadsheets work

•Fast payback

3,000 hours

$450,000

Savings

I learned…

Everyone

needs

Tableau

The Data Flood

• Volume

• Velocity

• Variety

Order of Magnitude

Sources: Wikipedia, Wired Magazine

The NSA is watching

• Internet Searches

• Websites visited

• Emails sent & received

• Social Media activity

• Blogging activity

• Videos watched/uploaded

• Photos viewed/uploaded

• Cell phone GPS data

• Cell phone Apps downloaded

• Phone call records

• Text messages sent/received

• Skype video calls

• Online purchases/transactions

• Credit card transactions

• Financial information

• Legal documents

• Travel documents

• Health records

• Cable TV shows watched

• Commuter toll records

• Bus and subway passes

• Facial recognition data

• Arrest records

• Drivers license data

• And more….

http://nsa.gov1.info/data/index.html#dataSource:

Digital Data 2014

462,170,216,577,264,268,748 Year-to-date through 1/28/2014 (1:12PM EST)

462.170 Exabytes

0.463 Zettabytes

Source: EMC Worldwide Information Growth Ticker (power by IDC Research)

New 1-TB Drives Needed

462,170,217

$1.32 billion

Storage is keeping pace.

Variety

• Relational Databases

• Non-relational Databases

• Grid/cache storage

Over 190 commercial and open source options available.

“New Digital Universe

Study Reveals Big Data

Gap: Less Than 1% of

World’s Data is Analyzed.”

http://www.emc.com/about/news/press/2012/20121211-01.htmSource: IDC

Part of the Answer

Tableau

Software

Answer Part II

Your skill &

Knowledge

Data

Visualization

Evangelist

“We humans are not a consistent

identity moving through time, but a

chain of successive selves, each

tangentially linked to, and yet

distinct from, the previous and

subsequent ones.”

Derek Parfit

Philosopher & Author of Reasons and Persons

Getting Buy-in

Move quickly

Make a compelling story

Show something they haven’t seen

Pick something

you can finish

in < 4 weeks

Don’t do what your

boss asks you to do…

Make something

better…

Deployment Strategies

Consider

organizational

culture

Facebook

Mostly organic growth with

a common company

culture.

Cisco Systems

Growth through acquisition

with a variety of company

cultures.

Facebook

• Centrally controlled

• Center of excellence

• Rapid expansion

Cisco Systems

• Central funding

• Decentralized control

• Natural adoption

Both successful

Building

Effective

Dashboards

They fit in the available space

Load quickly

Are easy to use & understand

Effective means

Cascading Design

A live example

..using the Coffee Chain data..

Dan Murraydan.murray@interworks.com

Twitter: dgm885

Speech noteshttp://tableauyourdata.com/downloads/