What 80+ Outlets Taught Me About F&B Data

The HWC Coffee Challenge

When HWC Coffee Malaysia brought me on as their F&B Marketing & Tech Consultant, they had 80+ outlets across the country. They had data — lots of it. What they didn't have was a way to turn that data into decisions.

Sales data lived in a POS system (Xilnex). Marketing data was scattered across platforms. Outlet performance comparisons required manual CSV exports and spreadsheet gymnastics. By the time anyone had the full picture, the moment to act had passed.

Building the Dashboard

The first thing I built was a centralized analytics dashboard. Live POS API integration — no more waiting for monthly CSV exports. Sales flow directly from every outlet's point-of-sale system into the dashboard in real-time.

Multi-outlet comparison became instant. Which outlets are outperforming? Which are declining? What products are trending where? All visible at a glance instead of buried in spreadsheet tabs.

Trend analysis shows patterns that humans miss. A 3% daily dip at one outlet might go unnoticed in monthly reports. But when you see it in real-time, you can investigate immediately — is it a staffing issue? A local event? A competitor opening nearby?

What the Data Revealed

Working with 80+ outlets worth of data taught me things that running 2 outlets never could:

Location patterns are more nuanced than you think. It's not just about foot traffic. Time-of-day patterns vary wildly between mall outlets and standalone shops. A coffee chain has different peak hours depending on whether it's near offices, residential areas, or universities.

Product performance varies by outlet type. A specialty drink might be the top seller in one outlet and barely move in another. Understanding why — and optimizing the menu per location — is where the real gains are.

Staff scheduling should follow data, not habit. Most chains schedule based on 'this is how we've always done it.' The data shows exactly when each outlet is busy and when it's quiet. Matching staff to demand saves labor costs without hurting service.

The AI Marketing Layer

Beyond analytics, I designed AI-powered marketing campaigns using the POS system's voucher API:

• Birthday rewards — automated voucher distribution tied to customer profiles
• Loyalty tiers — Member, Coffee Hunter Lite, Coffee Hunter Premium — each with targeted promotions
• Win-back campaigns — customers who haven't visited in X days get a personalized offer

The key insight: don't blast the same promotion to everyone. Segment by behavior, automate the delivery, and measure the results. The voucher system processes tens of thousands of redemptions, all managed programmatically.

Lessons for Any F&B Business

You don't need 80 outlets to benefit from data. Even with 1-2 locations, you should know:

• Your top 10 products by margin, not just by volume
• Your peak hours — and whether your staffing matches
• Your customer return rate — are people coming back?
• Your delivery vs. dine-in split — and the trend direction

Most restaurant owners know their food. Fewer know their numbers. The ones who know both are the ones who scale.

What I'd Recommend

If you're running an F&B business and want to get serious about data:

Start with your POS system. Most modern POS systems have APIs or export capabilities you're not using. The data is already being collected — you just need to surface it.

Build dashboards, not reports. Reports are backwards-looking. Dashboards are real-time. When your data is live, you catch problems before they become expensive.

Automate your marketing. Manual promotions are slow and untargeted. Connect your customer data to your marketing — birthday offers, loyalty rewards, and win-back campaigns should run themselves.

Explore the [full case study](/case-studies) or [connect with me](/connect) to discuss your data strategy.