A.forall: from decentralized reporting to a unified data platform

Microsoft Fabric

Power BI

Azure

A.Forall is a pharmaceutical group of generic and pharmacy sales companies. With headquarters in Belgium and offices in Ireland and the US, they represent 144 employees spread over 14 different countries. They develop value-added generic pharmaceuticals, solve product shortages and fill unmet medical needs so that patients can continue their treatment.

The challenge

One version of the truth: have one location that serves as reference for all reporting.

Integration: integrating with multiple sources like SAP B1, Monday.com, SharePoint

Serving multiple business units: each department has their own way of reporting, with many flat files all over the place and no structure. This data platform should organize reporting for all departments.

Our solution

Data Platform in Microsoft Fabric.

Standardization with an ETL framework.

Use cases in supply chain, sales and finance: expected invoices, demand reports, monthly sales report, profit share reconciliation, …

Low maintenance framework and ETL flow.

The business value

A data platform has been set-up that supports the use cases.

  • Corporate reporting is streamlined.
  • Valuable time is returned to the employees by automating manual steps for reporting.
  • Starting small but growing. The platform is cloud-based and scales to include further use cases and larger data sets.