MKG Power BI dashboard
We load order, production and inventory data from MKG ERP into a single Power BI model. For Fokker Services Group, we linked ERP data to market data.
We developed a single central dashboard for Fokker Services Group that connects its ERP system to external marketplaces
Price, stock and market information was gathered manually from different sources. We brought this data together with the ERP system in a single view, so staff can get an up-to-date picture of each part with one click.
Is this order earning us what we projected?
MKG records orders, production, hours and materials. If you want to see where estimated and actual figures differ for each order, product or client, or how reliably deliveries are made, you can bring that data together in your own model.
Quotation, sales order, production and delivery in one model
Estimated vs actual costs
Hours and materials for each production order compared with the estimate, so you can see which products are losing margin.
Order book
Outstanding sales orders by customer and delivery week, alongside available workshop capacity.
On-time delivery
The share of orders dispatched on the promised date, by customer, product and department.
ERP alongside other sources
Just as we linked ERP data to market data for Fokker Services Group, we bring MKG together with your other systems.
The production order is the starting point; the chart comes later
-
Access and setup
MKG Exchange and an API key, plus the fields and operations you use.
-
A few orders recalculated
The actual costs of a handful of orders calculated in the model, compared with what MKG itself shows.
-
Expand and refresh
All orders and historical data, permissions by department, and a scheduled data load outside production hours.
Does MKG already have enough reporting built in?
A good fit if
You want to compare actual costs, delivery reliability and revenue over time, bring in data from other systems, or someone currently creates an Excel spreadsheet from MKG every week.
Not a good fit if
The reports in MKG answer your questions, and no one needs comparisons over time or with other sources. In that case, a separate model adds little.
What determines the scope
Which MKG version and modules you have, whether you already have MKG Exchange, how many other sources will be included and who will manage the model.
Does the API cost extra?
According to MKG, using the API requires an MKG Exchange licence, with costs depending on usage. You arrange that with MKG; we’ll tell you upfront what the model needs from it.
Reports in MKG, an export or a model via the REST API?
Reports in MKG
Choose this if you mainly want to see where things stand today. Everything stays in the ERP system where planning and the workshop already work.
An export to Excel
Choose this if you run an analysis now and then. Exporting and combining the data each time remains manual work.
A model via the API
Choose this if you want to compare results over time or include other sources. Our advice: start with actual costing, as that’s often where the biggest question lies.
We worked with ERP data for the aviation and manufacturing industries
Data Science Lab has been building data platforms and dashboards since 2016, as a Microsoft Partner and Databricks Partner. We worked with ERP data for Fokker Services Group and built Power BI dashboards for Ammega.

Where margin is being lost is the first thing we’ll discuss
Stef Stoelwinder
Business DevelopmentStef is your point of contact. In our first conversation, we’ll discuss how MKG is running in your organisation and which production figures you’re missing.
E-mail info@datasciencelab.nl
Phone +31 (0)20 3636 724
Which production question would you like to answer with numbers first?
Tell us which version of MKG you use and what other systems you have alongside it. We’ll reply by email, or we can arrange an initial conversation.
Message sent
Thanks for your message. We’ll be in touch as soon as possible.
Frequently asked questions
Through the MKG REST API. According to MKG, API version 3 is available from MKG version 76, while API version 1 is being phased out. We load the data at set times and build the MKG Power BI model on top of it.
To learn where to start with a dashboard, see Power BI dashboards.
According to MKG, you need an MKG Exchange licence and an API key. We request a dedicated key with read-only access to the data the model needs.
Together with your MKG administrator, we determine which data that is.
The MKG API covers sales orders, production orders, purchase orders, stock, items, bills of materials and business contacts, among other things. Which data we need depends on your questions.
Custom fields and the way transactions are recorded vary by company, so we map those out first.
Estimated versus actual costs by order and product, the order book by delivery week, on-time delivery by customer, stock and lead times, and revenue and margin by customer or product group.
For more on stock specifically, see the stock dashboard.
Yes, if they are recorded against production orders. We can then compare recorded hours with estimated hours for each operation, so you can see where the difference arises.
If hours are recorded outside MKG, we include that source too.
We load data outside production hours and, where the API allows it, only load what has changed. That way, the shop floor is unaffected.
We agree on the loading time with your MKG administrator.
Yes. If you use Isah, read about the Isah Power BI dashboard. Ridder iQ and SAP Business One are also covered in our Power BI dashboards.
The approach is the same: first the configuration, then the model.
If the reports in MKG already answer your questions. Or if hours and materials are not consistently recorded against orders: in that case, data quality is the first step.
We’ll tell you that upfront.