> ## Documentation Index
> Fetch the complete documentation index at: https://docs.nekt.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Historical Data Tracking & Trend Analysis

> Build comprehensive historical records of your business metrics with proper change tracking and trend analysis.

## The Challenge

Businesses need to track how their key metrics evolve over time to understand trends, make informed decisions, and comply with reporting requirements. However, maintaining accurate historical records presents several challenges:

* Capturing point-in-time snapshots of metrics
* Tracking changes in dimension attributes over time
* Managing slowly changing dimensions (SCD)
* Ensuring data consistency across time periods
* Creating reliable trend analysis

With Nekt, companies can implement proper historical tracking using SCD Type 2 methodology, **maintaining a complete history of changes** while enabling powerful trend analysis and historical reporting. This approach ensures data integrity and provides valuable insights into business performance over time.

<CardGroup cols={2}>
  Teams can now build comprehensive historical records of their KPIs, tracking
  changes in both metrics and dimension attributes. This enables accurate trend
  analysis, year-over-year comparisons, and reliable historical reporting that
  supports better business decisions.

  <Steps>
    <Step title="Data Source Integration" icon={"file-lines"}>
      Connect to any data source, from CRMs to custom systems.
    </Step>

    <Step title="SCD Implementation" icon={"code-compare"}>
      Implement SCD Type 2 to track historical changes in dimensions and
      metrics.
    </Step>

    <Step title="Trend Analysis" icon={"display"}>
      Create powerful visualizations to analyze trends and patterns over time.
    </Step>
  </Steps>
</CardGroup>

## Implementation Example

Here's how teams are using Nekt to implement historical tracking:

1. **Historical Data Management**

   * Implement SCD Type 2 for dimension tracking
   * Capture daily snapshots of key metrics
   * Maintain effective and expiration dates
   * Track current and historical records

2. **Data Transformation**

   * Transform source data into historical format
   * Handle type 2 changes in dimensions
   * Create surrogate keys for historical tracking
   * Implement change detection logic

3. **Analysis & Reporting**
   * Create trend analysis dashboards
   * Compare metrics across time periods
   * Generate historical reports
   * Analyze patterns and changes

<iframe width="560" height="315" src="https://www.youtube.com/embed/Vq8BNiCuzB8" title="[PT-BR] Historical KPIs" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; fullscreen" allowfullscreen />

> Check our [LinkedIn post](https://www.linkedin.com/posts/pedroceriotti_casos-de-uso-1-criando-planilha-para-monitorar-activity-7259255321477402624-bzrx?utm_source=share\&utm_medium=member_desktop\&rcm=ACoAACmSaqsBoGmqk5BJrIBVYND5-MEnQMnE6Vs) about it!