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.
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.
Webshop, ERP and campaigns in one model, with a dedicated view for each department
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
-
Definitions agreed with the teams
We agree with the finance, online store and purchasing teams on what revenue, margin and returns mean.
-
One report verified
The first report is checked against the figures the finance team currently reports.
-
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?
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.

First, we’ll discuss which figures differ between departments
Stef Stoelwinder
Business DevelopmentStef is your point of contact. In the first conversation, we’ll discuss which data sources are available and which figures differ between departments.
E-mail info@datasciencelab.nl
Phone +31 (0)20 3636 724
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.
Message sent
Thanks for your message. We’ll be in touch as soon as possible.
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.
Looking for more on Power BI, dashboards or data science in Tilburg?
- Power BI consultantHow we set up Power BI, from the semantic model and workspaces to refresh and management.
- Power BI dashboardsHow a report is built around the decision it needs to support.
- Data science consultancy in TilburgModels using camera images and measurement data for organisations in Tilburg and Brabant.