Project Background
With over 180 restaurants and 130 ice cream shops across Latin America, Crepes and Waffles had a massive operational footprint and diverse teams to manage. However, decision-making relied heavily on spreadsheets, manual reports, and disjointed systems. Key insights about performance, customer behavior, and sales trends were slow and incomplete. The company partnered with AmpleMax to develop a centralized BI solution that could unify their data, offer clarity across departments, and guide growth with confidence.
We empowered Crepes and Waffles to scale operational excellence by building a custom Business Intelligence platform for real-time insights and strategic decisions.
Objectives
Create a unified BI platform for commercial, operational, and marketing areas.
Reduce dependency on spreadsheets and manual reports.
Improve visibility into sales, service quality, and customer behavior.
Enable faster and more accurate strategic decisions.
Train internal teams to become data-driven.
Key Features Delivered
Custom Business Intelligence Platform
Integration with POS
Dashboards for sales trends, ticket size, product mix
Heatmaps by location and time of day
Service quality metrics from customer feedback
Forecasting tools and anomaly detection
Our Approach
Data Audit & Architecture Planning:
Identified key operational and commercial data sources across brands and locations.
Mapped reporting gaps and inconsistent KPIs across departments.
Designed a scalable BI architecture to centralize metrics for all brands.
Dashboard Prototyping & Validation:
Built low-fidelity and high-fidelity dashboard prototypes for critical business areas.
Conducted validation sessions with area managers and directors.
Prioritized usability and speed of insight generation.
Development & ETL Integration:
Connected data from POS, quality audits, and customer feedback systems.
Cleaned and standardized data for consistent analytics.
Developed dynamic dashboards with drill-down capabilities by store, brand, and city.
Rollout & Training:
Trained HQ managers, operations teams, and brand leads in dashboard usage.
Delivered user manuals and hosted live sessions for Q&A.
Ensured role-based access control and dashboard segmentation.
Continuous Improvement:
Established monthly BI review cycles with leadership teams.
Updated dashboards based on user feedback and evolving KPIs.
Created alert systems for underperformance and outliers.
Results
Decision-making time reduced by 60%.
Average ticket size increased by 14% after campaign adjustments.
Service issue resolution time dropped by 35%.
+1,500 daily users of the BI dashboards across 4 countries.
Created a culture of continuous data use for improvement.
Prev Project
Next Project
