wildcats and sun devils using bi to boost bi

4/22/2010

1

Wildcats and Sun Devils –Using BI to Boost BI

Doug Hester John Rome

Great College Rivalries

4/22/2010

2

RPI versus Union College

RPI Engineers

4/22/2010

3

Dutchman Shoes

Another Great Rivalry?

4/22/2010

4

4/22/2010

5

99.8 Miles

Territorial Cup

4/22/2010

6

Score?

4/22/2010

7

Painting “A” Mountain

Score?

4/22/2010

8

Rivalry in Our IT Shops?

Actually Not!

4/22/2010

9

About Doug

Parenting-A Phased Approach

4/22/2010

10

Vehicles-A Phased Approach

About John

4/22/2010

11

4/22/2010

12

U of A Peoplesoft Environment

4/22/2010

13

ASU Peoplesoft Environment

U of A BI Environment

• BI Tools

– Oracle Business Intelligence (OBIEE)

– Hyperion Interactive Reporting (OBIEE Plus)

• ETL Tool

– Ascential Data Stage

• Data Warehouse

– Peoplesoft EPM

4/22/2010

14

ASU BI Environment

• BI Tools

– Hyperion Interactive Reporting 9.2 (Brio)

– Corda Centerview (Dashboards)

• ETL Tool

– Ascential Data Stage

• Data Warehouse

– Peoplesoft EPM

– Legacy Data Warehouse

News Made by U of A Go-Live

4/22/2010

15

News Made by ASU Go-Live

Score?

4/22/2010

16

Agenda

• Usage Tracking (Mechanics)

– Hyperion Interactive Reporting (“Brio”)

– Custom (for Corda Dashboards)

– OBIEE

• Voyeur Into Usage Data

• Benefits of Tracking Usage

• Future Plans

Hyperion

4/22/2010

17

Hyperion IR Environment

Hyperion IR Is + (plus) Part of OBIEE+

4/22/2010

18

Hyperion IR Usage Documentation

Setting Up Hyperion IR Usage

4/22/2010

19

Hyperion IR Delivered Usage Query

• Started Seriously Tracking 02/2009– Hyperion Defaults to 30 day retention

• Table Rowcount– Event Table - ~2.7M Rows

– Object Table - ~1.1M Rows

– Query Table - ~150K Rows

– Users - ~3K Rows

• Adjusted Events Tracked Recently– Removed System and Database Login, etc.

Hyperion IR Usage Tables

4/22/2010

20

Corda/Custom

Corda Dashboard Environment

4/22/2010

21

Corda Dashboard Example

Corda Dashboard Usage Audit Tables

4/22/2010

22

Corda Dashboard Usage Audit Tables

• Started Tracking 02/2008 at Dashboard Level

– Dashboard Audit Table - ~230K Rows

• Added Page Level 11/2009

– Dashboard Page Audit - ~90K Rows

• Not Real Sophisticated

OBIEE

4/22/2010

23

OBIEE BI Environment

OBIEE Dashboard Example

4/22/2010

24

• Started Tracking From Inception 09/2009

• Table Rowcounts

– UA_F_OBIEE_USAGE (3.1M rows)

– UA_D_BIROLE_USERS, _DEPT, _TYPE (37K rows)

– UA_D_BIROLES (4K rows)

– UA_D_OBIEE_USAGE_PAGE_DSHB_QRY (497K rows)

– UA_D_OBIEE_USAGE_SUBJ_AREA (62 rows)

OBIEE BI Usage Tables

Setting UP OBIEE Usage

4/22/2010

25

Setting UP OBIEE Usage

4/22/2010

26

• http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/usage_tracking/usage_tracking.htm

• http://obiee101.blogspot.com/2008/08/obiee-setting-up-usage-tracking.html

• Video -http://www.artofbi.com/index.php/2009/11/obiee-usage-tracking-install-in-20-minutes/

OBIEE Usage Resources

4/22/2010

27

BI “Voyeurism”

• Customers Using BI

• Departments Using BI

• Job Titles/Positions Using BI

• Demographic Makeup of Those Using BI

• Browsers Using BI

• Date/Time Using BI

• Queries/Dashboards Most Used

• Where Customers Coming From (IP Address)

• How Long Using BI (“Stickiness”or for Performance)

• Etc.

BI “Voyeurism”

4/22/2010

28

Hyperion

Hyperion IR Usage

4/22/2010

29

Most Used Hyperion Query

Hyperion Usage Events Tracked

4/22/2010

30

What Busiest Customers Are Doing

Corda/Custom

4/22/2010

31

Dashboard Usage (Corda)

What Browsers Being Used

4/22/2010

32

Adoption KPI

• 36% increase in Departments

• 18% increase in Job Titles

• 56% increase in Users

•192% increase in Total Hits

Financial Dashboard June to June

4/22/2010

33

Non-Adopter Report

Targeting Job Titles/Departments

4/22/2010

34

Adoption Plan

OBIEE

4/22/2010

35

Tracking Usage by Date & Time

Tracking Top Dashboards/Queries

4/22/2010

36

Tracking Cluster Performance

Tracking System Performance

4/22/2010

37

Following User Life Cycle

Improving Query Performance

4/22/2010

38

Benefits From Tracking Usage

• Identify Top Users/Dashboards/Queries

– Did President Use the Dashboard?

– Should We Move the Most Used to Front Page?

– Who is Not Using?

• Historical Usage Trends

– Is Adoption Happening?

• Monitoring Query Performance

– What Queries or Dashboards are Slow?

• Others?

Drives Layout/Content Example

4/22/2010

39

Drives Layout/Content Example

Drives Layout/Content Example

“This is where customers want to go…”

4/22/2010

40

U of A MIS collaboration

• Grad Student Class Projects

• Research Use of Data

– Opportunity to work with real data

– Power users who create and follow new reports and paths

– Paths that people follow all the time and find ways to shorten the path to get them to the report they want faster

ASU Future Plans with Usage

4/22/2010

41

U of A Future Plans With Usage

4/22/2010

42

Score?

4/22/2010

43

Score?

Final Score?

4/22/2010

44

Questions?

Doug Hester John Rome

hesterd@arizona.edu John.Rome@asu.edu