Creating and Managing KPI's

Welcome to the Datarails KPI’s guide.
This article will walk you through creating and analyzing Key Performance Indicators (KPIs) for your business, enabling you to track metrics and generate insights effortlessly.

Introduction to KPI’s

You can now centralize and manage all your important business metrics in one place. KPIs allow you to:

  • Track critical numbers essential to your business operations.
  • Compare results across different periods.
  • Gain insights through advanced analysis and AI-powered reports.

Creating Your First KPI

Follow these simple steps to create a KPI:

  1. Access the KPI Creation Screen:
    • View prebuilt KPIs and available aggregation options.
    • Analyze existing KPIs or create new ones.
  2. Set Up a New KPI:
    • Name Your KPI: Give it a descriptive name.
    • Select a Data Table: Choose the dataset your KPI will rely on (e.g., demo datasets).
    • Add a Description: Explain the purpose and data source for your KPI.

Step-by-Step Guide to KPI Creation

Step 1: Define the Base Data

  • Use the list of fields on the left to build your metric.
  • Select a date field for time reference and set the aggregation type (e.g., Month-to-Date or MTD).
  • Configure the reference date to display data for specific periods like previous months, quarters, or years.

Step 2: Apply Filters and Aggregation

  • Select the value to track (e.g., expenses).
  • Apply filters to refine the dataset. For example, show expenses for a specific month like November 2024.
  • Experiment with different aggregation options to format data according to your needs.

Step 3: Add Comparisons

  • Configure comparisons to analyze data over time: Compare current data to the previous month, previous year, or budget.
  • These comparisons will update automatically.

Step 4: Use Conditional Formatting

  • Set up colors to visually highlight trends or outliers. For instance, use green for lower expenses and red for higher ones.

Step 5: Incorporate Dimensions

  • Add dimensions like regions, line items, or categories for deeper insights.
  • Drag and drop fields to include them.
  • Apply specific filters during this step for tailored analyses.

Advanced Analysis Features

AI-Powered Insights

  • Configure analysis preferences to unlock AI tools for trend analysis, variance analysis, and scenario-based insights.
  • Set defaults for analysis, such as time ranges for trends or prediction modeling.

Customizations and Adjustments

  • Modify preferences for reports, aggregation, and analysis types at any time.
  • Personalize how data is displayed and ensure it aligns with your business goals.

Generating AI Insights Reports with KPIs

After setting up your KPI, follow these steps to generate AI-powered insights:

  1. Select the Period: Choose the data range (e.g., current month or quarter).
  2. Customize Report Settings: Adjust analysis preferences or remove specific types if partial insights are preferred.
  3. Generate Reports: Create comprehensive AI Insights Reports directly from the metrics screen.

Key Benefits

  1. Easily track and compare metrics across periods.
  2. Visualize trends and insights with AI-powered tools.
  3. Customize KPI settings to adapt to business needs.

Enjoy seamless KPI management and business tracking with Datarails!




© Datarails Ltd. All rights reserved.

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.