Skip to content
Tovy
Get a free assessment

Data Warehouse and Reporting for SMEs

Your data is spread across your ERP, your online store, your warehouse system and your accounting. If you want to know how your inventory, margins or lead times are doing, someone starts with exports and Excel. By the time the overview is ready, it's already out of date.

I bring your data together in one central data warehouse, updated automatically. On top of it I build dashboards and reports you can rely on, so you make decisions based on numbers instead of gut feeling.

  • No more exports and Excel work for your recurring reports
  • A single source of truth
  • Up-to-date insight into inventory, margins and customer data
Get a free assessment

7 short questions, about 3 minutes. Then you pick a time for a free call.

Sound familiar?

  • Every month or week you lose hours to exports, copying and pasting in Excel.
  • Two reports give a different answer to the same question, and nobody knows which one is right.
  • You only find out afterwards that a product is no longer profitable or that stock has been sitting too long.
  • Reporting depends on one colleague and one spreadsheet that only they understand.
  • You want to combine what's in different systems, such as sales from your online store with purchasing from your ERP, but that only works with manual work.

Sound familiar? Then reporting is currently costing you more time than it delivers.

What you'll notice

  • No more exports and Excel work for your recurring reports.
  • A single source of truth. Everyone looks at the same numbers.
  • Up-to-date insight into inventory, margins and customer data.
  • You spot trends and anomalies earlier, instead of afterwards.
  • Everything documented, so you can always look up how a number is calculated.

What I set up for you

  • One central place for your data. Data from your ERP, online store, WMS, CRM and accounting comes together automatically in a data warehouse.
  • Consistent definitions. What is revenue, what is margin, when is an order delivered? We define that once, so every report gives the same answer.
  • Dashboards and reports. An up-to-date overview of inventory, margins, sales and customer data, for example in Power BI.
  • Automatic refresh. The data is updated on a fixed schedule, depending on the use case.
  • Secure by design. Access control, encryption and backups, so everyone only sees what they need.

I work with tools including BigQuery, Databricks, SQL databases and Power BI. Which tools fit best depends on your systems and your budget.

Figures you can steer by

A dashboard is only useful when it answers the questions you ask every week. In the supply chain, these are often the ones.

  • Inventory turnover. How fast does your stock turn, per product or product group?
  • Slow-moving stock. Which items have been sitting still for months and are costing you money?
  • Delivery reliability. How many orders do you deliver complete and on time?
  • Lead time per supplier. Which supplier delivers late, and how often?
  • Margin per product and channel. Where do you really make money, and where don’t you?
  • Stock below minimum. A signal before a product sells out.

Which figures matter for you, we decide together in the analysis.

Do you actually need a data warehouse?

Honest advice first. Do you work with one system and a few fixed reports? Then a dashboard directly on that system is often enough. In that case, that's what I'll recommend.

A data warehouse pays off when

  • you want to combine data from multiple systems;
  • reporting currently takes a lot of manual work or reports contradict each other;
  • you want to keep history that your source systems don’t keep (long enough);
  • you want to grow towards better forecasting, such as inventory planning.

Not sure? In the introductory call you’ll hear right away what makes sense in your situation.

How I work

  1. Introduction. We discuss which questions you want to answer with your data and which systems you use. Free and without obligation.
  2. Analysis and proposal. I map what you want to see, how it’s calculated and where it comes from. You get a concrete proposal with a price.
  3. Build and verify. I set up the data warehouse, connect your sources and build the first dashboards. Together we check the numbers against what you know today, so you can trust them.
  4. Go-live and management. I show your team how to use the dashboards. After go-live I keep an eye on the data processing. If a source system changes or you want a new report, I adjust it.

What does a data warehouse cost?

You pay a fixed project price. Most projects fall between €1,000 and €5,000 (excl. VAT), depending on the number of sources and reports. After that you can choose fixed monthly management of €150 to €500 (excl. VAT) for monitoring, maintenance and adjustments.

On top of that you pay the cost of the platform itself, such as cloud storage or Power BI licences. For an SME these are often limited; you’ll see them listed separately in the proposal.

After the introductory call you’ll get a clear price estimate. No surprises. See all pricing

Why Tovy

  • One point of contact. You work directly with the engineer who builds your data warehouse. No account managers or middle layers.
  • Supply chain, not just finance. With a background in business administration and supply chain management, I look beyond the annual figures, at inventory, lead times and margins per product.
  • Independent of any single package. I combine data from whichever systems you use.
  • Based in Breda. I work with SMEs. Anywhere in the Netherlands or the EU. Often remote, but also on site when the travel distance is reasonable.
  • Documented and transferable. Everything I build is documented, so you stay in control.

More about me

Real-world examples

Lamb Weston

Lamb Weston

Former employer

Making SAP data available to another system

Fewer errors and a consistent way of working, because everyone works with the same data.

FAQ

Frequently asked questions

What's the difference between a data warehouse and a dashboard?

A dashboard shows numbers. A data warehouse is the central source of those numbers, cleaned and combined from all your systems, with history. A dashboard on top of a data warehouse gives the same answer everywhere.

Do I have to stop using Excel?

No. Excel is still useful for your own analyses. The difference is that you no longer have to collect the data by hand. You pull it straight from the data warehouse.

How long until I have my first dashboard?

Usually within 2 to 4 weeks, depending on the number of sources. After the analysis you'll know exactly where you stand.

Is my data secure?

Yes. I set up access control, encryption and backups, and where required your data is stored in the EU.

Who owns the data warehouse?

You do. It runs in your environment and you get the documentation and access to the code.

Do I need technical knowledge?

No. I explain everything in plain language and take care of the technical side. You tell me how your business works and where things get stuck.

Services

What I build and manage for you

Curious what your data could tell you?

Tell me briefly which questions you can't answer quickly today, and I'll take a look.

Giel Nijkamp, Automation & integration engineerGiel NijkampAutomation & integration engineer
Get a free assessment

7 short questions, about 3 minutes. Then you pick a time for a free call.

Pricing