DEEP DIVEAll About Analytics: The Revolution Is Underway

www.dmradio.biz

Featured Speakers

Accidental Architectures ≠ Data Governance

How Can Data Be Governed?

Data warehousing requires lots of data movement

ETL tends to be opaque and brittle

Data federation is more possible now than ever

Leaving data in place helps prevent errors

Federated queries can solve many issues

Modern analytics spans many data types

The key is to reconcile data from different systems

Your Analyt ic ToolsAre O utdated

1

2

Data Technology Has Changed

Databases Then Databases Now

SLIDE NO. 3SLIDE NO. 3

44

Two Main ResponsesSQ L Black Box

Analyst

SELECT COUNT(*)

FROM....

55

That C auses Two ProblemsBottleneck C haosand/or

NEXT!

Analyst

SLIDE NO. 6SLIDE NO. 6

SQL is AMAZINGIt’s

• Everywhere• Funct ional• Proven• Making a comeback

SLIDE NO. 7SLIDE NO. 7

SQL is also TERRIBLEIt’s

• Write-only• Hard to learn• Easy to do badly• Not business-friendly

SLIDE NO. 8SLIDE NO. 8

Base View +

Field List + Filters + Sort = Any query

Enter LookML

SLIDE NO. 9SLIDE NO. 9

Any SQL Database

SQL Results

Extract ion &Loading

GovernedTransformation

Discovery &Visualizat ion

Delivery

SaaS Apps Business Planning Web Analyt ics

Web Interface

Self-ServeExplorat ion

Visualizat ion Export

Embed

SFDC iFrame Javascript

Scheduled Delivery

Email Webhook S3 SFTP

REST API

Scheduler Slack Metadata Auth

Agile Modeling LayerGit Version Cont rolJDBC Connect ions

User Management & Security

10

Transact ional DBs