Client, a multinational consumer goods company, has e-commerce platforms in multiple countries. Client had also instituted a mechanism to generate and socialize multiple ad-hoc reports to understand ecommerce performance and social presence metrics. However, the existing reports only provided status visibility, but did not drive actions or performance management. To overcome these challenges, client wanted to a develop a centralized performance reporting and analytics framework to facilitate standardized performance reporting across markets and to drive centralized strategic initiatives.
INXITE OUT APPROACH
KPI Framework and Data Model Creation
A holistic KPI framework to track the performance of the e-commerce business was developed in consultation with the relevant stakeholders. Exhaustive assessment and gap analysis were conducted on the key data sources (e-commerce platform, Google Analytics, Social Listening tool, etc.) across markets to evaluate the data availability to create a robust data model to support the identified KPI framework
Analytics and AI Data Store Creation
Developed data extraction and transformation pipelines with inline data checks to facilitate automated and incremental extraction of data for each market and storage of the data in the standardized format. Azure ETL stack (Data Factory, Data Lake, Databricks, Synapse etc.) was leveraged to develop the secure and scalable data infrastructure.
Performance Reporting Suite
Developed a suite of dashboards on PowerBI for day-to-day performance tracking and answering key business questions by e-commerce and marketing managers
Management Reporting Suite
Developed a suite of automated PowerPoint reports for management reporting, internal and external bench marking
- Performance Reporting and Analytics platform has been rolled out in 10+ markets
- Performance Reporting and Analytics platform has been adopted as the key data infrastructure for all data and reporting requirements
- Program has been extended to integrate additional markets and additional data sources