A KPI dashboard with figures you can steer by

A KPI dashboard shows the figures that tell you whether your business is on course: margin per project, unpaid invoices, utilisation, hours against budget. Aziri builds custom KPI dashboards that pull their figures automatically from your ERP, accounting software, planning and work orders, so nobody has to gather them by hand in Excel any more.

Some of our clients

  • Sweco
  • Spaas
  • Itzu
  • Warsco
  • DCM (De Ceuster Meststoffen)
  • Viabuild
  • Van Loo Projects
  • Eddie Stobart
  • Boels Verhuur
  • Moore
  • Zwembaden Bollen
  • ValoDirect
  • Varey
  • Hamster Cleaning
  • A-S-W
  • Alracon

Where it pinches with the figures

What we often hear

  • We fill an Excel file with figures from our ERP to follow up our projects, and someone has to do it by hand every time.

  • Our data is spread over Teamleader, Excel and other sources, so we can't see where we stand against our quarterly target.

  • We want to compare revenue per project in the same app we work in, not in a separate report.

  • A dashboard is nice, but if someone wants a list in Excel, it should be easy to get it out.

What your KPI dashboard shows

  • KPI tiles with a trend

    Each key figure has its own tile, with today's position, the difference from the previous period and a short trend line. You see at a glance what is improving and what is slipping.

  • Margin per project or job site

    What was sold sits next to what has gone into it so far in hours, materials and subcontracting. If a project's margin drops below your target, you see it while the work is still running.

  • Unpaid invoices and their age

    The total your customers still owe you, broken down by how long it has been outstanding. Accounts see straight away which customers need a reminder.

  • Utilisation per week

    How much of the available hours of your people or machines is already planned for the coming weeks. You see in time whether you need to turn work down or bring in extra hands.

  • Drill down to the source

    Click a figure and you see the projects, invoices or hours behind it. Every list can also be exported to Excel.

  • A home screen per role

    The managing director sees the whole picture, a project manager their own projects and accounts the invoices. Permissions decide who sees which figures.

  • An alert when a figure drifts

    You set a threshold per KPI, and the person responsible gets an alert when it is crossed. Nobody has to go and check every day.

Is your process not listed? We also automate inspections, complaints, onboarding, purchasing and any other process that still runs on Excel, paper or email.

Business process automation →

A safety app for site visits

On site visits, Sweco staff filled in a paper safety booklet. Now they do it in an app with a checklist and photos, used by more than 2,000 people across Europe.

Read the case

The choice for a technology is one thing. At the end of the day, people make the difference. (…) Combined with the know-how and experience of Aziri, who have been through the exercise with many customers before, one will see nice results.

Sam Van MuldersBusiness Process Manager, Sweco
2,000+
users of the app in Europe
±700
users in Belgium
95%
of expectations met

What is a KPI dashboard?

A KPI dashboard is a screen that brings together a company’s most important figures, with today’s position and how they are developing. A KPI, or key performance indicator, is a figure that tells you whether you are on course, such as the margin per project, the amount in unpaid invoices or the utilisation of your people. A good dashboard pulls those figures automatically from your ERP, accounting software, planning and work orders, so nobody has to gather them by hand in Excel any more.

Aziri builds custom KPI dashboards around the software you already use. The dashboard can be a separate screen or part of the app your people work in every day.

Which KPIs does a business track?

That depends on how your business makes money. In companies that carry out projects or deliver services with their own people, these figures come up most often:

  • Margin per project or job site: what was sold against what has gone into it so far in hours, materials and subcontracting.
  • Hours against budget: how much of the budgeted hours has already been used, while the work is still running.
  • Unpaid invoices: the total your customers still owe you, and how long it has been outstanding.
  • Work still to invoice: work that has been done but not yet invoiced.
  • Utilisation: how much of the available hours of your people or machines is planned for the coming weeks.
  • Lead time: how long it takes from enquiry to quote, from order to delivery or from work order to invoice.
  • Quotes: how many are outstanding and what share you win.

Start with the five to eight figures you actually make decisions on. A figure nobody acts on makes the screen fuller without making it clearer. So agree for each figure who responds when it drifts.

Power BI or a custom KPI dashboard?

If your data already sits neatly in one system, such as an ERP that is filled in properly, a BI tool like Power BI or the reporting in your package is often enough. In that case we will tell you so. A custom dashboard pays off when the figures are spread over Excel, ERP, planning and work orders and first have to be brought together and cleaned up, or when the dashboard needs to sit in the app your people work in.

