tableau your data! roadshow speech indianapolis tug

39
Indianapolis TUG! Dan Murray Director of BI Services InterWorks, Inc. January 14, 2014

Upload: daniel-murray

Post on 08-May-2015

652 views

Category:

Technology


3 download

DESCRIPTION

Book tour talk.

TRANSCRIPT

Page 1: Tableau Your Data! Roadshow Speech Indianapolis TUG

Indianapolis TUG!

Dan Murray

Director of BI Services

InterWorks, Inc.

January 14, 2014

Page 2: Tableau Your Data! Roadshow Speech Indianapolis TUG

Topics

• My first Tableau Project

• The data flood

• Being an evangelist/getting buy-in

• Deployment strategies

• Building effective dashboards

Page 3: Tableau Your Data! Roadshow Speech Indianapolis TUG

My First Tableau Project

Page 4: Tableau Your Data! Roadshow Speech Indianapolis TUG

Lesson’s Learned

•Start quickly

•Spreadsheet work

•Fast payback

Page 5: Tableau Your Data! Roadshow Speech Indianapolis TUG

Rapid Deployment

• Sales

• Inventory

• Accounts Receivable

• Accounts Payable

• Purchasing

Page 6: Tableau Your Data! Roadshow Speech Indianapolis TUG

Dimensionally-Conformed Spreadsheet

Page 7: Tableau Your Data! Roadshow Speech Indianapolis TUG

3,000 hours

$450,000

Savings

Page 8: Tableau Your Data! Roadshow Speech Indianapolis TUG

I learned…

Everyone

needs

Tableau

Page 9: Tableau Your Data! Roadshow Speech Indianapolis TUG

The Data Flood

• Volume

• Velocity

• Variety

Page 10: Tableau Your Data! Roadshow Speech Indianapolis TUG
Page 11: Tableau Your Data! Roadshow Speech Indianapolis TUG

Order of Magnitude

Sources: Wikipedia, Wired Magazine

Page 12: Tableau Your Data! Roadshow Speech Indianapolis TUG
Page 13: Tableau Your Data! Roadshow Speech Indianapolis TUG

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 14: Tableau Your Data! Roadshow Speech Indianapolis TUG

Digital Data 2014

198,963,721,196,546,000,000

198.96 Exabytes

0.198 Zettabytes

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

Page 15: Tableau Your Data! Roadshow Speech Indianapolis TUG

New 1-TB Drives Needed

198,963,721

Page 16: Tableau Your Data! Roadshow Speech Indianapolis TUG

$567 billion

Page 17: Tableau Your Data! Roadshow Speech Indianapolis TUG

Storage is keeping pace.

Page 18: Tableau Your Data! Roadshow Speech Indianapolis TUG

Variety

• Relational Databases

• Non-relational Databases

• Grid/cache storage

Over 190 commercial and open source options available.

Page 19: Tableau Your Data! Roadshow Speech Indianapolis TUG

“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 20: Tableau Your Data! Roadshow Speech Indianapolis TUG

Part of the Answer

Tableau

Software

Page 21: Tableau Your Data! Roadshow Speech Indianapolis TUG

Answer Part II

Your skill &

Knowledge

Page 22: Tableau Your Data! Roadshow Speech Indianapolis TUG

Data

Visualization

Evangelist

Page 23: Tableau Your Data! Roadshow Speech Indianapolis TUG

Getting Buy-in

Move quickly

Make a compelling story

Show something they haven’t seen

Page 24: Tableau Your Data! Roadshow Speech Indianapolis TUG

Pick something

you can finish

in < 4 weeks

Page 25: Tableau Your Data! Roadshow Speech Indianapolis TUG

Don’t do what your

boss asks you to do…

Page 26: Tableau Your Data! Roadshow Speech Indianapolis TUG

Make something

better…

Page 27: Tableau Your Data! Roadshow Speech Indianapolis TUG

Deployment Strategies

Page 28: Tableau Your Data! Roadshow Speech Indianapolis TUG

Consider

organizational

culture

Page 29: Tableau Your Data! Roadshow Speech Indianapolis TUG

Facebook

Mostly organic growth with

a common company

culture.

Page 30: Tableau Your Data! Roadshow Speech Indianapolis TUG

Cisco Systems

Growth through acquisition

with a variety of company

cultures.

Page 31: Tableau Your Data! Roadshow Speech Indianapolis TUG

Facebook

• Centrally controlled

• Center of excellence

• Rapid expansion

Page 32: Tableau Your Data! Roadshow Speech Indianapolis TUG

Cisco Systems

• Central funding

• Decentralized control

• Natural adoption

Page 33: Tableau Your Data! Roadshow Speech Indianapolis TUG

Both successful

Page 34: Tableau Your Data! Roadshow Speech Indianapolis TUG

Building

Effective

Dashboards

Page 35: Tableau Your Data! Roadshow Speech Indianapolis TUG

They fit in the available space

Load quickly

Are easy to use & understand

Effective means

Page 36: Tableau Your Data! Roadshow Speech Indianapolis TUG
Page 37: Tableau Your Data! Roadshow Speech Indianapolis TUG

Cascading Design

Page 38: Tableau Your Data! Roadshow Speech Indianapolis TUG

A live example

..using the Coffee Chain data..

Page 39: Tableau Your Data! Roadshow Speech Indianapolis TUG

Dan [email protected]

Twitter: dgm885

Speech noteshttp://tableauyourdata.com/downloads/