coresmith.dev
← All services
06 · Data & dashboards

The numbers that say whether the thing works, in one place

Most businesses are not short of data. They are short of one version of it. Five exports that nobody reconciles is not reporting, it is an argument waiting to happen every month.

What is included

Data model and schema design

The part that decides whether every later question is easy or expensive. Done once, carefully, before it hardens into something nobody dares change.

Reporting dashboards

The handful of numbers a decision actually turns on, updated automatically. Not a wall of charts that everyone stops opening after the second week.

Analytics setup, privacy-first

Measurement that does not require a cookie banner the size of the page. You get the numbers you need and your visitors keep their privacy.

Migration off spreadsheets

Moving the history without losing it, including the special cases hidden in colour codes and comments that no export will carry.

What we build

One dashboard for the business

Revenue, stock, orders and margin in one place, updated on its own, instead of five exports nobody reconciles.

Operational screens for a team

What a warehouse, a dispatcher or a support desk keeps open all day, showing what needs attention right now rather than last month.

Reports that send themselves

The weekly or monthly numbers arriving in an inbox or a chat, in the same shape every time, without anyone assembling them.

Schema and data model design

The decision that makes every later question cheap or expensive, made once and deliberately instead of by accident.

Migration off spreadsheets

Moving the history without losing the meaning hidden in colour codes, comments and one person's memory.

Privacy-first web analytics

Traffic and conversion numbers without a consent banner the size of the page, and without handing your visitors to an ad network.

Who it fits

Companies reporting from memory

If the monthly number depends on who assembled it, the number is an opinion. Making it reproducible is usually a week of work.

Teams with data in four places

Shop, accounting, courier, spreadsheet. Each is right about its own part and none of them agree on the total.

Anyone who does not know what to measure

Starting with the decision rather than the chart. Two numbers you act on beat forty you look at.

Stack

A link beside a group means it is running in production in a project you can read about. The rest is what the team also covers.

Dashboards inside your own product

ReactTypeScriptRechartsTanStack Queryserver-side aggregation

In production: Multi-warehouse retail ERP + POS

Also covered
D3virtualised tables

Ready-made BI, self-hosted

MetabaseGrafanaSuperset

Storage and queries

PostgreSQLMySQLSQLiteindexing and query tuning

In production: Multi-warehouse retail ERP + POS

Also covered
ClickHouseMongoDBRedis

Analytics

Umamiserver-side eventsSearch Console data
Also covered
PlausibleMatomo

Start with the scope conversation. It costs nothing and it is usually one call.