Reports in your ERP or accounting software BI tool such as Power BI Custom KPI dashboard (Aziri)
Figures from one system Yes Yes, that is its strength Yes
Figures from Excel, ERP, planning and work orders together No, only what is in the package partly: If someone first brings the data together and cleans it Yes, the integrations and the clean-up are part of it
Letting people enter missing data partly: Only what the package provides No, the tool only shows what is there Yes, in the same app
In the app your people work in partly: Inside the package partly: Embedded, with extra work Yes, next to the project, the planning or the work order
Cost Part of your package licence BI tool licence, often per user From €5,000 for a first version, licence from €1,000 a year

A BI tool shows what is in the data, but it doesn’t fill in what is missing. If hours are still kept on paper, the margin per project won’t be right in any dashboard. In that case we first build the part that gets that data in digitally, such as time tracking or project tracking with actual costing.

Where do the dashboard’s figures come from?

From the systems you already have. We connect the dashboard to your accounting software or ERP for invoices and costs, to your planning for utilisation and to your time tracking or work orders for hours. An Excel list that a colleague keeps can also be a source for now, until that part gets its own place in the app.

Most of the work lies in bringing the data together. A customer is spelled differently in two systems, or a project has a different code in the planning than in the accounts. We do that clean-up once and properly, and after that the dashboard also shows what is missing, such as a project with no hours booked. If you work with Exact Online, see how the Exact Online integration works.

At Sweco, an engineering and architecture firm, early-stage ideas often ended up in Excel or MS Access, because a classic IT project was too heavy. After a first app for site visits, linked to the ERP, came apps for improvement proposals and complaints, among others, and a dashboard for the climate-neutral targets.

A dashboard per role, also on tablet and phone

The managing director wants to see the whole picture, a project manager their own projects and accounts the unpaid invoices. That is why each role gets its own home screen, with the same figures underneath, so everyone in the meeting talks about the same number. Permissions decide who sees what, because not everyone needs to know the margins.

The dashboard runs in the browser, so it also works on a tablet or phone. A project manager checks their hours against budget between two site visits, and anyone who doesn’t want to look every day gets an alert when a figure crosses a threshold. People sign in with the Microsoft account they already have.

What does it cost?

First version in 2 to 6 weeks

How we arrive at a price

From €5,000

for a first version of one process. You can start small and extend; the price depends on the number of processes, integrations and users, preferably at a fixed price. Licence and hosting from €1,000 per year.

Contact us

The figures come from the software you already have

We connect the dashboard directly to your accounting software or ERP, such as Exact Online, Odoo or AFAS, to your CRM, such as Teamleader, and to your planning, hours and work orders. An Excel list that a colleague keeps can also serve as a source to start with. We have already built more than 70 integrations, and an integration between two systems starts from €2,000.

Connects with, among others

Frequently asked questions

Question not listed? Ask us directly.

What does a custom KPI dashboard cost?

A first dashboard with the main figures from your existing software starts from €5,000. Each additional integration between two systems starts from €2,000, and hosting and licence come on top each year, from €1,000. We prefer to agree the build at one fixed price.

How long before the dashboard works?

A first working version is usually ready within 2 to 6 weeks. We test with your own figures, so you see straight away whether the dashboard shows the same as what you calculate in Excel today.

How up to date are the figures?

As up to date as the source allows. Systems with an API, like most accounting and ERP packages, are read automatically at set times. An Excel list is as current as the last time someone updated it.

What if our data isn't clean?

Then that is where we start. Customer names spelled differently in two systems or project codes that don't match, we reconcile once and properly. After that, the dashboard also shows what is missing, such as a project with no hours booked.

Isn't Power BI enough?

Often it is, if your data already sits neatly in one system and someone keeps the reports up to date. A custom dashboard pays off when the figures first have to be brought together from several systems, or when they need to sit in the app your people work in.

Can we still get the figures into Excel?

Yes. Every list behind a KPI, such as the projects with their margin or the unpaid invoices, can be exported to Excel for further calculation.

How many lists go into your monthly figures today?

Tell us briefly how your process works today. We’ll let you know whether custom software makes sense, roughly what a first version costs and how quickly it can be running.

We reply quickly.