Case Studies Pyramid Accelerates Blokker’s Data-Driven Transformation

Edit This Case Study Record

	Pyramid Accelerates Blokker’s Data-Driven Transformation

Pyramid Accelerates Blokker’s Data-Driven Transformation

Technology Category	Analytics & Modeling - Predictive Analytics Application Infrastructure & Middleware - Data Exchange & Integration Application Infrastructure & Middleware - Data Visualization
Applicable Industries	Retail
Applicable Functions	Business Operation Sales & Marketing
Use Cases	Fraud Detection Supply Chain Visibility
Services	Data Science Services System Integration Training
Challenge	Blokker, a leading Dutch retailer with 340 stores, faced an increasingly competitive landscape and aimed to become a data-driven organization. The company needed to move beyond basic BI tools to gain better visibility across the business and drive profitability. They migrated all transactional data into a central data warehouse but required a robust data reporting and analytics tool to sit on top of it. The legacy QlikView solution was limited to sales data and other tools added complexity without providing a centralized view of margin and stock data. A new analytics department was set up to access a single source of data for BI across various internal departments. The goal was to centralize data, visualize it, and make it available to different business units for daily, weekly, and even hourly reports to analyze store traffic and determine staff levels. Read More
About Customer	Blokker is a prominent Dutch retailer specializing in household items and toys, operating through 340 stores across the Netherlands. The company has a significant presence in the retail market and aims to stay competitive by leveraging data-driven strategies. Blokker's IT infrastructure includes a central data warehouse that consolidates transactional data from various applications. The company has a dedicated analytics department focused on providing business intelligence to multiple internal departments, including Category Management, Sales, Marketing, Supply Chain, and Business Operations. Blokker's commitment to data-driven decision-making is evident in its efforts to implement advanced analytics tools and redefine key performance indicators (KPIs) for better accuracy and consistency across the organization. Read More
Solution	Blokker considered Microsoft’s Power BI platform but ultimately chose Pyramid for its faster and more cost-effective integration features. Pyramid was implemented and integrated with all structured data in the data warehouse and operational databases. This enabled the analytics team to surface data into multiple business units, including Category Management, Sales, Marketing, Supply Chain, and Business Operations. Pyramid facilitates self-service access to data sets for individual modeling while maintaining control to avoid BI sprawl. The implementation allowed the analytics team to redefine KPIs, ensuring consistency and accuracy across the business. Critical KPIs, such as reported revenue and product availability, are now much more accurate. The centralized data and sophisticated analytics provided by Pyramid have empowered Blokker to optimize its supply chain, pinpoint fraud, and track various metrics such as assortment optimization, supplier performance, planning of opening hours, product returns, and omnichannel reporting. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Predictive Analytics

Application Infrastructure & Middleware - Data Exchange & Integration

Application Infrastructure & Middleware - Data Visualization

Applicable Industries

Retail

Applicable Functions

Business Operation

Sales & Marketing

Use Cases

Fraud Detection

Supply Chain Visibility

Services

Data Science Services

System Integration

Training

Challenge

Blokker, a leading Dutch retailer with 340 stores, faced an increasingly competitive landscape and aimed to become a data-driven organization. The company needed to move beyond basic BI tools to gain better visibility across the business and drive profitability. They migrated all transactional data into a central data warehouse but required a robust data reporting and analytics tool to sit on top of it. The legacy QlikView solution was limited to sales data and other tools added complexity without providing a centralized view of margin and stock data. A new analytics department was set up to access a single source of data for BI across various internal departments. The goal was to centralize data, visualize it, and make it available to different business units for daily, weekly, and even hourly reports to analyze store traffic and determine staff levels.

About Customer

Blokker is a prominent Dutch retailer specializing in household items and toys, operating through 340 stores across the Netherlands. The company has a significant presence in the retail market and aims to stay competitive by leveraging data-driven strategies. Blokker's IT infrastructure includes a central data warehouse that consolidates transactional data from various applications. The company has a dedicated analytics department focused on providing business intelligence to multiple internal departments, including Category Management, Sales, Marketing, Supply Chain, and Business Operations. Blokker's commitment to data-driven decision-making is evident in its efforts to implement advanced analytics tools and redefine key performance indicators (KPIs) for better accuracy and consistency across the organization.

Solution

Blokker considered Microsoft’s Power BI platform but ultimately chose Pyramid for its faster and more cost-effective integration features. Pyramid was implemented and integrated with all structured data in the data warehouse and operational databases. This enabled the analytics team to surface data into multiple business units, including Category Management, Sales, Marketing, Supply Chain, and Business Operations. Pyramid facilitates self-service access to data sets for individual modeling while maintaining control to avoid BI sprawl. The implementation allowed the analytics team to redefine KPIs, ensuring consistency and accuracy across the business. Critical KPIs, such as reported revenue and product availability, are now much more accurate. The centralized data and sophisticated analytics provided by Pyramid have empowered Blokker to optimize its supply chain, pinpoint fraud, and track various metrics such as assortment optimization, supplier performance, planning of opening hours, product returns, and omnichannel reporting.

Impact #1	Combining data from different systems and centralizing it in one place for querying, modeling, and visualizing has been the biggest benefit for Blokker.
Impact #2	Pyramid has provided an analytics layer to an evolving architecture that has advanced the retailer’s move towards data-driven decision-making.
Impact #3	Improved supply chain visibility directly addressed an issue around customers turning up at stores expecting to buy products that were unavailable.

Impact #1

Combining data from different systems and centralizing it in one place for querying, modeling, and visualizing has been the biggest benefit for Blokker.

Impact #2

Pyramid has provided an analytics layer to an evolving architecture that has advanced the retailer’s move towards data-driven decision-making.

Impact #3

Improved supply chain visibility directly addressed an issue around customers turning up at stores expecting to buy products that were unavailable.

Benefit #1	Increased stock availability in stores by 5 percent, generating millions of extra euros in turnover.
Benefit #2	Online sales orders increased by 50 percent during the COVID-19 pandemic.

Benefit #1

Increased stock availability in stores by 5 percent, generating millions of extra euros in turnover.

Benefit #2

Online sales orders increased by 50 percent during the COVID-19 pandemic.

Download PDF Version

Overview

Pyramid Accelerates Blokker’s Data-Driven Transformation

Operational Impact

Quantitative Benefit