How Duomed Belgium ramps up reporting with Cegeka Business Insight

Cegeka Business Insight & Power BI

“Think of CBI as a data warehouse where all kinds of data come together”, explains Business Intelligence Solutions Architect Sylvie Goetgeluk. “CBI is oriented towards Dynamics by default, but it’s also possible to integrate other data sources. With CBI, we translate the complex ERP data model into reporting tables, which can then be visualized in clear reports and dashboards using Power BI. These reports provide insight into key figures such as turnover, margins, production efficiency, delivery rates, etc.”

Acces to all data for anyone, anytime

“Some roles, such as our Account Managers, don’t have direct access to Dynamics 365 Finance & Operations,” Michaël explains. “If they needed data from the ERP, for example, on suppliers, products, customers..., they used to call the support department and we would send them an e-mail with the data as an Excel attachment. Now, with CBI, they can independently access the data they need, whenever they want.”

Databricks upgrade for CBI

Early 2023, Cegeka and Duomed launched a pilot project to test the new Databricks technology for CBI. Sylvie: “Databricks is a unified analytics platform that changes the way the data from the ERP is processed to the CBI data warehouse. The output remains the same, but we now rely on future-proof, more performant Azure technology to create the reports.”

The game changer for Duomed? Michaël: “In the past, the data was refreshed once a day, at night. But now, we can refresh it multiple times a day to have the most up-to-date data at our disposal. Another nice to have: thanks to the new CBI framework, adding customization to CBI costs 10% less.”

Building a dream team

According to Sylvie, close cooperation between the different teams was paramount in this project. “The set-up of the ERP environment largely determines what you can and cannot report on. Our Dynamics consultants and developers worked closely with the CBI consultants to align both solutions. In the run-up to the go-live, both teams were present at Duomed one day a week. Today, we are still in contact with Michaël via Teams to follow up on ad hoc questions and change requests.”

All in this together

Duomed’s CBI project is still ongoing today. Michaël: “Our end users are only just getting accustomed to the new tools. Practice makes perfect, so I encourage them to experiment as much as possible. What’s more, I also organize training sessions to get new users up to speed. If they do encounter a problem, I either try to solve it myself or I send a change request to the Cegeka team.”

“We’ve now received about 70% of the scheduled reports. Some essentials, such as customer pricing, are still under development, so we’re looking forward to testing those as well. Meanwhile, Duomed France and Denmark are preparing their CBI rollouts. And who knows what other companies we’ll acquire in the future. One thing’s for sure: we’re all in this together!”