TITAN Group · Greece and USA
TITAN: an international group's finance, production and sales, from SAP into one picture
The data of a group with plants on two continents lives in SAP. The job was to get it to management as reports people can read, for finance, production and sales.
- Sector
- Building materials industry
- Services
- Business intelligence · Group financial reporting · Production reporting
- Tools
- SAP BW · Power BI · DAX · Python
The context
TITAN is an international cement and building materials group, with plants and companies in several countries. Its data lives in SAP.
We worked inside the group’s Group Reporting & Analytics team. The aim was for management reports to be built directly on the SAP data, in the same way for every country and every unit.
What we built
Power BI reports on SAP BW, in four areas:
- Financial results. A monthly results report for management, for Greece and for the USA, comparing actuals with budget.
- Cash and debt. The group’s cash position and borrowing on one screen.
- Production. Production reports by plant, the OEE indicator and shipments.
- Sales. Profitability by customer and by project.
Alongside the reports came the work nobody sees: connecting Power BI to SAP BW, testing access rights so that everyone sees what they should, and monitoring the jobs that load the data.
How we worked
As a member of the client’s team, not as an outside supplier who delivers and leaves. Requirements were set together with the people who would use each report, and the knowledge was passed on to the in-house team so it could carry on by itself.
Why it matters to a smaller business
The industry is different, but the problem is the same at every size: the data sits in a system, and the answer management needs does not come out of it ready-made.
The method that works for a group with plants on two continents is the one we bring to a hotel or a retail business: one data model, the same definitions for everyone, and reports that show where a decision is needed.
The screen at the top of the page is a sample, with made-up data. It does not show TITAN’s figures or reports.