Datasets are reusable data queries that power your reports in Tepun AI Report Builder. Create them with a single AI prompt, build them manually for precision, or click intelligent suggestions generated from your schema.
What are Datasets?
In Tepun reports, a dataset is a saved query that retrieves specific data from your connection. Think of datasets as building blocks:
- Reusable: Create once, use in multiple reports and workbooks
- Consistent: Changes to a dataset propagate to all dependent reports
- Transformable: Apply filters, aggregations, and calculations
- Schedulable: Refresh data automatically on your chosen schedule
Why Datasets Matter: Instead of writing the same query in every report, create a dataset once. All reports using that dataset stay synchronized. When your business logic changes, update it in one place.
The Traditional Way: Before AI Datasets
Before Tepun AI, creating datasets required:
- SQL Expertise: Writing complex SELECT statements with JOINs, GROUP BY, and subqueries
- Schema Knowledge: Memorizing table names, column names, and relationships
- Trial and Error: Testing queries in SQL clients, copying to BI tools, fixing errors
- Manual Documentation: Explaining to others what each dataset does and how to use it
- Brittle Dependencies: Reports breaking when underlying tables change
How AI Transforms Dataset Creation
Tepun AI Report Builder revolutionizes how datasets are created:
Natural Language Creation
"Get all orders from the last 30 days with customer names" becomes a complete dataset instantly.
Schema-Aware AI
AI knows your tables and columns. Say "customers" instead of "tbl_cust" — it understands.
Intelligent Suggestions
One-click dataset creation from AI-generated suggestions based on your schema.
Full Script Access
View and edit the generated SQL. Combine AI speed with technical precision.
Dataset Types
| Type | Best For |
|---|---|
| AI-Generated | Quick creation from natural language, exploration, prototyping |
| Manual Builder | Precise control over tables, joins, and columns |
| From Suggestions | One-click creation of common data combinations |
| Transformed | Derived datasets with filters, aggregations, pivots |
| Merged | Combined datasets from multiple sources |
Topics in This Section
Master datasets in Tepun AI Report Builder:
Create with Ask AI
Generate datasets from natural language prompts in seconds.
Create Manually
Build datasets step-by-step with the visual builder.
Edit & Modify
Update columns, filters, and logic in existing datasets.
View & Edit Script
Access and modify the underlying SQL query directly.
Transform Data
Apply filters, aggregations, pivots, and calculations.
Refresh & Schedule
Keep data fresh with manual refreshes and automatic schedules.
Start creating datasets at report.tepun.com — try Ask AI to build your first one.