Case Study Topics
Featured Studies
The data collected by the retail company was stored in various enterprise systems, making it a challenge to consolidate and use for decision-making.
Wimmer Solutions implemented Microsoft's Azure Analysis Services to consolidate the data from different systems into a single model. It then leveraged Power BI to create customized reports from the data for different customer audiences. This empowered decision-making across the client's organization.
Our team saw a need for additional analytics and processes to gauge the performance of the new global volume licensing campaigns enabled by the data model and dashboard it had developed.
The client came to Wimmer Solutions looking to build a centralized business intelligence portal for their retail stores. They wanted to enable real-time analytics, give report consumers the ability to analyze trends, and request improvements to reporting.
Centralizing reporting was a challenge for the client because retail locations used multiple enterprise systems to manage their Point of Sale (POS) and Purchase Order (PO) records. In addition, the retail data was stored in different locations across the globe. As a result, the client found its team spending more time reconciling data than delivering analytics and insights to internal customers.
Wimmer assembled a senior-level DataOps team to develop and maintain the client'sbusiness intelligence portal. The team first restructured how data was transformed for analytics. Using SQL Server Integration Services, the team imported data from each enterprise system and different global location into a single SQL Azure database instance. Once the data was centralized, the team used it to create a data model in Azure Analysis Services. As a result, report writers could easily access measures and dimensions needed to create meaningful analytics from once disparate data sources.
In addition to the data model, the team also developed a Power BI dashboard to display the analytics and visuals now possible with the new data model. The dashboard showcased real-time analytics and was distributed to a list of key internal stakeholders that the team also maintained.
Beyond developing the data model and dashboard, the team also became the primary point of contact for internal stakeholders making new features requests of the intelligence portal. This allowed the team to consolidate requests, clarify requirements, and onboard new data sources as stakeholders needed. Serving in this capacity gave the team the ability to evolve the data model and Power BI dashboard independently while the client focused on their business objectives.
The retail client's initial ask of Wimmer focused on solving the issue of connecting and collecting the data sources for its retail locations. Once on the ground, our team saw a need for additional analytics and processes to gauge the performance of the new global volume licensing campaigns enabled by the data model and dashboard it developed.
Our work in Global Performance Measurement included:
Finally, the Wimmer team was responsible for integrating the Power BI visuals from the performance scorecard in the client’s dashboard to orchestrate work streams between the client's licensing and finance teams.
