tableau your data! roadshow speech kansas city 02182013

41
Dan Murray Director of BI Services InterWorks, Inc. February 18, 2014 Kansas City TUG

Upload: daniel-murray

Post on 02-Jul-2015

297 views

Category:

Documents


1 download

TRANSCRIPT

Page 1: Tableau your data! roadshow speech kansas city 02182013

Dan Murray

Director of BI Services

InterWorks, Inc.

February 18, 2014

Kansas City TUG

Page 2: Tableau your data! roadshow speech kansas city 02182013

Hello Kansas City!

Page 3: Tableau your data! roadshow speech kansas city 02182013

Topics

• My first Tableau Project

• The data flood

• Being an evangelist/getting buy-in

• Deployment strategies

• Building effective dashboards

Page 4: Tableau your data! roadshow speech kansas city 02182013

My First Tableau Project

Page 5: Tableau your data! roadshow speech kansas city 02182013

Rapid Deployment

• Sales

• Inventory

• Accounts Receivable

• Accounts Payable

• Purchasing

Page 6: Tableau your data! roadshow speech kansas city 02182013

Dimensionally-Conformed Spreadsheet

Page 7: Tableau your data! roadshow speech kansas city 02182013

Lessons Learned

•Start quickly

•Spreadsheets work

•Fast payback

Page 8: Tableau your data! roadshow speech kansas city 02182013

3,000 hours

$450,000

Savings

Page 9: Tableau your data! roadshow speech kansas city 02182013

I learned…

Everyone

needs

Tableau

Page 10: Tableau your data! roadshow speech kansas city 02182013

The Data Flood

• Volume

• Velocity

• Variety

Page 11: Tableau your data! roadshow speech kansas city 02182013
Page 12: Tableau your data! roadshow speech kansas city 02182013

Order of Magnitude

Sources: Wikipedia, Wired Magazine

Page 13: Tableau your data! roadshow speech kansas city 02182013
Page 14: Tableau your data! roadshow speech kansas city 02182013

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:

Page 15: Tableau your data! roadshow speech kansas city 02182013

Digital Data 2014

801,032,628,345,222,987,368 Year-to-date through 2/18/2014 (8:55AM EST)

801.032 Exabytes

0.801 Zettabytes

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

Page 16: Tableau your data! roadshow speech kansas city 02182013

New 1-TB Drives Needed

801,032,628

Page 17: Tableau your data! roadshow speech kansas city 02182013

$2.28 billion

Page 18: Tableau your data! roadshow speech kansas city 02182013

Storage is keeping pace.

Page 19: Tableau your data! roadshow speech kansas city 02182013

Variety

• Relational Databases

• Non-relational Databases

• Grid/cache storage

Over 190 commercial and open source options available.

Page 20: Tableau your data! roadshow speech kansas city 02182013

“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

Page 21: Tableau your data! roadshow speech kansas city 02182013

Part of the Answer

Tableau

Software

Page 22: Tableau your data! roadshow speech kansas city 02182013

Answer Part II

Your skill &

Knowledge

Page 23: Tableau your data! roadshow speech kansas city 02182013

Data

Visualization

Evangelist

Page 24: Tableau your data! roadshow speech kansas city 02182013

“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

Page 25: Tableau your data! roadshow speech kansas city 02182013

Getting Buy-in

Move quickly

Make a compelling story

Show something they haven’t seen

Page 26: Tableau your data! roadshow speech kansas city 02182013

Pick something

you can finish

in < 4 weeks

Page 27: Tableau your data! roadshow speech kansas city 02182013

Don’t do what your

boss asks you to do…

Page 28: Tableau your data! roadshow speech kansas city 02182013

Make something

better…

Page 29: Tableau your data! roadshow speech kansas city 02182013

Deployment Strategies

Page 30: Tableau your data! roadshow speech kansas city 02182013

Consider

organizational

culture

Page 31: Tableau your data! roadshow speech kansas city 02182013

Facebook

Mostly organic growth with

a common company

culture.

Page 32: Tableau your data! roadshow speech kansas city 02182013

Cisco Systems

Growth through acquisition

with a variety of company

cultures.

Page 33: Tableau your data! roadshow speech kansas city 02182013

Facebook

• Centrally controlled

• Center of excellence

• Rapid expansion

Page 34: Tableau your data! roadshow speech kansas city 02182013

Cisco Systems

• Central funding

• Decentralized control

• Natural adoption

Page 35: Tableau your data! roadshow speech kansas city 02182013

Both successful

Page 36: Tableau your data! roadshow speech kansas city 02182013

Building

Effective

Dashboards

Page 37: Tableau your data! roadshow speech kansas city 02182013

They fit in the available space

Load quickly

Are easy to use & understand

Effective means

Page 38: Tableau your data! roadshow speech kansas city 02182013
Page 39: Tableau your data! roadshow speech kansas city 02182013

Cascading Design

Page 40: Tableau your data! roadshow speech kansas city 02182013

A live example

..using the Coffee Chain data..

Page 41: Tableau your data! roadshow speech kansas city 02182013

Dan [email protected]

Twitter: dgm885

Speech noteshttp://tableauyourdata.com/downloads/