About Customer

Large online retailer with significant sales through the e-commerce channel

The Challenges

No real-time access of sales data that will provide trends to alter the marketing strategies. Post-processing of data via excel did not provide an holistic view of the sales.

The Solution

• Automate data extraction from the portals
• Aggregate data in a data warehouse

Power BI dashboard with an holistic view of various metrics

• Sales
• Inventory
• Returns
• Marketing
• Expense management

The Benefits

• Real-time access of all sales data
• Ability to measure impact of various marketing programs