Numbers you can trust.
In most companies the answers already exist – spread across accounting, inventory and three spreadsheets. We turn that into a data model: one source, one sync, one dashboard. Your data stays on your infrastructure.
Where it breaks today
Three symptoms we see in almost every mid-sized company — we do not replace your existing systems, we connect them:
The numbers live in four places
Accounting calculates differently than inventory, and the online shop differently again. Before anyone can make a business decision, they first have to debate which figure is actually true.
Reports are outdated before they are finished
Someone exports CSV files at the start of the month, compiles them, and formats spreadsheets. By the time the report lands on the desk, half the current month is already over.
Nobody can retrace a figure on the spot
When a metric is questioned, people receive a static spreadsheet instead of a transparent derivation. That erodes trust — in the number and in the decision.
How we build it
Data model
One definition of customer, order and revenue – agreed with you, not with a textbook.
Automatic sync
MSSQL, ERPNext and the shop are merged at fixed intervals. No export, no copy-paste.
Dashboards
Metrics that answer a question: what happened, why, and what follows from it.
Privacy
Personal data is pseudonymised. Runs on your infrastructure, encrypted backups.
Early warning & forecasting
Statistical models analyze historical patterns to flag churn risks (Churn Radar), capacity bottlenecks, or revenue anomalies early.
Sovereign Cloud & Cold-Spare
Resilient operation managed by our team, including real-time Proxmox Backup Server (PBS) replication and cold-spare failover hardware.
A fitness studio chain in Bavarian Swabia. Member data lived in MSSQL, sign-ups at the studio desk, cancellations in the branch manager's head.
We built background workers and an ETL pipeline that moves data from POS terminals, MSSQL, and web registrations into a dedicated model every hour, pseudonymises personal fields with SHA-256, and renders a predictive churn radar inside a fast Astro BI dashboard: which members are likely to cancel in the coming weeks, and in which branch?
Explore the full architecture in our Fitness Studio Astro BI case study. The client is not named; we do not quote numbers we cannot prove.
Do you want to know which number is true?
In a free 30-minute initial check we inspect your existing data sources (e.g. DATEV, ERP, POS, SQL, or spreadsheets) and give you a fixed budget range up front (Astro BI dashboards start from €3,000 one-time, ongoing BI care from €290/month or platform hosting from €79/month).