BI Dashboard Suite for a UAE E-Commerce Company

The Challenge

A fast-growing e-commerce company based in the UAE was running their business on data spread across 7 different systems: their e-commerce platform, payment processor, marketing tools, inventory system, accounting software, email platform, and customer support tool.

Their CEO spent 2 days every month manually compiling data into a PowerPoint deck for investors. Key decisions about marketing spend, inventory ordering, and pricing were based on gut feel because the data was always 2–3 weeks old by the time anyone saw it.

The Solution

Over 10 weeks, I built a complete BI reporting suite:

• Central data warehouse connecting all 7 systems via automated pipelines
• Executive dashboard showing real-time revenue, costs, margins and cash flow
• Marketing dashboard with ROAS, CAC and channel performance by day
• Inventory dashboard with stock levels, turnover rates and reorder alerts
• Automated weekly reports distributed to leadership without any manual work
• Anomaly detection alerts when key metrics deviate from expected ranges

The Results

The CEO now has real-time visibility into every part of the business. Investor reporting takes 5 minutes instead of 2 days. The marketing team optimized their ad spend based on daily ROAS data, resulting in a 2% revenue uplift within the first month.