Bidev Consulting Logo
References Blog

Data & BI, custom development

Dashboards connected to your data, with no copy-pasting. And business applications when no off-the-shelf software fits.

A laptop shows a dashboard

Revenue

+12 %

Margin

34 %

Example, updated every morning

Up-to-date indicators, no re-keying

Your teams spend hours compiling data in Excel. By the time the report arrives, it is already out of date.

Source connectivity

ERP, CMMS, CRM, Excel files: we collect the data where it lives, automatically.

A single reference database

Data is cleaned and kept with its history in one database. Everyone reads the same figures.

Dashboards for each role

Management, production, finance: everyone sees what concerns them. Power BI, Metabase or Tableau, depending on your tools.

Alerts

An email when a threshold is crossed, instead of finding out at month end.

Two people working at their screens

Where do your figures come from?

A dashboard is only as good as its data. Before drawing a single chart, we list where each figure comes from: the management software, the accounts, a spreadsheet kept by hand, a machine.

We then bring them together in a reference database that updates itself every night or every hour. Your indicators are always calculated the same way, whoever looks at them.

In meetings, you discuss the decisions to make, with figures everyone accepts.

When no software fits

Some processes still run on Excel files, paper and emails. We replace them with a web application built for your teams.

Business Web Application

One interface per user role, on computer, tablet and phone.

Action history

Every entry and every approval is dated and attributed. You can see who did what.

Connected to your tools

The application exchanges data with your ERP, your CMMS or your accounting through APIs.

Hosted and maintained

We host the application in France, back it up and keep improving it.

How we build a dashboard

We start with your questions, not with charts: which figures do you look at every week, and which decisions depend on them? From that we draw a short list of indicators, each with a written definition.

Then we connect your sources and reconcile the figures with your accounts before showing anything: a dashboard you doubt is useless. After that, the data updates itself.

Which tool should you choose?

Already using Power BI or Tableau? We work with it. With no tool in place, we can start with Metabase, which is open source and can be hosted on your own servers. What matters is not the tool but the quality of the data behind it.

And when no software fits?

Some trades have rules too specific for off-the-shelf software. We then build a web application made for your process. It is hosted in France, backed up, and it evolves with you.

How a project runs

  1. ScopingYour sources, indicators or processes, reviewed with the people who use them.
  2. BuildDeliveries every two weeks. Your teams test as we go.
  3. Go-liveUser training and documentation.
  4. Follow-upSupport, fixes and improvements.

Examples of delivered projects

Data

Data deduplication

A record deduplication script, connected to 4 sources: document management, Cegedim, Zendesk and Azure SQL Database.

Read the case study →
Custom development

Quality control application

A critical Excel file replaced by a web application, in 9 months, at Brüggen, a cereal manufacturer.

Read the case study →

A dashboard or an application to build?

A first 30-minute conversation, free and with no commitment.