A leading wholesale retailer in Mexico changed platforms.
Its 400+ users changed nothing.
The retailer moved years of reporting data from SAP to Azure Databricks and Power BI. Its 102 reports look, work and add up exactly as before, so there was no retraining, no new dashboards to learn and no disruption to stores or business users.
The challenge.
The retailer’s reporting ran on SAP servers that had run out of room. Reports slowed or failed, and users worked with data two days old. The platform was inflexible and close to losing vendor support.
In an organization this size, a new platform usually means new dashboards and retraining for every user. And the systems that run the stores could not be disrupted.
New dashboards and retraining for every user.
Stores could not be disrupted.
What we delivered.
SunnyData moved the retailer’s reporting from SAP to Azure Databricks and Power BI.
102 reports (1,462 pages) rebuilt to match SAP in design, function and figures, so nobody had to relearn how to find or read their numbers.
Up to 17 fiscal years of history carried over.
Data loads from the store systems redesigned to run faster without affecting store operations.
Every number checked against SAP before users tested it.
Everything documented, and the support team trained to run it.
Results.
No learning curve for 400+ users, and no retraining program needed.
Data from today, not two days ago.
Reports that respond in under 2 seconds.
Data loads 40% faster, against a 25% target.
4 servers and 44 virtual machines no longer needed.
What the retailer can do now.
Make decisions on today’s numbers, grow its data without hitting limits, and build on the same foundation for AI with Databricks Genie and machine learning.
