Data Integrator Skill: from CSV to automatic report
The Data Integrator Skill extracts information from logs, CSV or databases, processes it (filtering, metric calculation, grouping) and automatically generates Excel or PDF reports without human intervention.
Automatic data pipeline
Read daily_sales.csv, calculate the weekly total by region, and generate an Excel with bar chart
Available transformation types
- Filtering: select rows by criterion (date, category, value)
- Grouping: sum, average or count by group
- Metric calculation: KPIs, percentage changes, rankings
- Pivoting: transform rows into columns and vice versa
- Source merging: combine data from multiple files