Dashboards
We build clear dashboards for your data and workflows.
From raw data to a useful view.
Fictional example: a small online retailer sees that April revenue is 40% below the monthly average.
- SourcesFive monthly values arrive as EUR amounts and API cents from three sources.
- Organize & checkMonths are ordered; API cents are converted to EUR.
- Metrics & rulesThe total, monthly average, and April difference use the same values.€500,000 revenue, €100,000 monthly average. April: €60,000, 40 percent below average.
- DashboardFive revenue values build bars and the monthly-average line.
- Use as a teamThe April value becomes a concrete review cue.Decision: Review April. €60,000 revenue, 40 percent below the monthly average. Review revenue by product and channel.
View source data and formulas
| Month | Source | Raw value | Unit | Revenue in EUR | Raw fields |
|---|---|---|---|---|---|
| January | FILE | 100,000 | EUR | €100,000 | month=Jan · revenue_eur=100000 |
| February | FILE | 110,000 | EUR | €110,000 | month=Feb · revenue_eur=110000 |
| March | API | 12,000,000 | cents | €120,000 | month=Mar · revenue_cents=12000000 |
| April | API | 6,000,000 | cents | €60,000 | month=Apr · revenue_cents=6000000 |
| May | TOOL | 110,000 | EUR | €110,000 | period=May · amount=110000 · currency=EUR |
Calculation: €100,000 + €110,000 + €120,000 + €60,000 + €110,000 = €500,000 revenue. €500,000 ÷ 5 = €100,000 monthly average. April is €40,000 lower; (€60,000 − €100,000) ÷ €100,000 = −40 percent.
Decision: Review April. €60,000 revenue, 40 percent below the monthly average. Review revenue by product and channel.
What it includes
A dashboard is more than charts. Most of the work goes into reliable data and clear definitions.
Connect data sources
Excel and CSV files, databases, APIs, and exports from the software you already use.
Prepare the data
Unify formats, detect duplicates and gaps, and refresh values automatically.
Define the metrics
Agree on what each number means and how it is calculated, documented and verifiable.
Design the views
Filters, time ranges, and detail views for the questions your team actually asks.
Typical uses
Examples of questions a dashboard answers well.
Revenue & sales
Trends by month, product, or channel, and deviations from plan.
Operations & orders
Open items, lead times, and bottlenecks at a glance.
Projects & resources
Progress, budget, and capacity across several projects.
Inventory & purchasing
Stock levels, coverage, and reorder needs from inventory and supplier data.
What you receive
The result is a tool that keeps running without manual work.
A working dashboard
Used in the browser, hosted by you or on a server of your choice.
Documented metrics
Every number with its definition, source, and calculation.
Automatic updates
Data is fetched and checked regularly, with no manual copying.
Onboarding
Your team learns the views. Later adjustments remain possible.