Skip to content

Power BI specialist in Tilburg

We build a single Power BI model in which the online shop, ERP and finance all show the same revenue. This lets every department at Vivara analyse the same data.

For Vivara, we load data from SAP, Magento and SharePoint into a single data model for all departments every day

With a custom-built data model, every department at Vivara, from finance to marketing, analyses the same data at the level it needs, using Power BI.

Read the case study

Why does the online shop show different revenue figures from finance?

The online shop counts orders, the ERP system counts invoices and returns, and marketing looks at campaigns. Each team is right according to its own source. One model with consistent definitions brings them together into a single revenue figure.

Book a call

Webshop, ERP and campaigns in one model, with a dedicated view for each department

Discuss your reporting

One revenue figure for everyone

Orders, invoices and returns use one consistent definition, so finance and the webshop see the same figure.

Margin by product and channel

Webshop sales alongside purchase prices and stock from the ERP, broken down by product, channel and country.

The right level of detail for each department

As at Vivara, finance looks at the overall figures and marketing at campaigns, using the same model.

Reports and an app

For Ammega, we built Power BI dashboards and an app together with people from across the organisation.

We agree on the definition of revenue before creating a single chart

  1. Definitions agreed with the teams

    We agree with the finance, online store and purchasing teams on what revenue, margin and returns mean.

  2. One report verified

    The first report is checked against the figures the finance team currently reports.

  3. Updated daily

    More departments use the same model, with role-based access and a designated owner.

Is an external Power BI specialist the right step now?

Talk it through with us

A good fit if

Your online shop, ERP system and finance team each report a different revenue figure, Excel spreadsheets circulate between departments, or existing reports are slow and nobody dares change them.

Not a good fit if

You have one data source, and the standard reports in your software answer your questions. In that case, a custom model is more than you need.

What determines the scope

How many data sources and departments are involved, whether the data is already in the cloud, how often it needs refreshing and who will manage the model afterwards.

Can we manage it ourselves afterwards?

Yes. We document the definitions, model and refresh process, then hand everything over. If you would rather not manage it yourselves, we can continue to do so.

Reports in the webshop and ERP, a standalone Power BI file or a shared model?

Reports in each system

Choose this if each team mainly looks at its own data source and nobody needs to compare figures.

A standalone Power BI file

Choose this if one team needs to answer one question. With more teams, different versions of the same figure quickly emerge.

A shared model

Choose this if several departments need to work with the same revenue and margin figures. This is what we recommend when both the webshop and ERP matter.

We built a data model for every department in retail and industry

Data Science Lab has been operating since 2016 and is a Microsoft Partner and Databricks Partner. We built Vivara’s data platform and Power BI dashboards for Ammega, and share what we learn at our Techdays.

Book an introductory meeting

First, we’ll discuss which figures differ between departments

Stef Stoelwinder

Stef Stoelwinder

Business Development

Stef is your point of contact. In the first conversation, we’ll discuss which data sources are available and which figures differ between departments.

What figure do your departments disagree on right now?

Tell us which online shop, ERP system and reports you currently have. We’ll reply by email or arrange an initial conversation.

Enter a valid email address.

Let us know how we can help you.

Frequently asked questions

A Power BI specialist or Power BI consultant brings your data sources together in one model, defines what each figure means and builds the reports your teams use. This page is for organisations in Tilburg and Brabant with a webshop and an ERP system.

Read how we set up Power BI on our Power BI consultant page.

No. We work from Amsterdam, on Westerdoksdijk. We work online with organisations in Tilburg and the rest of Brabant, and visit for sessions with their teams.

Vivara, the client in the case study, is not based in Tilburg.

Because they count different things. The webshop counts orders when they are placed; finance counts invoices after delivery and returns. Both figures are correct. In the model, we define which revenue figure you use for each purpose.

That ends the debate about which number is right.

Most webshops and ERP systems, as well as Excel and SharePoint. For Vivara, we load data from SAP, Magento and SharePoint daily. Many software packages have their own page among our dashboards.

Read more about Power BI dashboards.

The model is usually refreshed every night, so everyone starts the morning with the same figures. It can be refreshed more often where needed.

How often depends on the decisions those figures inform.

No. With row-level security, each team sees only what it needs, such as its own channel or country, while finance and management see the full picture.

We set access rights by role.

Yes. If you want someone to work in your team for a period, read about hiring a BI consultant.

This page is about building the model as a project.

Those pages cover models built on image and measurement data, and language models. This page is about reporting: bringing sources together and making sure everyone interprets the figures in the same way.

See data science agency in Tilburg and AI agency in Tilburg.