deep dive - dataversitycontent.dataversity.net/rs/656-wmw-918/images/deepdive... · 2020-03-08 ·...

30
DEEP DIVE Leave IT Alone: The Vast Value of Self-Service #DMRadio

Upload: others

Post on 15-Apr-2020

1 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

DEEP DIVELeave IT Alone: The Vast Value of Self-Service

#DMRadio

Page 2: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

Featured Speakers

Page 3: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?
Page 4: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?
Page 5: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

The Long-Standing Data Warehousing Models

Page 6: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

The Reliance on ETL Must Subside!

Page 7: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

Trust is the Cornerstone of Data-Driven BusinessData warehousing was designed with old constraints

- Storage was expensive

- Processors were slow

- Pipes were thin

- Consolidation into a warehouse was possible

Today, we don’t need to strip out context!

Federated queries can help restore trust in data!

Without trust, data is basically useless

Page 8: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

The Cycle Time for Disruption Is CollapsingThe business world gets less forgiving by the day! Companies must be agile to survive. If organizations are not data-driven, they will not last!

Consider these omens:UberAirbnbLinkedIn

Page 9: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

Leave IT AloneThe Vast Value of Self Service

DM Radio

SPEAKERK e n n y C u n a n a n

P r o d u c t M a r k e t i n g & A n a l y t i c s M a n a g e r

Page 10: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

Kenny Cunanan

2

Product Marketing Manager, Looker

Page 11: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

OurQuestions

I. How did we get here?

II. What has changed?III. What do we do?

3

Page 12: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

How did we get here?

4

Page 13: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

5

By standing on the shoulders of giants.

1970 1980 1990 APRILRelational Database Model Developed by Edgar Codd

Page 14: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

6

By standing on the shoulders of giants.

1970 1980 1990 APRILRelational Database Model Developed by Edgar Codd

SEQUEL (later SQL) developed at IBM

Page 15: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

7

By standing on the shoulders of giants.

1970 1980 1990 2000Relational Database Model Developed by Edgar Codd

SEQUEL (later SQL) developed at IBM

Monolithic BI tools like MicroStrategy and BusinessObjects gain traction

Page 16: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

8

By standing on the shoulders of giants.

1970 1980 1990 2000Relational Database Model Developed by Edgar Codd

SEQUEL (later SQL) developed at IBM

Monolithic BI tools like MicroStrategy and BusinessObjects gain traction

Self-Service Tools like Tableau and Excel begin to gain prominence

Page 17: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

What has changed?

9

Page 18: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

10

Databases NowDatabases Then

We’re living in an age of modern databases

Page 19: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

We’re also living in the Golden Age of Data

11

More data captured More data literacy

Page 20: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

This means we can build on lessons from the past

12

Single Source of Truth

Data Discovery Self-Service

Page 21: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

13

Technology alone is NOT going to solve

everything.

Page 22: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

14

Think of accessing data as grocery lines

Page 23: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

15

Think of accessing data as grocery lines

Page 24: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

16

True self-service creates a relationship between IT and business users

Page 25: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

So, what dowe do?

17

Page 26: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

18

We focus on these two areas

Build trust in the data Train Users Effectively

Page 27: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

Build Trust in the Data

19

• Everyone accesses the same model

• Analysts codify their knowledge

• Logic lives in one place which means• Version Control• Auditable

• Keeps everyone on the same page

Page 28: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

Train Users Effectively

20

“If you have an open service culture, you want everyone to have skills to use business intelligence tools.”- Carl Anderson, Warby Parker

Page 29: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?

21

Example of a Curriculum

Data Sources

What data sources are available to us?

Data Storage

Where does the data live in our organization?

How does it get there?

Data Access

What are the different ways that

we can access data?

Why might we want to access

data one way over the other?

Data Analysis

How do we ask proper questions

of the data?

What questions should I ask being

in role X?

Communication

What’s the best way to visualize data?

How do I present my findings so I don’t

extrapolate or stretch an interpretation?

How do I provide feedback?

Page 30: DEEP DIVE - DATAVERSITYcontent.dataversity.net/rs/656-WMW-918/images/DeepDive... · 2020-03-08 · 21. Example of a Curriculum. Data Sources. What data sources are available to us?