Hero imagery for the A central data warehouse for Belgotex on Microsoft Fabric case reference

A central data warehouse for Belgotex on Microsoft Fabric

A central, modelled data warehouse that pulls Belgotex’s scattered data into one place to report from, with room to take in factory IoT data later.

Belgotex

Power Business Decisions with Cloud Scale Analytics

Microsoft

Delivery partner

Microsoft FabricAzure SQLPower BI
Client
Belgotex
Industry
Industry & Infrastructure
01

The challenge

Belgotex is a leading soft-flooring specialist that designs, manufactures and distributes its products, and that generates a lot of data spread across the organisation, some in sales, some in production, some in HR. With the data sitting in different places, it was hard to see relationships across it or get a holistic view, and pulling it together kept becoming a manual task that crowded out the actual analysis.

02

The approach

We spotted the gaps in what Belgotex could report on and built a common data warehouse to bring everything together. Core data was extracted from their IBM Db2 servers into a central Microsoft SQL Server, then ingested into Microsoft Fabric, and modelled with the help of business users and subject-matter experts. For proper data lifecycle governance, data moves through a staging area for consolidation and then a transformation area where business logic normalises and enriches it. Reporting is done through dynamic Power BI reports, and we gave Belgotex a semantic layer to report from, with dimensions and drill-through they did not have before. We designed it to take in real-time IoT data from the plant in future.

03

The outcome

Belgotex now has one central place to report from, with the data automated so people can focus on analysis instead of gathering. They can see relationships and correlations across previously separate sources, explore the data dynamically, and the platform is ready for factory IoT data when they want it.

Summary & benefits

  • One central, automated reporting location across previously scattered data.
  • A semantic layer with dynamic reporting and drill-through.
  • Built to take in real-time IoT data from the plant in future.

Similar work in Industry & Infrastructure

More customer stories like this one.

Mapping deep-shaft HR processes for automation in Nintex Process Manager

Deep-shaft Mining Company

We mapped, optimised and governed a deep-shaft mining company’s HR processes in Nintex Process Manager, turning fragmented manual workflows into a navigable, automation-ready set of processes.

Nintex Process Manager

Nintex logo
Nintex Process ManagerProcess MappingProcess GovernanceDashboards & Reports
Read case study

Modernising line-side quality control for MAHLE

MAHLE

A modern .NET solution that prints product labels from automated quality checks on MAHLE’s South African lines, with central configuration and full traceability.

Application modernisation

.NETBespoke IoT
Read case study

Consolidating PPC onto one Microsoft 365 environment across five countries

PPC

An Active Directory consolidation and Exchange Online migration that brought PPC’s separate country domains and mailboxes onto a single Microsoft 365 environment.

Microsoft 365 & Exchange Online

Microsoft 365Exchange OnlineActive DirectoryEntra ID
Read case study

Get in touch

Got a problem worth solving?
Let’s talk.

Send us the gist of what you are trying to do. The right person from First Digital will be in touch within a working day.