Power BI - Real Time Analytic Systems & Dashboard

Case Study Topics:

Text Link

Overview

Challenge

The data collected by Microsoft Retail 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 helped empower decision-making across the 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.

Download Case Study
Solution
Innovation

Challenge

Microsoft 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, Microsoft found its team spending more time reconciling data than delivering analytics and insights to internal customers.  

Solution

Wimmer assembled a senior-level DataOps team to develop and maintain Microsoft Retail’s business 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.

Innovation & Impact

Microsoft’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:

  • The design and creation of a world-wide promotion performance scorecard used to measure performance month by month
  • A post-mortem analysis for promotions that ended  
  • Working with promotions and finance teams to define success criteria for promotions
  • Building the data cube for monthly measurement of subsidiaries.  

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 Microsoft’s licensing and finance teams.