Interactive demo
Forecast sales, with a margin of error
Pick a horizon: the line follows the seasonality and the shaded area shows the likely range.
- Python
- Power BI
Interactive demo
Four dashboards for decisions based on the right numbers
Inventory, sales, cash, marketing: pick a dashboard, then change the filters. Every figure recalculates, just like in a Power BI report.
Pick a dashboard
Which items are about to run out, and where?
Switch warehouse: KPIs, ABC analysis and alerts recalculate.
Stock value
€263k
at cost
Stock turnover
6.1×
times a year
Average cover
59 days
of stock
Products on alert
11
out of 30 products × 3 warehouses
- A
- B
- C
A few products make most of the revenue: those are the ones you must never let run out.
Products to reorder
Where does revenue come from, and is margin keeping up?
Change the region or period: KPIs, trend line and categories recalculate.
Revenue
€2.6M
▲ 8.1% vs last year
Orders
4,865
▲ 6.1% vs last year
Average order value
€540
▲ 1.9% vs last year
Margin rate
29.1%
over the period
- This year
- Last year
View the data as a table
How much cash in three months, depending on the scenario?
Change the period or scenario: the cash forecast and threshold alert recalculate.
Revenue
€1.1M
over the period
Gross margin
62%
of revenue
Profit
€16k
1.4% of revenue
Current cash
€22k
end of September
Cash under control: it stays above the alert threshold over the next 3 months.
- Actual
- Forecast (3 months)
- Alert threshold
View the data as a table
Which channel brings leads at the best cost?
Pick a channel, period or metric: charts and KPIs recalculate.
Visits
21,615
over the period
Leads
763
≈ 137 customers won
Conversion rate
3.5%
visits → leads
Cost per lead
€64
€49k spend
Key takeaway: Email brings in the cheapest leads (€9), LinkedIn Ads the most expensive (€149). Before moving budget, check that the channel can scale and that its leads actually turn into customers.
View the data as a table
Demo on sample data. The data is made up; the approach is the one I use on real projects: the same KPIs, the same consistency checks. Typical engagement: a dashboard pack for weekly reviews.
The context
The numbers are spread across several files, every report is rebuilt by hand and nobody looks at quite the same data. Meetings debate the numbers instead of making decisions. My goal: one source of truth, up to date without copy-pasting, that the team actually uses.
How I built it
-
Scoping
Which decisions should the dashboard support? I pick the KPIs with the managers, no more than eight per view.
-
Data
I connect, clean and model the sources: Excel, CRM, ERP, SQL databases, APIs.
-
Prototype
A first clickable version, tested on your real numbers.
-
Delivery
Go-live, automatic refresh, mobile view, PDF export for the meeting and team training.
Before and after
Before
- Several files, several versions of the numbers
- Manual preparation before every meeting
- Debates about whether the data was right
After
- One shared dashboard
- Data refreshed automatically
- Meetings focused on decisions
What it changes
One shared source of truth. No more copy-pasting to update. Shorter weekly reviews, focused on decisions.
What about your business?
Already using Excel or Microsoft 365? That is often enough to get started. I start from your files and tools, and only recommend a licence or a new tool if it pays for itself.
Need something similar? Write to me.
Tell me about your project