How are sales changing?
Sum revenue by month to compare trends across the quarter.
Make sense of the data.
Build stronger analyses.
Join tables, remove duplicates and calculate the indicators you need. Build the process in the visual editor, inspect each step and reuse it when new data arrives.
An example: from sales to analysis.
Two sources. Three questions. One workflow.
Sales tell you how much revenue you made. Customer records tell you who bought and in which sector. Connect them to compare monthly trends, markets and sales agents’ contributions.
The demo case
- Sales
- 60 orders · January–March 2024
- Customers
- 12 fictional companies with sector data
Which sectors contribute most?
Use sector data from customer records to compare markets against the same sales data.
How does the team contribute?
Group by sales agent to see each person’s contribution without starting over from the files.
The logic stays in the workflow. Update the inputs, rerun the same process and refresh the connected analyses.
Inside the process, step by step.
Each step has a specific purpose. See how a sale gains customer context, how a metric is defined and where its output is used.
Starting data
Each sale has a date, month, customer, sales agent and revenue. Sector data lives in the customer file: to analyse sales by market, the two files need to work together.
With Agatha
Describe the result. Build the process.
Agatha helps you build a workflow, configure its steps and understand errors. The logic stays in the editor, where you can read, edit and reuse it.
Meet Agatha“Join sales and customers, remove duplicates and calculate revenue by sector.”
The same question as the demo: sources, joins, cleaning and aggregation in a workflow you can inspect.
A workflow you can understand and reuse.
Visual blocks
Join, filter, group and transform data. Connections show where inputs come from and where results are used.
SQL and Python
Add queries and code for processing that needs more control. Connect their outputs to the other workflow blocks.
Recurring runs
Save the workflow and run it again on updated data. For scheduled server runs, choose a paid plan with the allowances you need.
Explore automationLess rebuilding. More useful analysis.
Show us how you prepare data today. In the demo, we’ll map the path from your sources to the result you need.