Tweet
Tweet

Slide 1

Slide 1 text

[email protected] www.rittmanmead.com @rittmanmead Robin Moffatt, Principal Consultant, Rittman Mead | UKOUG 2015 User Adoption and Retention 
 in OBIEE for the IT department 1

Slide 2

Slide 2 text

[email protected] www.rittmanmead.com @rittmanmead • Principal Consultant with Rittman Mead - OBIEE & ODI / SysAdmin / Performance • Previously … - OBIEE/DW developer at large UK retailer - SQL Server DBA, BusinessObjects, DB2, COBOL….
 • Blog: http://ritt.md/rmoff • Twitter: @rmoff • IRC: rmoff / #obihackers / freenode Robin Moffatt 2

Slide 3

Slide 3 text

[email protected] www.rittmanmead.com @rittmanmead About Rittman Mead 3 •World’s leading specialist partner for technical excellence, solutions delivery and innovation in Oracle Data Integration, Business Intelligence, Analytics and Big Data •Providing our customers targeted expertise; we are a company that doesn’t try to do everything… only what we excel at •70+ consultants worldwide including 1 Oracle ACE Director and 2 Oracle ACEs •Founded on the values of collaboration, learning, integrity and getting things done Optimizing your investment in Oracle Business Analytics •Comprehensive service portfolio designed to support the full lifecycle of any analytics solution

Slide 4

Slide 4 text

[email protected] www.rittmanmead.com @rittmanmead 4

Slide 5

Slide 5 text

[email protected] www.rittmanmead.com @rittmanmead 5

Slide 6

Slide 6 text

[email protected] www.rittmanmead.com @rittmanmead 6

Slide 7

Slide 7 text

[email protected] www.rittmanmead.com @rittmanmead 7

Slide 8

Slide 8 text

[email protected] www.rittmanmead.com @rittmanmead 8

Slide 9

Slide 9 text

[email protected] www.rittmanmead.com @rittmanmead 9

Slide 10

Slide 10 text

[email protected] www.rittmanmead.com @rittmanmead A System is Nothing Without its Users 10 • We need to ENGAGE users and we need to RETAIN users - How do we do that? - How do monitor if we are doing it well enough?

Slide 11

Slide 11 text

[email protected] www.rittmanmead.com @rittmanmead How Do We Engage and Retain Users? 11 - Data • Accurate • Available and Relevant • Timely
 
 
 
 - Accessibility • Intuitive Navigation • Good Response Times • Right Place & Right Time

Slide 12

Slide 12 text

[email protected] www.rittmanmead.com @rittmanmead 12

Slide 13

Slide 13 text

[email protected] www.rittmanmead.com @rittmanmead 13

Slide 14

Slide 14 text

[email protected] www.rittmanmead.com @rittmanmead Intuitive Navigation 14

Slide 15

Slide 15 text

[email protected] www.rittmanmead.com @rittmanmead 15

Slide 16

Slide 16 text

[email protected] www.rittmanmead.com @rittmanmead Measuring User Engagement and Adoption 16 • Frequency - Ratio of Daily Active Users (DAU) to Monthly Active Users (MAU)
 
 
 • Adoption - proportion of those with access to OBI who use it

Slide 17

Slide 17 text

[email protected] www.rittmanmead.com @rittmanmead Measuring User Engagement 17

Slide 18

Slide 18 text

[email protected] www.rittmanmead.com @rittmanmead Usage Tracking is a gold mine! 18 • Monitor - User Engagement levels - Usage patterns - System Performance - Unused Dashboards

Slide 19

Slide 19 text

[email protected] www.rittmanmead.com @rittmanmead 19

Slide 20

Slide 20 text

[email protected] www.rittmanmead.com @rittmanmead Enabling Usage Tracking 20 1. Import the tables to the RPD physical layer ‣ The tables S_NQ_ACCT & S_NQ_DB_ACCT that hold Usage Tracking data were created at installation time by the RCU tool (BIPLATFORM) 2. Add connection pool with R/W user 3. Update MBeans to point to tables/connection pool in RPD 4. Restart BI Server 5. Check nqserver.log for errors 6. Rinse & Repeat until it works…

Slide 21

Slide 21 text

