Net revenue steering against targets, by product family, customer category and channel (domestic / export, GMS, wholesale), with active-customer tracking.

Market segmentation logic (customer category, traditional market, export / domestic) built with SWITCH and variables, showcasing DAX mastery and code documentation.

A single Excel formula generates a complete weekly tonnage and presence-rate table: LET, GROUPER.PAR, ASSEMB.H, CHOISIRCOLS, RECHERCHEX and SEQUENCE work together to turn raw data into operational KPIs, with no VBA and no legacy array formula. Modern Excel powering industrial performance.

Group-wide steering across subsidiaries (Senegal, Cameroon, Congo, Ethiopia, Ghana, Sierra Leone, South Africa, Tanzania, Zambia): tonnage, YTD vs prior year, domestic / export, cement grades, Panaf market shares, exports by country and customer ranking.

Second Senegal steering view: actual vs target, domestic / export split and tracking of key commercial indicators.

Model architecture (Fact_Sales fact table with Calendar, Clients, Products and Targets dimensions) — the guarantee of reliability and performance in a Power BI project.