All customer stories
Reporting & close
SG&A variance analysis 4 days earlier across 29 entities
A global telecom group automated SG&A reporting on Microsoft Fabric for faster cost reviews.
About the client
- Industry
- Telecom
- Size
- $800M revenue
- Timeline
- [X weeks]
The challenge
SG&A spend sat across 29 entities on Dynamics 365. Consolidating it was manual, so cost-control reviews and variance analysis started late and took longer than they should.
What it meant for the team
CFO
No single, timely view of SG&A spend across the group.
Controller
Manual consolidation from 29 entities every reporting cycle.
FP&A
Variance analysis arrived too late to change the month’s decisions.
How we delivered it
- Step 1[X weeks]
Advise and design
- Defined the SG&A MIS platform and a unified reporting layer
- Set up a variance framework for management reviews
- Step 2[X weeks]
Build and automate
- Integrated financial data from 29 entities into Microsoft Fabric
- Automated ETL pipelines with Fabric Notebooks and Python
- Built interactive SG&A MIS dashboards in Power BI
- Step 3[X weeks]
Launch and embed
- [Add go-live, training and adoption details]
Total timeline: [X weeks]
Solution stack
Advisory services
- SG&A MIS design
- Variance framework
Data sources
- Dynamics 365 (29 entities)
Storage and transformation
- Microsoft Fabric
- Fabric Notebooks
Logic and workflow
- Python transformations
- Variance tracking
Insights delivery
- Power BI SG&A MIS
Impact
60%
less reporting time through automated consolidation
4 days
earlier variance analysis
29
entities in one cost view
Outcomes
- Automated variance tracking and cross-entity cost analysis
- Faster SG&A cost-control reviews and decisions
- Stronger financial governance across all entities
