Skip to content
Manual de usuario

Technical documentation

From data to

dashboard

From raw data to smart decisions. A single platform that eliminates technical complexity and accelerates your BI projects by up to 60%.

+
EASY
1
PLATFORM
60%
FASTER
BEST PRACTICES

One platform. All BI.

ETL, semantic model, analysis, reporting, dashboards and AI.

Live

Crono Data Stack

Del dato crudo a la decisión, sin fricciones

1
Data Sources LIVE
Databases REST APIs Files Excel
Extract · Load · Transform
2
Crono ETL AUTO
Extract
Load
Transform
3
Data Warehouse DWH
Snowflake Redshift BigQuery SQL Server PostgreSQL Databricks Fabric DuckDB
4
Crono Metadata SEM

Semantic layer · Self-service BI · No SQL

dwh.dim_products.sql Try in playground
MERGE CLONE dwh.dim_products KEY (product_id)
SELECT
  products.product_id,
  products.product_name,
  categories.category_name,
  suppliers.company_name supplier
FROM staging.products
INNER JOIN staging.categories USING category_id
INNER JOIN staging.suppliers USING supplier_id
Sintaxis simplificada
One language, all engines
Snowflake Redshift BigQuery SQL Server PostgreSQL Databricks MS Fabric DuckDB
Main Manual

Crono SQL

Crono SQL is a Data Warehouse language that compiles to native code. Write only the transformation logic and Crono will generate the complex SQL — MERGEs, temporary tables, CTEs — for your database engine.

  • Reduce manual code by 70%
  • Automatic audit in every operation
  • Works with any database engine
  • Detect errors before execution
ETL Orchestration

Crono ETL

Forget about checking logs at 3 AM. Automated loads that run by themselves, notify if they fail, recover automatically, and leave a complete audit trail of every operation.

  • Save 10 hours per week of manual work
  • Detect errors before they reach production
  • Updated, reliable and traceable data
  • Includes Calendas, our monitoring dashboard: visual load calendar, project management, detailed logs and dedication reports — all in one tool
Explore documentation
Pipeline: Daily DWH Load
ERP Extraction 02:30 AM · 4m 12s
Transformation 02:35 AM · 8m 45s
DWH Load In progress...
Validation Pending
Automatic scheduling
View Calendas
Calendas Dashboard
9/10 éxitos · 1 en progreso
Catalog: Retail Sales
Customers Dimension
Products Dimension
Time Dimension
Sales Facts
Total Amount Indicator
Drag & drop to report
Semantic Layer

Crono Metadata

Free your team from repetitive report requests. Business users create their own analysis without touching code.

  • Reduce IT requests by 60%
  • Create reports with drag and drop
  • Access control by user and role
  • Business language
Explore documentation
Business Intelligence

Crono Analysis

Make business decisions in minutes, not days. Self-service platform with dashboards that update automatically with the latest available data.

  • Answers in minutes without waiting for IT
  • Updated and reliable data
  • Automatic reports by email
  • Export to Excel in one click
Explore documentation
Sales by Region Trends
Sales Q1-Q4 2025
€2.4M Total Sales
+18% vs Previous Year
Real-time updates
Crono API v1.0 OAS 3.0
GET /api/ventas Sales by period 200
POST /api/ventas/filter Filter by region 200
GET /api/productos Product catalog 200
DEL /api/cache Clear cache 204
Response ⚡ 12ms 200 OK
[
  { "region": "Norte", "ventas": 12400 },
  { "region": "Sur", "ventas": 8200 }
]
Requests / seg
2.4k/s
● 99.9% uptime ⚡ 12ms avg ↑ 2.4k req/s
Web dashboards

Crono API

Publish your data as REST APIs in seconds. Connect any web or mobile application with your data models without writing server code.

  • Auto-generated REST APIs from your catalog
  • Built-in authentication and access control
  • Real-time connected web dashboards
  • Optional caching with one click
Sales Analysis AI OpenAI
What were sales by region in the last quarter?
Q4 2025 Sales Analysis
Region Sales Change
North €1.2M +15%
South €980K +8%
East €1.5M +22%
Excel View SQL
Ask about your data...
Export to Excel
View generated SQL
Artificial Intelligence · Data Assistant

Crono AI

Your intelligent assistant for data analysis. Ask questions in natural language, get answers with tables, charts and instant analysis. Connect with your Crono Metadata catalog for contextualized answers.

  • Multiple specialized assistants by area
  • Answers with tables and automatic analysis
  • Export results directly to Excel
  • Review generated SQL for total transparency
  • Connected with OpenAI, Claude and other providers
Sales_Report_2025.xlsx
Home Insert Data Crono
B2 fx
A
B
C
D
1
Region
Sales 2025
Change
Target
2
Norte
€1.240.000
+15%
€1.100.000
3
Sur
€980.000
+8%
€950.000
4
Este
€1.500.000
+22%
€1.200.000
5
Total
€3.720.000
+15,4%
€3.250.000
Sales by Region Products
Automatic updates
Verified DWH data
Reporting · Native Excel

Crono Excel

Crono Excel generates Excel reports from DWH data, leveraging Crono's semantic layer.

Who wants to give up Excel?
  • Excel reports connected to real DWH data
  • Uses Crono Metadata semantic layer
  • Automatic updates without macros or VBA
  • 100% customizable Excel format and structure

They trust Crono

Our clients