Trade Inventory Simulation Platform
Element / Retail – Trade Inventory Simulation Platform Trade Inventory Simulation Platform Problem : Sell-out data simulations were manual, lacked version control, and took significant time to validate. Cross-department collaboration suffered due to low transparency. Solution : A React-based interface supported by a GCP backend allowed users to simulate sell-out scenarios. Users could compare KPIs […]
Psychological Pricing Impact with Round Price Simulator
Element / Retail – Psychological Pricing Impact with Round Price Simulator Psychological Pricing Impact with Round Price Simulator Problem : Marketing teams needed insights into how rounded price thresholds (e.g., €1.99 vs. €2.00) impacted sales volume to drive promotion effectiveness. Solution : Historical sales data was analyzed over 3 years. Sales volume changes were grouped […]
Sales Dashboard Currency Localization
Element / Retail – Sales Dashboard Currency Localization Sales Dashboard Currency Localization Problem : Sales dashboards displayed all KPIs in GBP, limiting the ability of regional sales and marketing teams to analyze performance in local currencies. Solution : A PySpark script was implemented to convert KPIs into local currencies (USD, EUR, MEA). Changes were tested […]
Automating Nielsen Product Data Mapping
Element / Retail – Automating Nielsen Product Data Mapping Automating Nielsen Product Data Mapping Problem : Manual mapping of Nielsen product descriptions to regional sales data was time-consuming and error-prone. Mistakes affected KPI accuracy and dashboard usability. Solution : An NLP script was developed to automatically map Nielsen product descriptions with sales data from Azure. […]
EU PDS Dashboard Acceleration
Element / Retail – EU PDS Dashboard Acceleration EU PDS Dashboard Acceleration Problem : The EU PDS dashboard consumed 1.28B records daily from eFundamentals, with pipeline execution taking 6+ hours and incurring high Azure compute costs. Solution : Spark partitioning, delta table compression, and selective data overwrite logic were applied using PySpark and Databricks. The […]
Automating Taxonomy Mapping for Navigation Scores
Element / Retail – Automating Taxonomy Mapping for Navigation Scores Automating Taxonomy Mapping for Navigation Scores Problem : Manual updates to the taxonomy mapping file every Mars period introduced risks of human error and data staleness in Power BI dashboards. Any missed updates resulted in outdated navigation scores, misleading KPIs, and stakeholder dissatisfaction. Solution : […]