Data Insights - Inventory Insights

This article offers a comprehensive overview of the data analysis capabilities available through the Cafe Inventory Insights page.



Why use Cafe Inventory Insights? 


The Cafe Inventory Insights deliver precise and practical data that can help you make informed decisions about your locations.

We aim to provide straightforward and effective solutions that empower you to accomplish the following:

  • Streamline your inventory management processes
  • Reduce waste
  • Optimize your purchasing strategies
  • Boost your operational efficiency
  • Tackle any challenges that may arise 
  • Enhance performance across all your locations

Before you dive into the data analysis, we encourage you to familiarize yourself with the Cafe Inventory Overview page

Requirements


To get Inventory Insights, you must fulfill the following requirements:

  1. You need to create a Menu
  2. You need to upload at least one POS file.

This step is essential as it allows the system to assess sales data and inventory levels accurately.

The components of the Cafe Inventory Insights overview page


In the upcoming sections, we will explore each data source in detail, guiding you through the types of data you are collecting and providing insights on how to analyze this information effectively.

  1. Daily average
  2. Total shot consumption of all selected locations
  3. Total shot consumption throughout the day
  4. Total shot consumption throughout the week
  5. Total shot consumption across locations
  6. Assessment Overview

Daily average


Screenshot 2025-03-06 at 08.57.53

  • Shots linked to recipes across all selected locations:
    The daily average in kg | Number of hots | € 
  • Shots sold across all selected locations:
    The daily average in kg | Number of shots | € 
  • Shots unsold across all selected locations
    The daily average in kg | Number of shots | € 

We use single shots as the baseline for calculating brewed versus sold coffee, as they represent the smallest unit of measurement. For example, while a cappuccino typically requires one shot of espresso, many cafes opt to brew double shots using double-spouted portafilters. In such instances, one shot is accounted for the drink, leaving the second shot as unsold inventory. 

Total shot consumption of all selected locations

 

A pie chart will visually illustrate the total shots sold versus unsold across all selected locations, offering a comprehensive view of your inventory performance.

Monitoring the unsold shot ratio is crucial, as a high percentage may signal potential issues that require your attention. This feature allows you to identify challenges that could be impacting your inventory performance.


Screenshot 2025-03-06 at 09.13.28

Total shot consumption throughout the day


You can select between two views on this diagram:

  1. Total Brewed
    Screenshot 2025-03-06 at 09.23.46
  2. Unsold Ratio
    Sold shots will be displayed in blue, while unsold shots will be displayed in orange.
    Screenshot 2025-03-06 at 09.24.51

By clicking on the numbers at the bottom of the page, you can easily access and review the consumption data for each of the previously selected days, enabling a thorough analysis of your inventory trends over time.

Total shot consumption throughout the week 


You can select between two views on this diagram:

  1. Total Brewed
    Screenshot 2025-03-06 at 09.19.21

  2. Unsold Ratio
    Sold shots will be displayed in blue, while unsold shots will be displayed in orange.Screenshot 2025-03-06 at 09.18.21

By clicking on the numbers or arrows at the bottom of the page, you can easily explore the consumption data for each day within the selected week, allowing you to analyze daily trends and patterns.


💡Activating the Show Daily Averages button allows you to conveniently access and display the daily average data.
Screenshot 2025-03-06 at 09.20.08

Total shot consumption across locations

This view can only be accessed when you select multiple locations.


You can select between two views on this diagram:

  1. Total Brewed
    Screenshot 2025-03-06 at 09.27.07
  2. Unsold Ratio
    Sold shots will be displayed in blue, while unsold shots will be displayed in orange.
    Screenshot 2025-03-06 at 09.27.34

Assessment Overview 


Each location's data will be presented separately, allowing for a detailed analysis tailored to individual site performance:

Screenshot 2025-03-06 at 09.29.29

💡Activating the Show Daily Averages button allows you to conveniently access and display the daily average data.
Screenshot 2025-03-06 at 09.30.01

  • Shots brewed (daily average)
  • Shots sold (daily average)
  • Shots unsold (daily average)

Clicking on a specific location will take you to the Telemetry Insights page dedicated to that site, where you can view the data for the date range you selected earlier.

In this example, the selected date range for Cropster Brew Bar was 01/07/2024 - 01/12/2024:
Screenshot 2025-03-06 at 09.33.10

By clicking on Cropster Brew Bar in the Assessment Overview, you will be taken to the Telemetry Insights page, where you can access detailed data for the chosen location and the previously selected date range:
Screenshot 2025-03-06 at 09.31.18

Don't stop here! Learn more about the Cafe Telemetry!

Be sure to visit our Helpdesk for additional resources and support to enhance your experience and fully leverage the features of your Cafe subscription.


Your feedback and suggestions are invaluable to us, as they significantly contribute to the improvement of our product tailored for your needs. We invite you to share your ideas and experiences with us!


Related content


Congratulations! You have successfully learned how to analyze your Cafe Inventory Insights data. 

Your opinion matters. If you have further questions, feedback, or concerns, please feel free to reach out by submitting a support ticket directly from support.cropster.com