| Table of Contents |
|---|
...
Overview
eMite BI platform supports KPI creation/maintenance through its KPI dashboard. Anyone has been given access to KPI dashboard can create/edit/delete/publish KPI(s) and/or use KPI(s) inside other KPI(s). Also within each KPI creation/maintenance, we are able to add as much as we want, with the ability to apply business logic filters on top of existing data sources. The data sources are eMite's RTBI data structures - and not the customer's data sources.
...
Access KPI Dashboard
There are two options to access KPI Admin dashboard page:
1. Web Admin Dashboard Page
Go to eMite Web admin page.
From Edit Page menu, select Add Content.
Click Add Row button.
On the Select Datablock page, select KPI Admin then follow the Add button. You should now see the new KPI Admin page added. The page can be resized by dragging the resize tool on the right corner of the page.
2. Standard Method
The eMite web dashboard refreshes all the pages automatically (including the one you have already opened within KPI Admin page), or you may need to navigate through other pages. When this happens, you may face an RTBI data source structure's reloading experience, or you may even lose your page if you did not save it. Some users want to create/change/publish KPI(s) reports and quickly test the result. These users are likely to experience the reloading issue more than others, as they need regular page navigation. In this case, you should use the direct KPI Admin URL in another browser or a separate page on the current browser.
...
Contact your eMite administrator or eMite consultants if the page failed to open, probably the settings in back-end have not been configured correctly.
...
Components/Sections of the KPI Admin Dashboard
There are three main components on the KPI Admin dashboard page. These allow you to add, edit, delete, and/or publish KPIs in eMite platform.
...
| Note |
|---|
Any creation, deletion, and edit will be auto-saved - so be careful when making changes within KPI Admin dashboard. The auto-save does not perform the auto-publish (where you can see changes in report designers). The KPI will only be published when the UpdateKPI button is selected (see below on how to Publish). |
...
Cube & KPI Selection
Click the expand button to collapse or expand the options.
...
Cubes | The Cube is a report representation of your single or multiple data sources. In eMite, this sometimes called a Fact Query. The Cube can be selected from the system dropdown menu. | ||
KPI Groups | The KPI Group is a group that contains one or many KPIs.
| ||
KPIs |
|
...
Templates & Settings
Click the expand button to collapse or expand the options.
...
Template
Predefined templates can be used for predefined calculations. This is the standard mode of KPI calculation where we use predefined KPI templates to create KPIs.
...
For example, Callback Handled: | |
|---|---|
 | The [Measures].[Handled Count] means that we are trying to count the handled calls where "Handled Count" is the measure. The [InitiationMethod].[InitiationMethod].[CALLBACK] means that we are looking for Callback (Initiation method dimension member) calls. The combination of the measure and dimension filter means that we are trying to count the number of Callback Handled. |
