About
A project focused on ETL, pipelines, data modeling, and reporting infrastructure to unify scattered store data, automate processing, and deliver accurate sales insights for a US-based offline ice cream franchise.
Challenge, approach, and impact
Data Engineering and Reporting System Implementation
Built a complete data engineering and reporting system for a US-based offline ice cream franchise. Unified scattered store data, automated processing, and delivered accurate sales insights in under five minutes. Reorganized complex, nested datasets, configured AWS Lambda workflows, and set up a reliable PostgreSQL pipeline feeding 11 real-time dashboards.
Data Processing Speed Optimization
Delivered processed data in under 5 minutes. Cleaned up and organized data to ensure scalability as the client opens new stores. Created visual dashboards displaying top-selling items.
Franchise Reporting System Enhancement
Enhanced reporting system for franchises to manage their business effectively. Provided a fully functioning reporting system with more accurate and reliable reports, delivered instantly, fast, accessible, correct, and inclusive of more filters. Currently, there are 11 total reports available.
How we built
Testimonials
Aria Smith, Data Engineer @ Dataforest
Dataforest
“Built a data engineering and reporting system for a US-based offline ice cream franchise, unifying scattered store data, automating processing, and delivering accurate sales insights in under five minutes.“
Team structure
Client team
David Thompson
Project stakeholder
Project stakeholder
Olivia White
Daily point of contact
Daily point of contact
The client stakeholders were working closely with the team at Dataforest
Agency team
3 x Data Engineer
Production
2 x Cloud Engineer
Production
0 x Production
Production
2 x Backend Developers
Production
