Trade Inventory Simulation for Sell-Out Data
Element / Retail – Trade Inventory Simulation for Sell-Out Data Trade Inventory Simulation for Sell-Out Data Problem : Simulating sell-out data was a manual and fragmented process. Older simulation versions were hard to track, validation was time-consuming, and collaboration between departments lacked transparency. Solution : A React-based frontend with GCP backend allowed users to simulate […]
Local Currency Conversion in Sales Dashboard
Element / Retail – Local Currency Conversion in Sales Dashboard Local Currency Conversion in Sales Dashboard Problem : All KPI values were displayed in GBP on Power BI dashboards, creating confusion for regional sales and marketing teams in interpreting localized performance. Solution : A PySpark-based solution was integrated to convert KPIs to local currencies (USD, […]
Automated Nielsen Product Mapping
Element / Retail – Automated Nielsen Product Mapping Automated Nielsen Product Mapping Problem : Manually mapping Nielsen product data to regional sales datasets led to inconsistent KPIs and heavy dependence on the support team. Mistakes in mapping degraded dashboard accuracy and triggered frequent incident reports. Solution : An NLP-powered pipeline was developed to automatically read […]
EU PDS Dashboard Performance Optimization
Element / Retail – EU PDS Dashboard Performance Optimization EU PDS Dashboard Performance Optimization Problem : The EU PDS dashboard consumed 1.28 billion records daily from eFundamentals, leading to long pipeline run times (6 hours) and high Azure compute costs. This slowed reporting and escalated operational costs. Solution : Pipeline optimization was performed using Spark-native […]
Taxonomy Mapping Automation for Navigation Scores
Element / Retail – Taxonomy Mapping Automation for Navigation Scores Taxonomy Mapping Automation for Navigation Scores Problem : Manual updates to the taxonomy mapping file each Mars period often resulted in missed schedules, data quality issues, and stale navigation scores in Power BI dashboards. These delays impacted stakeholder trust and reporting reliability. Solution : An […]
Round Price Impact Analysis in France Simulator Tool
Element / Retail – Round Price Impact Analysis in France Simulator Tool Round Price Impact Analysis in France Simulator Tool Problem : The marketing team lacked visibility into how round price thresholds (e.g., €1.99 vs €2.00) influenced sales volume. The pricing model didn’t account for psychological price sensitivity. Solution : Three years of historical sales […]