...
KPI Template | Description | Example |
|---|---|---|
SUM(A) = X | This is the sum aggregation of records for a set (Set A) of logic. | "Number of PI Incidents", which shows the sum of incident records by P1 priority. |
SUM (A) / SUM(B) * 100 = X% | This type is used to create percentage KPIs.
The percentage is a value from between 0 to 100. However, eMite % KPI calculates the % depending on Set A and Set B. | % of Answered Calls, which shows a percentage of number of calls were answered versus the total calls offered to the queue. |
SUM(A) + SUM(B) = X | The result of this type of KPIs would be the sum of results from Set A and Set B. Each Set can have one or many logics (filter). If in case, you are looking for Set A + Set B + Set C, you need to first build your first KPI (for example call it MyFirstKPI) as Set A + Set B, then publish it, then reload the KPI Amin (to make sure the new KPI, MyFirstKPI, has come through to the list of measures). Then you can build second KPI as Set A + Set B, where Set A (or Set B) can use the new KPI, MyFirstKPI, as your measure. | Total Handle Time4 = Talk Time + Hold Time + After Call Work Time In this case, we create 2 KPIs.
|
SUM(A) - SUM(B) = X | Similar to SUM(A) + SUM(B), but here the final result is the Set A - Set B |
|
SUM(A) * SUM(B) = X | Similar to SUM(A) + SUM(B), but here the final result is the Set A multiply Set B |
|
SUM(A) / SUM(B) | Similar to SUM(A) + SUM(B), but here the final result is the Set A divided by Set B | |
SUM(A) = X (include 0) | This is same as SUM(A) = X, but has one more feature - and that is, if the result is empty (null value), it gets converted to zero. |
|
Advanced | This is an advanced mode of KPI calculation where none of the above templates covered your calculation type. Here, you can put your own MDX query (the query language of Analytic structures - for more clarification, refer to: https://msdn.microsoft.com/en-us/library/ms144785.aspx) and system will try to parse, run, and return a numeric value of that.
|
Visible
When set to “false” and after publishing your changes, nobody will see that KPI in reporting side - so it is like a hidden KPI. If a KPI does not need to be used by users/reports through dashboard, it can be used to build a second level of KPIs.
...
one is a fixed value KPI (like $1 per unit of low performance), and you approximately prefer to hide it of reporting side,
and the second one which is the actual low performance value KPI, calculates the performance.
Format String
This feature is to wrap the KPI value to a specific format. eMite supports following formats. This feature helps to show the values in proper format in all places like status block, cube report.
"#,##0.00 %;-#,##0.00 %"
"#,##0.00;-#,##0.00"
"$#,##0.00;-$#,##0.00"
"0"
"Currency"
"d/MM/yyyy"
"dddd, d MMMM yyyy"
"Long Date"
"Percent"
"Short Date"
HH:mm:ss
e.g. % Answered KPI
...
Status KPI
When creating a KPI, you can define the expected Thresholds Boundaries for that KPI, and what color (Status) the KPI will represent in the dashboard.
...
Status color can be set to the font color, background color, header color, etc. in the status block.
Trend KPI
Trend KPI is used to find how the KPI is performing during time - Is it getting better? worse? or even not changing?
...
As discussed at the start of the article, a KPI has many angles and Trend is one of them. Even knowing a KPI value and its status, but there are reasons to find how the KPI is performing during time - is that getting better, worse or even not changing? Knowing the team performance is good, but it is also useful to know when the performance is dramatically moving down. To see the KPI's direction, you can use a eMite's Score Board and check the KPI's Trend.
Target KPI
Target KPI is a value which helps you understand how close your KPI are from what you are expecting as your desire value. How much you are expecting to sell in current financial year is a Target for your selling KPI. Same as Trend KPI, you can see that value in Score Board datablock and if no KPI has been linked to TargetKPI of a KPI, the Target would come from the first value of threshold boundaries.
Description
Just put your own description about the KPI and explain the logic. Anyone who looks at your KPI can/will understand the reason and logic of your KPI with Description.
Threshold Boundaries
The threshold boundaries are what you are expecting your KPI to look like.
...
| Info |
|---|
Although, the three statuses, Green/Warning/Alarm are very popular, in eMite, there is no limitation on how many expression lines/colors you want to have. You are welcomed to have nothing or even 10 lines. You can pass your own desire expression values and colors as well, all would be automatically and with no delay reflected into UI components. |
Setting Up Threshold Boundaries Based on Another Dimension
E.g. Setting up threshold boundaries for % Answered KPI based on Queue Name.
...
In this case, you need to:
Select a member of a dimension (BasicQueue from QueueName).
Click Add button of Threshold Boundaries.
Enter your own expression later as shown in the screenshot below.
Continue the same steps to setup threshold boundaries for each queue.
...
Reports
Logic (Filters)
Filters allow you to include additional filters over the measures. A KPI can have multiple filters. E.g.
...
Example: Contact handle time = Interaction Duration + Hold Duration + After Call Work Duration
Select the Cube emite_awsContactTraceRecords.
Under KPI Groups, enter the KPI name “Agent interaction and hold time”.
Click Add button. / Under Templates & Settings, select the template “SUM{A}+SUM{B}=X”.
Select “AgentInteractionDuration Sum” for Set A, and “CustomerHoldDuration Sum” for Set B.
Click Update KPI to publish the KPI.
Refresh the KPI admin page to reload the new measure “Agent interaction and hold time”.
Select the Cube emite_awsContactTraceRecords.
Under KPIs, enter the KPI name “Contact Handle Time”.
Click Add button. / Under Templates & Settings, select the template SUM{A}+SUM{B}=X.
Select ‘‘Agent interaction and hold time” (KPI which was created in the previous step) for Set A, and “AgentAfterContactWorkDuration Sum” for Set B.
Click Update KPI to publish the KPI.
Publish
Once you created/edited/deleted your KPIs, you need to publish them to RTBI engine.
...
Example 2.: Aggregate both Incident and Problem Count for Today
Select the Cube emite_incident.
Under KPI Groups, enter the KPI name “Incident And Problem Count”.
Click Add button. / Under Templates & Settings, select the template SUM{A}+SUM{B}=X
Select “emite_incident Count’ measure and ‘sys_created_on’ date as a filter.
Click Add button for Set A. / Edit the filter and update date function “@Today” as shown on the screenshot below.
Tick the Enable Multiple Source checkbox.
Select the Cube emite_problem.
Select “emite_problem Count” measure and “sys_created_on” date as a filter.
Click ‘Add button for Set B. / Edit the filter and update date function “@Today” as shown on the screenshot below.
Click Update KPI to publish the KPI.
...
“Incident and Problem Count” now can be selected under emite_incident cube.
...