clearpeaks obiee 11g webinars - kpis & scorecards
DESCRIPTION
In this webinar you will learn how to build KPI's & Scorecards using this new feature from OBIEE 11g. Create Strategy Trees and Maps, Cause & Effect Diagrams, define the Mission & Vision of your organisation etc., and visualise this information in a state-of-the-art user interface that will improve decision making at all levels of your organisation.TRANSCRIPT
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Welcome to the OBIEE 11g Webinar Series offered by ClearPeaks. Let us know if you are experiencing any difficulty in getting the video and audio signal for this webinar by answering the polls that will appear on your screen. The Webinar will start at 16:05 CET
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
OBIEE 11g Webinar Series Building KPIs & Scorecards with OBIEE 11g 15th February 2012
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Presented by …
Alex Caminals
• Senior BI Consultant
• Computer Science Degree (Politechnical University of Catalunya, Barcelona)
• More than 10 years of experience in BI
• 7 years of experience in Oracle BI (incl. Siebel Analytics)
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Agenda
What’s Scorecarding?
Objectives
Overview
KPIs
Annotations and Overrides
1
2
3
4
5
Questions & Answers 7
LAB: Creating a KPI and Scorecard 6
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
What’s Scorecarding?
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Scorecarding Definition
“Scorecarding is a methodology that enables you to communicate strategic goals to your organization and monitor
their progress”
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
Customer Satisfaction
Sales
Costs Employee
Satisfaction
Vision & Strategy
1. Indicators are calculated based on Actuals vs. Targets
2. Indicators roll up to strategic objectives & initiatives, then to the Organisation Vision & Strategy
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
The Objectives
What’s Scorecarding? | Objectives| Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
The Objectives
• Design a platform for defining, communicating & tracking the organisation strategy & vision
• Define KPIs
• Define strategic objectives & initiatives
• Sub-objectives → Objectives → Vision
• Define how KPIs enable strategic objectives & initiatives
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Overview
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Scorecards & KPIs in Oracle BI 11g
• Dashboard Integration: Insert views from
the scorecard into dashboards to create interactive analysis
• KPI Agents: Create Agents to monitor KPI
performance across the time even when you can’t
• KPI & Scorecard Actions: Create Scorecard &
KPIs actions to align day to day decisions with corporate strategy
• Annotations and Rewriting: Collaborate and
document exceptions to prevent future recurrences
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Scorecarding - Concept A Scorecard is the communication vehicle to assess the organisation performance according to its strategic objectives & initiatives A scorecard helps answering questions like the following: • Where is the organisation going? • How will we get there? • What is critical to my success? • How am I doing against my goals?
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Scorecards Use & KPIs Implication
• Scorecards simultaneously define the objectives and initiatives that form your strategy to which you assign KPIs to measure progress and performance
• Define target numeric ranges to evaluate the values of KPIs
within corporate or department-level objectives and initiatives • Graphically communicate strategy and strategic dynamics using
strategy maps, cause & effect maps, custom views, and strategy trees
• Discuss the implementation and status of objectives and
initiatives by adding, reading, and replying to comments
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
KPIs
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
What’s a KPI?
• A KPI represents the result of a business measure evaluated against a target for that measure
• You can use KPIs to assess the performance of the strategic objectives and initiatives that form levels of organizational strategy
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
KPI - in Oracle BI EE
• Evaluate metrics against their targets and alert the
appropriate users via agents when targets are not met
• A KPI can allow the user to drill into different levels of details based on the KPI's dimensions
• Create Watch list to display trends, actual value and target in one same view
• Within Oracle Scorecard use KPIs to evaluate and monitor the performance of the objectives that form the strategy and the initiatives (tasks/projects) that are needed to meet your objectives
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
KPI - Characteristics
• Have measurable values that usually vary with time
• Are evaluated using targets to determine a score and performance status
• Can be compared over time for trending purposes that enable you to identify performance patterns
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Annotations & Overrides
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Annotations and overrides
• You can override the statuses of initiatives, objectives, or KPIs that measure the performance of initiatives and objectives
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Overview of Scorecard UI
• Demo
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Creating a KPI & Scorecard
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Creating a KPI & Scorecard
The steps to create a KPI & Scorecard are:
• Create a KPI
• Add KPI into Scorecard
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Create a KPI
• On the global header, select New and then KPI
• From the Select Subject Area dialog, select SampleSales subject area for the KPI
• The KPI wizard appears on the General Properties screen
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
General Properties
• Choose the Actual Value from the drop-down list, select ‘1- Revenue’:
F(x): "Base Facts"."1- Revenue“
• Choose the Target Value from the drop-down list, select ‘5- Target Revenue’:
F(x): "Base Facts"."5- Target Revenue"
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
General Properties
• Check the Enable trending option which shows up the Compare to prior and Tolerance fields allowing you to compare KPIs for prior periods and indicate a variance in performance.
• In the Compare to prior drop-down list, expand the Time folder and select
• "Time"."T02 Per Name Month" to compare with the prior month.
• Enter 2 in the Tolerance field and select % Change from the drop-down list.
Actual value
Actual value > +1%
Actual value < -1%
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
General Properties
• The General Properties screen will look like following:
• Click Next button to move to Dimensionality Screen
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Dimensionality
• The Dimensionality screen allows you to aggregate KPI values, target values, and ranges, using dimensions in the subject area
• You can set specific values which essentially filter the results, a process called pinning
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Dimensionality
• Add the Time and the Product hierarchies as below:
• Click Next button to move to Threshold Screen
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Thresholds
• The Thresholds screen allows you to indicate whether high, low, or target values are desirable; to specify ranges and status symbols for performance; to create or assign actions based on KPI status, and so on
• The Goal section provides a drop-down list that indicates a specific level of performance. Ensure that the defaults, High Values are Desirable, are selected.
• The Threshold section allows you to specify numerical values or measures that separate performance levels. In the first drop-down list, which is associated with the WARNING status, select the function image fx icon and copy the following expression
"Base Facts"."5- Target Revenue” * 0.94
• In the second drop-down list, which is associated with the CRITICAL status, select the function image fx icon and copy the following expression
"Base Facts"."5- Target Revenue” * 0.92
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Thresholds
• When applying the changes the final picture should looks like:
• Click Next button to move to Related Documents Screen
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Related Documents
• Refer to extra documents from the Catalog or Link for guiding the users to further information about the current KPI
• The final picture should looks like:
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Display results
• Click the Finish button and save in My Folder the KPI named Revenue vs Target KPI
• Go to home page and open the KPI to see the results that should be similar to the image below:
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Questions &
Answers
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
Some Answers…
• Webinar Slides
• Presentation will be sent via e-mail
• Next Webinar
• E-mail reminders will be sent to all Webinar attendees
What’s Scorecarding? | Objectives | Overview | KPIs | Annotations & Overrides | LAB | Q&A
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks
For more Information visit: www.clearpeaks.com www.clearpeaks.com/blog EMAIL: [email protected] T.(Spain): +34 93 272 15 46 T. (UK): +44 797 707 6717 T. (MEA): +971 556 683 072
PRESENTATION TO COMPANY INTRODUCTION
Copyright © 2012 ClearPeaks 9