Embed GoodData Analyticsin Your Force.com App

Petr OlmerGoodData Chief Evangelist

What is GoodDatabusiness intelligence platform in the cloud

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

GoodData

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

GoodData

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Data in, analytics out

GOODDATA@CLOUDSTOCK – DEC 6, 2010 – PETR OLMERDREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Our Vision

BI without the BS.

It’s called Business Intelligence,

not IT Intelligence.

“Ay, madam, it is common.”Hamlet

GOODDATA@CLOUDSTOCK – DEC 6, 2010 – PETR OLMERDREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Business intelligence

GOODDATA@CLOUDSTOCK – DEC 6, 2010 – PETR OLMERDREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Platform is not enough

Apps are the best wayto get started with GoodData.

BI PLATFORM AS A SERVICE: INTRODUCTION TO GOODDATA

BI PLATFORM AS A SERVICE: INTRODUCTION TO GOODDATA

BI PLATFORM AS A SERVICE: INTRODUCTION TO GOODDATA

BI PLATFORM AS A SERVICE: INTRODUCTION TO GOODDATA

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Your app

GoodData Architectureit’s the economy, stupid

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Standard IT projects

never delivered

not in time/budgetnever used

success

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Standard BI projects

never delivered

not in time/budget

never used

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

In the cloud

GOODDATA@CLOUDSTOCK – DEC 6, 2010 – PETR OLMERDREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Key principles

multitenant stateless

partitioned asynchronous

Data agnostic

GoodData

REST API

uni!ed logical data model

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

GOODDATA@CLOUDSTOCK – DEC 6, 2010 – PETR OLMERDREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Parles-vous MAQL?

multidimensional analysis

driven by logical data model

simple yet powerful

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

MAQL

GOODDATA@CLOUDSTOCK – DEC 6, 2010 – PETR OLMERDREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

API in and out

If you can see it,

there’s an API call for it.

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Report on UI

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Report

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Report de!nition

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Data Result

Your Data to GoodDataapps and connectors

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Customer Success Team

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Applications

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Applications

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Applications

connectorsdata modelmetrics/KPIs

reportsdashboards

GOODDATA@CLOUDSTOCK – DEC 6, 2010 – PETR OLMERDREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

The meat

!at "les connectors

SQL connectors

API connectors

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

CL

Command line utility

GoodData

REST API

manages:

★ project

★ model

★ data

★ users

GOODDATA@CLOUDSTOCK – DEC 6, 2010 – PETR OLMERDREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

CL commands

CreateProject();

UseSfdc();

GenerateMaql();

TransferData();

InviteUser();

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Work"ow

GoodData cloud

your machine with CL

ExecuteMAQL

Force.com

XML MAQLGenerateMAQL

UseSfdcTransferData

GOODDATA@CLOUDSTOCK – DEC 6, 2010 – PETR OLMERDREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Uni!ed model in XML

<schema> <name>users</name> <columns> <column> ... </column> <column> ... </column> </columns></schema>

GOODDATA@CLOUDSTOCK – DEC 6, 2010 – PETR OLMERDREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Uni!ed model in XML

<column> <name>id</name> <title>User ID</title> <ldmType>ATTRIBUTE</ldmType></column>

GOODDATA@CLOUDSTOCK – DEC 6, 2010 – PETR OLMERDREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Uni!ed model in XML

<column> <name>id</name> <title>User ID</title> <ldmType>ATTRIBUTE</ldmType></column>

GOODDATA@CLOUDSTOCK – DEC 6, 2010 – PETR OLMERDREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

<ldmType>

ATTRIBUTE

FACT

DATE

CONNECTION_POINT

REFERENCE

LABEL

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Attribute and labels

Account

Id

Name

Uri

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Attribute and labels

Account

Id

Name

Uri Force.com

GoodData to Force.comjust plug in

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Integration

GoodDataForce.com

data

dashboardsreports

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

GoodData

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Salesforce.com

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Embed

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Embed

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Embed

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Embed

label.account.sfdcid.name={!$Account.Name}

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Embed

label.account.sfdcid.name={!$Account.Name}

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

In Force.com

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

In Force.com

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Dynamic

GoodDataForce.com

reports

one reportmany views

GOODDATA@CLOUDSTOCK – DEC 6, 2010 – PETR OLMERDREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

More dynamic

page context

user context

GOODDATA@CLOUDSTOCK – DEC 6, 2010 – PETR OLMERDREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Variables

different data to different users

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Single Sign-On

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Integration

GoodDataForce.com

data

dashboardsreports

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Ruby DSL

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Ruby DSL

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Ruby DSL

DREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Integration

GoodDataForce.com

data

dashboardsreports

3rd party tools

controldata

GOODDATA@CLOUDSTOCK – DEC 6, 2010 – PETR OLMERDREAMFORCE 2011: EMBED GOODDATA ANALYTICS IN YOUR FORCE.COM APP

Resources

http://developer.gooddata.com

@gooddata_dev

Embed GoodData Analyticsin Your Force.com App

it’s easy

@petrolmerGoodData Chief Evangelist