Where do you create KPI’s in the Data Model?
a. By selecting Create KPI from the Diagram View.
b. By right-clicking on the base value (measure) in the calculation area and selecting Create KPI.
c. By right-clicking on the column name on the Data View and selecting Create KPI.
d. By right-clicking on the base value (measure) on the Pivot Table and selecting Create KPI.
The correct answer and explanation is:
Correct Answer: b. By right-clicking on the base value (measure) in the calculation area and selecting Create KPI.
Explanation:
Key Performance Indicators (KPIs) are used in data models to measure performance against a target. They provide insights into business performance and help in tracking progress toward specific objectives. KPIs are often built upon existing measures, which represent the numerical calculations or metrics used in a data model.
To create a KPI in the data model, you need to start with a base measure. This measure could represent metrics like total sales, profit, or any calculation that reflects your key business metric.
The correct approach involves right-clicking on the base measure in the calculation area of the data model and selecting “Create KPI.” The calculation area is specifically designed to allow users to create measures and KPIs and manage them efficiently. This ensures that the KPI is directly tied to the base measure and enables additional configuration, such as:
- Defining the Target: After selecting “Create KPI,” you can specify a target value or a measure that represents the goal to compare against the base value.
- Defining Thresholds: You can set thresholds to visually represent performance ranges, such as red for poor performance, yellow for moderate, and green for good performance.
- Visualization Options: KPIs can include graphical indicators, such as arrows, shapes, or colors, to provide a quick visual summary.
Other options mentioned in the question, such as selecting “Create KPI” from the diagram view, data view, or a pivot table, are not valid because the KPI creation process is tied specifically to measures and is performed in the calculation area. This structured process ensures the KPI is aligned with the data model’s calculations and can be utilized across reports and dashboards.