KPI Balanced Scorecard v.12

The whole list of KPI targets for a period is available from a single interface. Right from here you can set up new targets and edit existing ones, observe actual and target values, evaluate success by indicative red / green color, observe historical trends, open and close periods. It is also possible to export a whole scorecard to an Excel table.

To make navigation over targets comfortable, KPIs are structured by categories. It let quickly consider only those KPIs which are of interest at the moment. For example, to observe only sales targets or targets of a specific Odoo user. Another important peculiarity is that KPIs might have parent-children relations. For instance, 'Total company sales' > 'Sales America' > 'John Brown Sales'. Such hierarchy allows to highlight targets with indicative padding for instant overview of sub-KPIs.

It is only up to you which KPIs to add and which approach to apply for KPIs' sectioning and hierarchy.

KPI scorecard is not just a dashboard, but it is a full-featured tool to set and control company and individual targets. Targets should be measurable and time-constrained. 'Sell as much as possible' is not a goal, while 'Generate 100,000 Euro Revenue in the year 2021' is a good target for a sales person, for example.

That is why, each goal should have a target value and should be defined for a period. In such a way, the app let you have a full picture of results to undertake corrective actions in advance.

When a user opens scorecard interface, he/she is shown targets of a current period (if it exists). Actual values are re-calculated regularly and automatically by the special Odoo cron job. In such a way, it is possible to understand which KPIs require more attention in real time at a first glance.

Simultaneously, it is always possible to switch to another period to have broader picture (e.g. from monthly to yearly KPIs) or to observe the Past / the Future targets (e.g. to plan efforts efficiently).

Besides, each KPI target has a special button to observe history by all periods. The latter might be useful to understand overall trends.

A KPI (a key performance indicator) is a measurement which aims to evaluate a certain aspect of organizational or personal activities. This tool let you prepare an unlimited number of such measurements and calculations of almost any complexity.

Formula construction is as simple as it is to write down a mathematical expression: just drag and drop formula parts in a right order with correct operators. When Odoo computed actual values for a specific period, it would automatically retrieve data from a database according to parts' logic. As formula parts you can apply:

• KPI variables - rules how to calculate data from Odoo database. For example, 'total number of sales orders' or 'number of quotations of sales team Europe'.
• Other KPIs - to make derivative calculations. For example, you may have KPIs 'Sales count' and 'Opportunities count', and a derivative KPI 'Opportunity to sales success ratio'.
• KPI constants - figures which do not depend on actual Odoo data, but which are frozen globally or for a specific time frame. Constants allow to introduce parts which can not be retrieved from modules and/or which should remain the same during the whole period.
• 2 special variables - 'Period Days' and 'Days Passed'. Those figures are calculated not from Odoo data, but from the KPI period settings under consideration. 'Period Days' is an interval length in days. 'Days Passed' is a length between period start and today (if today is before period end; otherwise period end). Those parameters let calculate per-time KPIs, such as, for example, 'Average sales per week'.
• Mathematical operators - including subtraction, addition, multiplication, division, exponentiation, any float number.

Preparing basis for KPI calculations is not a simple task. The good news is that such job should be done only once, while results are used forever.

A basic measurement is the core object used for retrieving actual KPI value from Odoo database. Basic measurements represent the most general calculation, while KPI measurements specify those. For example, 'total number of sales orders' should be a basic measurement, while narrower 'number of quotations of the sales team Europe' is recommended to be a precision of that basic measurement (so, a KPI measurement or a KPI variable). Each basic measurement might have an unlimited number of linked KPI variables. In such a way, KPI variable let you prepare a formula part which might calculate:

• A total number of specified records within a given period. For example, a number of registered leads or a number of posted customer invoices.
• A sum of specified records' numeric fields. For example, sum of all orders amount total or sum of paid taxes by invoices.
• An average of specified records' numeric fields. For example, average planned hours per task or average days to assign a lead

If those 3 types of calculations are not enough, basic measurements let you prepare the Python code to compute any sort of figures based on any Odoo data.

Full rights for all KPIs, targets, and settings belong to users with the right 'KPI Management - KPI manager'. Simultaneously, the tool let you share KPIs with other users as well.

In particular, you can grant an access to observe KPIs using the 'Read rights' section on a KPI or a KPI category form. The section 'Edit rights' would not only allow to see scorecard by related KPIs, but also to set targets for those. The latter might be useful in case you ask your manager to manage goals within a department, for example.

Take into account: all security settings are additive and they are not restrictive. KPI managers would have full rights for all KPIs disregarding the settings, while other users would have rights only to KPIs which settings (or category settings) allow them so.

The tool is compatible with multi companies' environment. In particular, KPI periods and KPI targets are set up for each company individually (global targets are not possible).

KPI basic measurements assume that a company field is selected for a chosen model. It let distinguish which records are under consideration. If a company field is empty, all records would be analyzed.

Constants, KPI variables, and KPI formulas might be also assigned to a specific company. That might be used to simplify selection of formula parts when companies operate in different business areas.