[email protected] www.rittmanmead.com @rittmanmead SampleApp - thank you Oracle! 21 • Free download from Oracle • Fully provisioned virtual machine with whole OBIEE stack (and more) • Massive RPD and set of dashboards • Pre-built Usage Tracking model + reports • Lots of other goodies too!

Slide 22

Slide 22 text

[email protected] www.rittmanmead.com @rittmanmead Monitoring Performance 22

Slide 23

Slide 23 text

[email protected] www.rittmanmead.com @rittmanmead Measuring User Engagement 23

Slide 24

Slide 24 text

[email protected] www.rittmanmead.com @rittmanmead User Re-Engagement 24 • The data’s there - use it!

Slide 25

Slide 25 text

[email protected] www.rittmanmead.com @rittmanmead Does Anyone Really Use the Widget Report Anyway? 25 • Identify stale dashboards • Use the WebCat Utils from SampleApp for visibility of full catalog

Slide 26

Slide 26 text

[email protected] www.rittmanmead.com @rittmanmead Do You Have a “Shadow Army” of Reports? 26 • You have a set of dashboards for users to access - You may even have a report catalog and governance process • …but your users want their copy of it! • Inefficient for users • Big support overhead • A right PITA at upgrade time!

Slide 27

Slide 27 text

[email protected] www.rittmanmead.com @rittmanmead Performance 27 • Performance is not Oracle database cache hit ratios and tuning configuration parameters • Performance is the response time and variance as experienced by the users at their desks

Slide 28

Slide 28 text

[email protected] www.rittmanmead.com @rittmanmead Monitoring Performance 28

Slide 29

Slide 29 text

[email protected] www.rittmanmead.com @rittmanmead Performance Analytics Dashboards 29 • Monitor and Troubleshoot performance problems • Interactive dashboards for rapid analysis • Holistic view of OBIEE in one place - Response Times - Cache usage - Temporary file usage - Database metrics (ASH) - OS metrics

Slide 30

Slide 30 text

[email protected] www.rittmanmead.com @rittmanmead Why’s My Report Slow? 30 • WHERE’S my report slow:
 
 
 
 
 
 
 • http://ritt.md/silver-bullets-slides • http://ritt.md/silver-bullets-video

Slide 31

Slide 31 text

[email protected] www.rittmanmead.com @rittmanmead Performance Analytics 31

Slide 32

Slide 32 text

[email protected] www.rittmanmead.com @rittmanmead Performance Analytics 32

Slide 33

Slide 33 text

[email protected] www.rittmanmead.com @rittmanmead Rittman Mead Performance Analytics Service 33

Slide 34

Slide 34 text

[email protected] www.rittmanmead.com @rittmanmead User Engagement 34 Visual Redesign Business User Training Ongoing Support Engagement Toolkit Average user adoption for BI platforms is below 25% Rittman Mead’s User Engagement Service can help Source : http://www.biscorecard.com/bi-adoption-flat/ / https://www.gartner.com/doc/1712414/consumerization-bi-drives-greater-adoption

Slide 35

Slide 35 text

[email protected] www.rittmanmead.com @rittmanmead OBIEE Click Stream Data 35 • Usage Tracking is great, but it only captures interactions with the BI Server • We have the capability to easily track every interaction a user makes with OBIEE • Native OBIEE capability, minimal overhead

Slide 36

Slide 36 text

[email protected] www.rittmanmead.com @rittmanmead OBIEE Click Data Analysis 36 • Which browsers are my users using? Are they using Desktop or Mobile?

Slide 37

Slide 37 text

[email protected] www.rittmanmead.com @rittmanmead OBIEE Click Stream Data Analysis 37 • How often do users export data? From which reports? To what format?

Slide 38

Slide 38 text

[email protected] www.rittmanmead.com @rittmanmead OBIEE Click Stream Data Analysis 38 • Segment users based on click patterns to identify those least likely to return to the system

Slide 39

Slide 39 text

[email protected] www.rittmanmead.com @rittmanmead #EOF 39 email
 [email protected] web
 http://ritt.md/rmoff twitter
 @rmoff irc
 rmoff @ #obihackers Rittman Mead User Engagement Service http://ritt.md/ue Rittman Mead
 Performance Analytics Service http://ritt.md/pa