Is this month normal?
The revenue of each month against what is usual for it: the three months before, and the same month last year. The months that stand out are listed. On a synthetic sales dataset: one invented shop, 2024-2025.
Sales
How do I tell my team every month?
A monthly review that rebuilds itself: the key figures of the last three months and the revenue per channel, with a dashboard and a Word report that follow when the flow runs on next month’s data. On a synthetic sales dataset: one invented shop, 2024-2025.
First steps: from raw sales to a chart
The basic gestures in one flow, step by step on the canvas: clean a messy column, fill a missing value, join two tables, filter, compute, summarize, draw. On a synthetic sales dataset: one invented shop, 2024-2025.
Does each payment have its order?
What each order billed against what was paid for it, both ways: the orders never paid, the payments for no known order, the orders paid a different amount. On a synthetic sales dataset: one invented shop, 2024-2025.
Do my groups really differ?
Is an order worth more on the web, in the store or on the phone? The channels side by side, then a test per pair of channels says whether the difference is real. Needs the statistics module. On a synthetic sales dataset: one invented shop, 2024-2025.
Do my customers form groups?
Revenue, orders and average basket per customer, grouped by k-means: how many groups the data supports, who is in each, and where they sit. On a synthetic sales dataset: one invented shop, 2024-2025.
Can I trust this file?
The raw file checked against written rules, errors and warnings, with a report of what breaks; then the fixes, a second check, and a gate that lets the rest run only on a file without errors. On a synthetic sales dataset: one invented shop, 2024-2025.
Am I on budget?
The net revenue of each quarter against a budget typed in the flow: the two drawn over time, and the gap of each quarter, in euros and in percent. On a synthetic sales dataset: one invented shop, 2024-2025.