01
Source audit
CRM, accounting, Excel exports: we inventory what exists and what is missing.
N°05 · UNIVERSE[ FIRST DASHBOARD IN 4 WEEKS ]
Reliable numbers to decide on, every morning.
Your sources combined and refreshed every night, readable dashboards, useful alerts: you decide on numbers, not gut feeling.
4
WEEKS FOR A FIRST DASHBOARD
1
SOURCE OF TRUTH
0
MANUAL DATA ENTRY
First dashboard from CHF 9,500 · indicative starting price, quote after the discovery call
- HubSpot
- Sage
- Shopify
- Excel
REVENUE THIS MONTH€412,30096% of target
GROSS MARGIN38.2%+1.4 pts
REVENUE BY COUNTRY
3 customers paying after 45+ days
UPDATED 06:00 · 4 SOURCES
1 SOURCE OF TRUTH
0 MANUAL EXPORTS
FIG. 05 · EXAMPLES2 · ServicesN°05
Dashboards for SMEs in Switzerland
N°01
Pipelines & centralisation
N°02
Dashboards & reporting
N°03
Quality & governance
N°04
KPIs & alerts
S2b · IN DETAILN°05
Dashboards for SMEs: what you get
Dashboards and reporting for SMEs in Switzerland, by a freelance developer based in Mies (Vaud). Your sources, CRM, accounting, web, Excel exports, are brought into one clean base and refreshed every night, so your decisions rest on up-to-date figures rather than copy and paste.
The offer is for managers and teams who spend hours consolidating files, who get two different figures for the same question, or who discover a problem once it has already cost money. It is also for those who have a tool like Power BI but not the clean data to feed it.
You get a single source of truth with shared definitions, pipelines that collect data with no manual entry, dashboards readable by role, and alerts on the thresholds that matter. A first dashboard starts from CHF 9,500 and is delivered in four weeks.
The project runs in six steps: source audit, data model, pipelines, dashboards, team autonomy, then follow-up. Your teams read and use the dashboards without me. Every month, a report checks data freshness and quality and suggests new indicators.
I work remotely and by video call across Switzerland and France, and on site in Geneva by appointment, when the project requires it and as far as possible.
YOUR QUESTIONS
What is a data consultant?
A data consultant helps a company turn its data into decisions: listing the sources, making the figures reliable, building the dashboards and training teams to read them. When the consultant is also a developer, they automate the collection, so the figures update on their own, every night.
How much does a dashboard cost?
A first dashboard starts from CHF 9,500 and is delivered in four weeks, source audit and pipelines included. The price varies with the number of sources to connect, the state of the data and the number of dashboards per role. The exact scope is set in a scoping workshop.
Power BI or a custom dashboard?
Power BI or Looker fit when your teams already work in them and the data is clean. A custom dashboard makes sense when it must sit inside your application or follow specific business logic. Either way, most of the work is making the data reliable upstream.
How do you make your data reliable?
Start by listing the sources and setting a single definition for each indicator. Then remove duplicates, harmonise formats and automate collection, so no one copies and pastes any more. Regular quality checks, reviewed every month, keep the data reliable over time.
How long does it take to build a dashboard?
A first dashboard is delivered in four weeks: source audit, data model, nightly pipelines, then the dashboard itself, readable by role. The timeline depends mostly on the number of sources and the state of the data; clean CRM and accounting exports shorten it.
S3 · The MethodA → Z
The method, step by step
“Projects change. The method never does.”
02
Data model
A clean base, shared definitions: the “true number” becomes unique.
03
Pipelines
Automated collection every night: nobody copy-pastes anymore.
04
Dashboards
The right numbers, readable at a glance, for every role.
05
Team autonomy
Your teams read and use the dashboards without me.
06
Care & reporting
A report every month: freshness, quality, new indicators.
MONTHLY REPORT · EXAMPLE · Data & Decisions · SEPTEMBER 2026
12
SOURCES CONNECTED
24 H
MAX DATA FRESHNESS
0
MANUAL EXCEL EXPORTS
INCIDENTS: 0 · NEXT ACTIONS: 3
SENT 01.10 · GD
A report like this one, every month, in your inbox.
THE METHOD LEADS HERE.
S4 · How I work01 → 05
How I work
01Scoping
Goals, scope, budget: everything in writing.
02Architecture
Documented, justified technical choices.
03Development
Short sprints, a demo every Friday.
04Production
Automated tests, continuous deployment and alerts from day one.
05Observability
Errors, slowdowns and usage tracked continuously: problems show up before anyone reports them.
S5 · The stack5 TOOLS
The stack
The stack that turns scattered sources into reliable numbers.
PythonPostgreSQLdbtPower BILooker
S6 · ProofMIES, VD · CH
Why trust me with your project
EXHIBIT NO.1 · ORIZN
Co-founder and CTO of Orizn: your project gets the standard I hold my own product to.
01
A tooled process: automated tests, monitoring and a monthly report. Nothing relies on memory.
02
Your data stays protected: GDPR & Swiss FADP by default.
03
Based in Mies (Vaud), between Geneva and Lausanne. Remote across Switzerland, France and beyond. Reply within 24 business hours.
SAMPLE ENGAGEMENT
An outdoor gear brand selling online in six countries: the Monday Excel report replaced by a per-country dashboard, up to date every morning at 6 am.
S7 · ContactMON TO FRI 9 AM TO 7 PM · SAT 9 AM TO 6 PM · SWISS TIME · REPLY WITHIN 24 H
Let’s talk about your project.
Book a free discovery call
45 minutes, free, no strings attached. We talk about your project and you leave with an honest opinion, whether we work together or not.
NEXT AVAILABLE SLOTS · LIVE
MON TO FRI 9 AM TO 7 PM · SAT 9 AM TO 6 PM · SWISS TIME · REPLY WITHIN 24 H
S86 / 7