Customer Story

Spar Builds a Bird’s Eye View of Over 13,000 Stores with Designer Cloud

 

Spar International Key Stats


Industry: Retail

Data Stack: Designer Cloud, AWS S3, PowerBI

Region: Global

€ 250 Million

In diverse sales data can now be analyzed

48 Countries

Feedback sales data into analytics

12X

Increase in reporting output

 

Core Challenges

Spar wanted to build a global report of its 13,000 stores that span a total of 48 countries. However, each country operates under its own unique product naming conventions, works with its own suppliers and brands, and often has its own currency. Finding the common denominator in all of that data—let alone standardizing and joining it—was too big of an undertaking. Finally, Spar also wanted to leverage Nielsen data to run comparisons against competition, but this data, too, had its own categorization for products that needed to be standardized to fit Spar’s reporting.

How Designer Cloud Solved this Problem

Spar built a data workflow that relies upon the combination of Amazon S3 buckets and Designer Cloud to store data and then cleanse, standardize, and join it for reporting in PowerBI. With Designer Cloud, Spar has been able to quickly standardize unpredictable retailer data and build a high-level global report that, frankly, the Spar team had never achieved before. On top of that, Spar has also been able to leverage Nielsen data to benchmark store and category performance. The success of this data aggregation project has not only allowed Spar to better understand its global retailers and competitors, but has also prodded the team to ask new, more complex questions that are now possible to answer with this advanced level of reporting.

 

Benefits

Increased Sales Analysis

With Designer Cloud, Spar has ingested and analyzed over €250m in yearly sales data that was previously not analyzed.

New Business Insights

The global retailer report built with Designer Cloud shines a light on retailer best practices, consumer habits, competitor performance, etc. to help Spar grow its bottom line.

Ease of Use

By leveraging AWS S3 buckets, Spar not only provides their partners with an easy way to deliver data more frequently, but can also collect data from more countries.

 

Company Background

SPAR International unites and operates in partnership with independent retailers by working together to share global scale and expertise to enhance the competitiveness of its retail partners worldwide and build the SPAR brand internationally.

 

Watch Webinar

How SPAR Created a CPG Sales Data Exchange with Data Preparation

 

 

We’ve come to appreciate the power of the platform and what can be achieved. The holy grail for us was bringing country data together. We’ve not been able to do that previously because of all of the naming conventions and I think we’re only really scratching the surface of what that can do for our business.

SPAR International

Tom Rose, Head of International Operations

SPAR International

 
15 MINUTES OR LESS

Assess Your Analytics Maturity

Get a better understanding of where you stand on the analytics maturity scale – and where you want to be.

 

 

Recommended Resources

 
Customer Story
Taste the Feeling Coca-Cola Alteryx
Over 1.9 billion Coca-Cola beverages are enjoyed daily around the globe.
  • Cloud Products
  • Data Prep and Analytics
  • Designer
Learn More
 
Customer Story
Amway Adapts to Product Hierarchy Changes in Minutes
Amway migrated its data to Google Cloud BigQuery and centered its product hierarchy around Google Cloud Dataprep.
  • Cloud Customer Spotlight
  • Cloud Products
  • IT Professional
Learn More
 
Customer Story
PDPAOLA Stands out in a Crowded eCommerce Market with Google Cloud Dataprep
PDPAOLA chooses Google Cloud Dataprep and natively integrates with the Google Cloud Platform and quickly migrates its work over to Dataprep.
  • Cloud Customer Spotlight
  • IT Professional
  • Professional
Learn More