Data-forward companies harness the power of their data by defining a set of “metrics” -- or key performance indicators (KPIs) -- and then analyzing them in different ways to make operational and strategic business decisions.
Related Articles:
- Sisu 101
- Defining a Metric
- Understanding & Defining Numerical Rate Metrics
- Understanding & Defining Weighted Average Metrics
- Understanding Impact
- Understanding Facts
Understanding Metrics
![]() |
A Metric is an aggregated calculation of a column within a data set (table or saved query from a data connection). |
The Sisu workspace is centered around Metrics. Metrics can be defined at any time, and can be used by the entire company in creating Analyses.
Here’s a good way to think about Metrics:
Metric = Metric Column(s) + Aggregation Method
Using different Aggregation Methods (which are calculations such as average, sum, count, or rate) on a selected column in your data can produce different types of Analyses. For example:
- average order value (using an average calculation as the Aggregation Method on the column)
- total revenue (using a sum calculation as the Aggregation Method on the column)
- and more.
In the following example, in the dataset the “order_value” column has been chosen as the Metric Column to analyze. This column can be used to define different Metrics, using various Aggregation Methods.
Note that in this example, the “AVG of order_value” is the average order value, which is the KPI that is being analyzed by Sisu with this defined Metric IF “Average” is selected as the calculation type Aggregation Method. If “Sum” is selected as the Aggregation Method for the Analysis, Sisu will perform the analysis based on the total order value (“SUM of order_value).
With different combinations of Metric Column and Aggregation Methods, you can perform a variety of General Performance Analyses. When you add “comparison” to an Analysis, you can perform useful Time Comparison and Group Comparison Analyses.
Seven Metric Types
When defining a Metric, you’ll see that Sisu provides seven different types, as shown below:
Each Metric type is defined using one or more numerical or categorical columns in your data, as described below.
Metrics Defined by |
Metrics Defined by |
Metrics Defined by |
---|---|---|
Average |
Weighted Average |
Categorical Rate |
Sum |
Numerical Rate |
Row Count |
Count |
The following charts provide further details about each Metric type.
NUMERICAL METRICS |
|||
Average |
Sum |
Count |
|
Metric Calculation |
sum(Metric column) / count(row) |
sum(Metric column) |
count(row) |
Sample Equation |
(30+90+40+120)/4 |
30+90+40+120 |
4 |
Sample Result |
65 |
260 |
4 |
NUMERICAL METRICS |
||
Weighted Average |
Numerical Rate |
|
Metric Calculation |
sum(Metric column*weight column) / sum(weight column) |
sum(Metric column)/ sum(denominator column) |
Sample Equation |
( 30*2 + 90*4 + 40*12.5 + 120*2 ) / (2+4+12.5+2) |
(20+80+15+30) / (25+150+40+90) |
Sample Result |
56.6 |
0.475 or 47.5% |
![]() |
Refer to the following articles for more information about these two Metric types: |
CATEGORICAL METRICS |
||
Categorical Rate |
Row Count |
|
Metric Calculation |
count(condition) / n |
count(condition) |
Sample Equation |
3 recurring orders out of 4 |
3 recurring orders |
Sample Result |
75% |
3 |
How Metrics Are Used
Sisu directly connects to data warehouses. A Metric can be built one of two ways:
- On an existing table in the data warehouse
- Through a custom query used to define Metrics using the Query Editor.
(Any member of your organization can then investigate these metrics without needing to create or review the same SQL code every time.)
![]() |
Refer to the “Connecting & Managing Data” section for details about uploading or connecting to your data. Refer to Creating & Managing Queries for details about creating a custom query on your data. |
With a metric defined, Sisu can run three types of Analysis:
- General Performance Analysis
- Time Comparison Analysis
- Group Comparison Analysis
![]() |
Refer to Defining a Metric for instructions on selecting and defining a Metric to use in your Analyses. Refer to Understanding Sisu's Analysis Types for detailed explanations of each analysis type. |