wildcats and sun devils using bi to boost...
TRANSCRIPT
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
42
Score?
4/22/2010
43
Score?
Final Score?
4/22/2010
44
Questions?
Doug Hester John Rome