Power BI with data from EazyProject and Business Central.

What is Business Intelligence?

With Business Intelligence (BI), you can transform raw data into meaningful insights that can be used to make better decisions, improve efficiency, and increase competitiveness.

BI consists of four elements that enable data to be visualized from different sources in a clear and interactive way.

• Data Source
  Data sources are the systems from which Power BI pulls data. In this package, we pull data from EazyProject and Business Central. It is possible to add additional data sources as an extension to the package.
  
  
• Integration
  We use integrations to move data into Power BI’s cloud environment. In this package, we use EazyProject’s Web API and an extension to Business Central.
  
  
• Data Storage
  As part of the integration, data is transformed, and a series of calculations are added. Data is stored in Power BI’s cloud, which is located on servers in the EU.
  
  
• Visualization
  We use Microsoft Power BI as our visualization tool. Here, it is easy to expand with additional dashboards as an extension to the package. You also have the option to work further with data in Excel, where you can use the data model from Power BI as a cube.

How We Do It

1 Kickoff Meeting
We start with a kickoff meeting, where we go through the process and clarify how we will access your system. We will also identify who will be your technical contact for us.

2 Integration Between Power BI, EazyProject, and Business Central
We set up the data connection between Power BI, EazyProject, and Business Central, ensuring that your data flows correctly and is displayed accurately. The data module is based on fields that are standard in both your EazyProject and Business Central systems.

3 User Creation
We create the Power BI users who will need access to the Power BI dashboard package and set up your designated administrator. We also assist with setting up a workspace for Power BI.

4 Delivery and Introduction
We hand over the solution to you, along with a brief introduction on how to use the system (1 hour). If additional training or configuration of further analyses or functional areas is required, this can be arranged afterward. We retain our admin access so we can continuously update the system.

Package Expansion

It is possible to expand the package with additional data sources, calculations, and dashboards.

Contact us so we can discuss the available options, and we can determine whether it’s something you can handle yourself or if it’s something we should assist with.