For a leading automotive brand, this complexity was compounded by manual processes and fragmented insights, making it difficult to track sales performance and ensure accurate commission payouts.
Optimizing Global Merchandise Sales Monitoring with Automated Power BI Dashboards
Driving Data-Driven Decisions for Global Sales with AI-Powered Insights
Managing merchandise sales data across global markets is challenging.
In this case study, we explore how Decision Crew helped streamline the data consolidation process, introduced advanced analytics, and transformed the client’s ability to monitor and optimize their global merchandise sales through a custom Power BI dashboard solution.
Project Fact Sheet
Country
United Kingdom
Primary Service
Data Visualisation
Project Timeline
Nov '21 - Jan'22
Technology
Microsoft Power BI, SharePoint
Why streamline business operations?
Employees spend an average of 18 minutes per day, or 1.5 hours per week, on manual spreadsheet 
tasks that could be automated
Problem Overview
A leading automotive brand, known for its global reach and high-performance standards, faced significant challenges in managing and optimizing its merchandise sales data. Their challenges included:
- Excel “hell”: The client relied on Excel, which lacked the necessary capabilities for complex data visualization and business process automation
- Data Quality: Data inconsistencies in geographical and product descriptions made it challenging to ensure accuracy
- Lack of Automation: Manual processes hindered performance and limited the ability to drill down into specific insights
- Lack of insights: Identifying which merchandise, regions, and celebrities were driving the most sales was particularly difficult
Our automotive client approached us to help automate the process and to help them manage their customer insights in a more data-driven fashion.
Our Process
Solution Overview
To address these challenges, we designed and implemented a Power BI-based KPI scorecard tailored to the client’s specific needs. The solution featured:
- Automated Data Integration: We automated the extraction of vendor files from SharePoint, ensuring seamless data uploads into Power BI, which eliminated manual data handling and reduced errors
- Visual Metrics and Drill-Down Capabilities: The Power BI dashboard was equipped with intuitive visual metrics that allowed the client to drill down into detailed sales data, providing clarity on geographical performance, product types, and celebrity-related merchandise
- Performance Optimization: Recognizing the limitations of Excel, we focused on creating a solution that managed large datasets efficiently, with enhanced performance for quicker, more reliable insights
- User-Centric Design: A visually attractive wireframe was developed prior to the final product, ensuring that the user experience was as engaging as it was functional
- AI-Driven Insights: The dashboard incorporated AI features to highlight trends and anomalies, providing the client with predictive insights that were previously unattainable
Outcome
The Power BI dashboard revolutionized the client’s merchandise sales data management through advanced data visualization and automation.
- Automated workflows streamlined data consolidation and processing
- Provided deeper insights and data analysis, empowering data-driven decision-making
- Enabled effortless monitoring of global sales performance
- Enabled clear target monitoring of commissions
- Identified key drivers of sales success across different dimensions
This strategic shift not only streamlines their processes but also supports smarter, data-driven decision-making across the organization.
6
Weeks to deliver the project
29
Euros in annual revenue monitored
100
Resource hours saved (Annual)