Skip to content

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.

Read the case study

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.

Book a call

From quotation to invoice and from purchasing to inventory: KING data in one model

Discuss your KING figures

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

  1. Map the installation

    On-premises or KING ERP Online, which modules and integrations are running, and who administers the system.

  2. Validate one process

    For example, compare monthly orders and margins in the model with the reports in KING itself.

  3. 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?

Talk it through with us

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.

Book an introductory meeting

In our first conversation, we’ll discuss how KING works for you and what’s missing

Stef Stoelwinder

Stef Stoelwinder

Business Development

Stef 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.

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.

Enter a valid email address.

Let us know how we can help you.

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.