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.
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.
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.
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.
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.
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.
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.
