Case Study

Mocrisa

Mocrisa is a Food and Agro distributor that had limited visibility into their operational data for both of their sister companies.

They had to download Excel reports manually at the end of the month and it took them approximately 14 days to feel confident to present these reports to executive leadership.

Value Provided

Built sales dashboards to understand customer, product and salesforce performance real-time

Built inventory dashboards to estimate when they needed to re-stock and trigger manufacturing for new products
Built an ai tool to talk directly to their own data with natural language and support decision making

Built statistical forecasting models to predict sales by subcategory that inform supply chain decisions

Built a delivery time tracking tool to provide insight into client service levels

Sisifo’s Technical Solution

Establish a data infrastructure with the following components:

Conduct advanced data analytics using Python and Power BI

Data warehouse with simple storage service to store and retrieve fluctuating data volumes
ETL Structure to allow us to extract, transform and load data
Query service to analyze large data sets using SQL
Cluster platform to run big data frameworks, such as Appache Spark

Implemented Power BI as the main visualization tool across functions
Leveraged Python (XG Boost) and AI (Sarima) to build statistical forecasting models
Programmed Data Gateways to refresh data on a real-time manner
Provided a holistic view of business financial and operational metrics

Connected AI models to the new internal database

Extracted and Connected Internal Data to AI tool using Python SDK and MCP tools
Enabled Claude AI as the main NLP/LLM platform for users to interact with

Provided access to users by publishing within the cloud environment created to ensure privacy and security

Created ai agents using N8N for automated email campaigns