Key Performance Indicators (KPIs) represent a comprehensive view of performance against a specific organization objective.
Oracle industry experts use KPIs as a central object to describe best-practice, business concepts of Oracle Fusion Analytics Warehouse. These can be extended, or they can be used to create new KPIs . A KPI represents the value of a measure or metric as evaluated against a target. This gives the KPI a status which a simple metric doesn't have. KPIs reflect the essential health of the business and serve as a rallying point for business collaboration. KPIs also provide a launching point for additional predictive and prescriptive analysis and exploration.
Creating a KPI allows you to combine different data into a single container and then view that data in a variety of ways. This way you can create best practice business concepts simply using measures and targets.
- Designate a primary measure Value for which the KPI is evaluated against the Target.
- Choose one or more Targets that the organization is working towards.
- Select the goal of the Target.
- Determine which time periods you want to show: Month, Quarter, or Year.
- Set up any related Dimensions or Measures by which to group values on a card, and to allow filtering by those Dimensions.
- If you want to Filter by specific data, then set up filters.
There are a few things to keep in mind when you are working with KPIs.
- The type of KPI is reflected by the icon for the KPI. A blue icon represents a KPI created by a user. Red icons represent KPIs originally created by Oracle. A red icon with a small Oracle "O" indicates a KPI provided by Oracle; while a red icon with a person symbol embedded indicates a KPI provided by Oracle but customized by a user. You can revert KPIs to the original definition.
- The status for a KPI is reflected in the color of the band at the top of the KPI Card. The name of each of these respective statuses can be modified to best reflect the specifics of a KPI, but the common status still persists as a common state used across all Cards. Depending on the Conditions defined, the threshold equates to one of these options: Critical (Red), Warning (Orange), Good (Green), or On Target (No color).
- Only one Value measure is allowed.
- Data element properties apply to all instances of that element within the same KPI. If you want to create different sets of properties for the same data element, duplicate the element, and then apply the different sets of properties to each element. Be sure to name each element in a way that identifies each, such as Revenue_US showing US Dollars for currency and Revenue_EU showing Euros for currency.
- You can blend multiple Data Sets in a join but cannot blend multiple subject areas. In the Data Blending drop-down, select Custom to specify options.
- Generate Visualizations or Filters (or both) by placing columns in Related Dimensions. The columns are generated from the source KPI data in all the cards in the deck.
- The templates available in the Conditions area are determined by the Target Goals. If you select Org Target and Revenue Objective for your target goals, then Org Target and Revenue Objective are available in the Conditions area, and visualizations that complement those targets are shown in the Preset Templates. The Template names, ranges, and color values are customizable.
Data Blending in KPIs
A KPI is based on a single dataset or subject area, or multiple data sources with at least one join between the data sources in order to establish their respective data relationships. Joins are described within Oracle Analytics Cloud using the visualization tool. Describe the joins, then add the data to the KPI to use the relationships. The join is automatically a traditional left join, however you may want to specify other relationships for blending data across datasets. (See Blend Data that You Added in Visualizing Data and Building Reports in Oracle Analytics Cloud.) The presence of a subject area denies these options.
To change these blending options, select the name of the KPI then edit its properties. In the Data Blending field, select either Auto or Custom. If you choose Custom, you can set the blending of each data source present to either All Rows or Matching Rows. You must assign at least one source to All Rows. See Blend Data that You AddedChange Data Blending in a Project in Visualizing Data and Building Reports in Oracle Analytics Cloud.