1. Home
  2. Docs
  3. Ajelix BI
  4. Data Preparation
  5. How To Create KPIs?

How To Create KPIs?

KPIs are metrics that help businesses track their progress toward achieving specific goals. They provide valuable insights into how well a company is performing and where improvements can be made.

Metrics can be created using our data preparation tool before visualization. This guide will walk you through the steps to create a calculated field. For more detailed data modeling guides visit this guide.

1. Connect Data Source

The first step is to add the data source, if you already have the data source then skip this step. If you don’t have a data source follow the guides here to upload your data source.

Add data source for kpi dashboard creation on ajelix bi page, screenshot

2. Clean and transform your data

Ajelix BI allows you to clean or transform your data (e.g., converting formats, filtering). This ensures accuracy and consistency. It’s not a mandatory step but recommended for better analytics. To do that open data preparation tool.

Data preparation step on ajelix bi portal screenshot

3. Create calculated fields

In the data prep tool, you can create different KPIs and metrics to transform your data. To create a KPI follow these steps (and check the image for better understanding):

  1. Open the data source you want to edit
  2. Click “Add measure”
  3. Rename the metric, e.g. “Cost per unit”
  4. Insert the calculation in the formula bar, here you can write Excel-like functions, SQL queries (we have an SQL query generator that can help you write these functions), or simple calculations such as summing or dividing different columns.
  5. Click “Apply” to get the measure
How to calculate KPI metric on ajelix bi dashboard - step by step guide with screenshot from portal

You can create as many measures as you need or add new columns to your data file and do calculations there.

4. Visualize your KPIs

Choose the visual format for each KPI (e.g., card, gauge chart, line graph). Click on data fields in the visualization tool. You will find newly created measures in your data source, if you don’t see them sync the model by clicking the “Refresh” button.

Take these steps to create visualization from your KPI (follow the steps in the picture for better understanding)

  1. Open the data source and find the measure menu. Here you will see all the calculated fields.
  2. Click on any metric to create a new element and insert it into the visualization.
  3. The element will automatically pop up and you can customize it, by changing data label formatting, legends, colors, and chart type.
  4. You can make changes in the data prep tool and sync changes in the dashboard by pressing the “Refresh” button.
Create visualizations from your KPIs screenshot from bi platform

If you don’t feel like visualizing you can always use AI features. AI dashboard generator can automatically create charts based on your data and you can customize it further.

5. Customize your dashboard

Add titles, and descriptions, and format the layout for clarity and visual appeal. Upload your logo, and change the colors using the AI color changer under “Report Settings” field.

6. Share your dashboard

Once happy, publish your dashboard and share it with relevant users for real-time insights. There are several sharing options that you can read about here.

share your kpi dashboard with other users using sharing settings screenshot from ajelix bi

For a detailed visualization guide visit this documentation.