Power BI
Power Automate
Power Apps
Prik&Tik is an out-of-home cooperative of more than 100 independent beverage retailers across Belgium. For its members, Prik&Tik offers a broad and competitive assortment of beverages while supporting them with strong and innovative concepts. For consumers, Prik&Tik aims to be the first choice by providing a complete range of products alongside attractive promotions.
Prik&Tik’s mission is to help its affiliated beverage retailers achieve sustainable and profitable growth, provide strategic direction, and work together to ensure that Prik&Tik is recognised as the preferred partner for both professional and private customers.
Prik&Tik had access to a large volume of sales data originating from multiple stores and point-of-sale systems. While this data offered significant potential, there was no central environment where employees could easily perform market analyses and use the results in discussions with suppliers.
In addition, Prik&Tik needed a better way to monitor whether stores were submitting their data on time. Missing or delayed data directly impacted the quality and reliability of reporting. As a result, Prik&Tik was looking for a solution that combined both market insights and operational data monitoring.
Cloubis developed two Power BI reports to address these challenges.
The first report focuses on supplier and market analysis. Employees can analyse sales data using various filters such as supplier, member code, promotions, province and sales date. Data is available at multiple levels, ranging from product category and subcategory to brand and individual product. The report combines information on revenue excluding VAT, market revenue and sales volumes, allowing users to quickly gain insight into a supplier’s performance within its market segment.
To further automate reporting, two Power Automate flows were integrated. Users can export either a market analysis or a detailed product analysis directly from Power BI to Excel. All selected filters are automatically applied to the export, making it easy to share relevant information with suppliers.
The second report focuses on store monitoring. This dashboard provides an overview of which stores have submitted their data each month and allows users to filter by different point-of-sale systems, including Freedelity, Jamadata, Created Software and Comperex. Here too, a Power Automate export function was implemented. This enables Prik&Tik to quickly identify missing data and monitor the overall quality of reporting.
Thanks to the new Power BI solutions, Prik&Tik now has a central environment for both market analysis and operational monitoring.
Employees can gain insights into market performance more quickly and efficiently, support suppliers with objective data, and export relevant information without manual effort. In addition, the store monitoring dashboard improves the follow-up of data submissions, increasing the reliability and completeness of reporting.
The result is a more data-driven way of working, where commercial decisions and supplier conversations are supported by accurate, up-to-date and trustworthy insights.
