Skip to content

Infor CloudSuite Power BI dashboard

We bring CloudSuite data from Infor Data Lake into a dedicated layer and build Power BI on top of it. That’s how we created a data platform for Agro Care.

For Agro Care, we’re building a data platform that brings all data together for BI and data science

Agro Care is taking significant steps towards working in a more data-driven way. We’re building a scalable, stable data platform with a data warehouse, so all data is stored centrally and is easily accessible for BI and data science.

Read the case study

Our ERP data is in the cloud, but how do we get it into our own reports?

With Infor CloudSuite, your data is held by Infor, and Infor Data Lake provides access to it. To view orders, production and financial data alongside data from other systems, bring it into your own layer beneath Power BI.

Book a conversation

CloudSuite data in your own model, alongside everything outside Infor

Discuss your ERP figures

Orders and delivery

Sales orders, delivery reliability and outstanding orders by customer and site, all in one view.

Production and inventory

Production orders, inventory by location and lead times, so planning and procurement have the same view.

Finances by unit

Revenue and margin by business unit or country, even if not every unit is in the same Infor environment.

One place for BI

Just as we make all data centrally available for BI for Agro Care, CloudSuite sits alongside your other sources.

First, a route out of Data Lake, then the reports

  1. Access via ION API

    Work with your Infor administrator to establish the credentials and identify the tables in Data Lake that the model needs.

  2. A dedicated layer

    Data loaded and cleaned at scheduled times, with one definition for each term.

  3. Power BI on top

    Reports for each department based on the same model, with access permissions by site or unit.

Aren’t Infor’s own analytics enough?

Talk it through with us

A good fit if

Your organisation already uses Power BI, you want to view Infor data alongside data from other systems, or not every business unit uses the same Infor environment.

Not a good fit if

All your questions concern data in Infor, and Infor’s own reporting is sufficient. In that case, a second layer creates more work than value.

What determines the scope

Which CloudSuite components you use, how many tables you need in Data Lake, which other sources you include and who manages the layer.

Can we write data back?

Not this way. Infor Data Lake is read-only. If data needs to go back into the ERP, that happens through Infor’s own integrations.

Infor reporting, standalone queries or your own layer beneath Power BI?

Infor reporting

Choose this if your questions can be answered in Infor and your team already uses it. There’s no additional layer to manage.

Standalone queries on the Data Lake

Choose this if someone with SQL skills is doing a one-off analysis. For regular reports, it quickly becomes hard to keep track.

Your own layer

Choose this if you need to combine Infor with other sources and Power BI is your standard. Our advice: load only the tables needed to answer a question.

We’ve been building data platforms that power BI and data science since 2016

Data Science Lab has been building data platforms and dashboards since 2016, as a Microsoft Partner and Databricks Partner. For Agro Care, we’re building a data platform with a data warehouse for BI and data science.

Book an introductory meeting

Your Infor environment is the first topic we’ll discuss

Stef Stoelwinder

Stef Stoelwinder

Business Development

Stef is your point of contact. In our first conversation, we’ll discuss which CloudSuite components you use and which figures you’re missing.

Which question about Infor would you like to answer in Power BI first?

Tell us which CloudSuite you use and what other systems you 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

Through Infor Data Lake. Infor provides the Compass query editor, Compass APIs and a Compass JDBC driver for querying Data Lake with SQL. We load the data through these tools into a separate layer at scheduled times, then build the Infor CloudSuite Power BI model on top of it.

For where to start with a dashboard, see Power BI dashboards.

It is the storage within Infor OS where data from CloudSuite applications is held. You can query it with SQL, but you cannot change or delete data there.

That makes it a suitable source for reporting, but not a place to write data back to.

Access through ION API, using a credentials file created by your Infor administrator. We ask for an account with read-only access to the tables the model needs.

We determine which tables those are together with the administrator.

We did not find an official Infor guide for a direct Power BI connection. That is why we first load the data into a separate layer. This makes refreshes predictable and lets you combine Infor with other sources.

For how we set up such a layer, see data engineering.

Orders and delivery reliability by customer, production and stock by location, purchasing by supplier, and revenue and margin by unit or country. Often, companies also compare sites that still use another system.

What comes first depends on the questions your organisation needs to answer.

We bring the other ERP systems into the same layer, with one definition for each concept, such as revenue or order. That way, you can still compare sites.

If some sites use SAP, read about the SAP S/4HANA Power BI dashboard.

In your own cloud environment, for example on Azure or Databricks. This keeps the data under your control and makes it available to other applications too.

For more on this choice, see data and AI platform.

If all your questions can be answered within Infor using its own reporting tools. Or if the underlying data is not yet reliable: in that case, data quality is the first step.

We will tell you that upfront.