King Business Software Power BI dashboard
We bring orders, inventory and margins from KING ERP together in one Power BI model. For Fokker Services Group, we connected an ERP system to market data.
For Fokker Services Group, we developed a single central dashboard that connects its ERP system to external marketplaces
Staff used to gather pricing data, stock levels and market information by hand. Now all relevant pricing, market and logistics data comes together in one overview.
How can we see orders, stock and margin from KING on one screen without exporting data every week?
KING ERP records purchasing, sales, stock, production and projects. If you want to manage by product group, customer or branch, or view KING data alongside your online shop or budget, you need to put the data into your own model.
From quotation to invoice and from purchasing to inventory: KING data in one model
Order backlog
Quotations, outstanding orders and deliveries by customer and product group, with the margin for each order line alongside.
Inventory and reorder recommendations
Inventory value by warehouse, items that are not moving and what KING recommends ordering.
Projects and job sheets
Weekly timesheets and job sheets showing hours and costs by project, alongside what has been invoiced.
ERP alongside other sources
Just as we connected Fokker Services Group’s ERP system to marketplaces, we put KING alongside your online shop or budget.
The first step depends on how your KING system is set up
-
Map the installation
On-premises or KING ERP Online, which modules and integrations are running, and who administers the system.
-
Validate one process
For example, compare monthly orders and margins in the model with the reports in KING itself.
-
Expand and manage
Add inventory, projects and financial data, set a regular refresh time and assign access rights by department.
Does a Power BI model add anything to KING’s own dashboards?
A good fit if
You want to see KING data alongside a webshop, a third-party WMS, budgets or plans; you compare branches or companies; or you currently build reports in Excel every week.
Not a good fit if
The dashboards in KING answer your questions, and nobody needs to compare the figures with other sources. In that case, you don’t need a second place for your figures.
What determines the scope
How KING is set up in your organisation, which modules are involved, how many companies or branches there are, which other sources you want to include and who will manage the model.
Is there a public API?
We couldn’t find any public documentation for a KING API. How you access the data varies by installation, so we’ll work that out with your administrator before building anything.
The dashboards in KING, an app from the KING App Store, or your own model?
Dashboards in KING
Choose this if you mainly use KING to track ongoing processes. KING ERP highlights its clear dashboards for seeing what’s happening now.
An app from the App Store
Choose this if there’s already a ready-made app for what you need. You’ll only see what that app shows you, though.
Your own Power BI model
Choose this if you need to bring together multiple sources or companies. Our advice: start with one process, such as orders and margin, then expand.
We've brought ERP data together with other sources for organisations large and small
Data Science Lab has been building data platforms, models and dashboards since 2016 as a Microsoft Partner and Databricks Partner. For Fokker Services Group, we connected its ERP system to external marketplaces in a single dashboard.

In our first conversation, we’ll discuss how KING works for you and what’s missing
Stef Stoelwinder
Business DevelopmentStef is your point of contact. In our first conversation, we’ll discuss how KING works for you, which modules you use and which reports you currently create in Excel.
E-mail info@datasciencelab.nl
Phone +31 (0)20 3636 724
Does KING run on your own server or online?
Tell us how you use KING and which processes you’d like to see first. 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
King Business Software merged with MUIS Software and ctrl to form KING Software, which has been part of the Swedish Björn Lundén group since 2022. The ERP system is now called KING ERP, with KING ERP Online as its online version. If you search for King Business Software Power BI, this is usually the software you mean.
For guidance on which questions a dashboard should answer first, see Power BI dashboards.
KING ERP lists costs, revenue, purchasing, sales, inventory management, production, projects and invoicing, as well as quotes and orders, purchasing recommendations, work orders, a CRM and its own WMS. Which of these you use determines what can go into the model.
We start with the process that currently involves the most manual work.
That depends on your installation. KING ERP is installed on-premises; with KING ERP Online, the provider handles updates and maintenance. We could not find public API documentation, so we work out the approach with your administrator and KING.
Once access is in place, we build the data-loading step and the model.
The KING App Store offers software and services that connect to KING, including apps for management reporting. An app like this is quick to set up, but shows what its developer has chosen to include.
A custom-built Power BI model takes more work to set up, but combines KING with any other source and follows your own definitions.
Trading companies look at margins by customer and product group, and at stock that is not moving; see the inventory dashboard for more. Service providers track hours and costs by project; see the project dashboard.
Manufacturers compare orders with production plans and actual costs.
By defining in advance what revenue, margin and stock value mean in the model, then comparing the figures each month with the reports in KING. We show differences caused by, for example, deliveries that have not yet been invoiced separately.
We set up departmental access rights and the refresh schedule as described under Power BI consultant.
Yes. Each company or location has its own identifier in the model, with a shared structure for product groups and accounts. This lets you see them separately and together without mixing up the figures.
Where the structure differs between companies, we create a mapping table that you can maintain yourselves.
When the dashboards in KING or an existing app already answer your question. Or when products, customers and projects have not been recorded consistently: in that case, data quality is the first step.
If an export is enough, we’ll tell you.
Which dashboards should an ERP have for trading, manufacturing and projects?
- Power BI dashboardsWhy every dashboard starts with the decision someone needs to make using it.
- Inventory dashboard in Power BIInventory value, turnover and obsolete stock by location, using data from an ERP, WMS or point-of-sale system.
- Project dashboard in Power BIHours, costs, progress and margin per project, alongside the budget.