Transform Data
Apply filters, aggregations, pivots, and calculations to your datasets in Tepun AI Report Builder.
- Open the Dataset — Navigate to the dataset you want to transform
- Click Transform — Open the transformation interface
- Choose Transformation Type:
- Filter: Remove rows based on conditions
- Sort: Order data by one or more columns
- Group By: Aggregate data by categories
- Pivot: Turn row values into columns
- Unpivot: Turn columns into row values
- Add Column: Create calculated fields
- Rename Column: Change column headers
- Remove Column: Drop columns from output
- Configure Parameters — Set options for the transformation
- Preview Results — See transformed data before applying
- Apply and Save — Save the transformation
Common Transformations
| Goal | Transformation |
|---|---|
| Summarize by category | Group By + Aggregation (SUM, AVG, COUNT) |
| Calculate profit margin | Add Column with formula |
| Months as columns | Pivot on date field |
| Top 10 products | Sort + Filter (LIMIT) |
Using Ask AI: Say "Group this by region and sum the revenue" at report.tepun.com to apply transformations with natural language.
Learn about refreshing and scheduling datasets.