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, EUR, MEA) based on the selected region. Pipelines were modified and validated to ensure Power BI reflected accurate conversions.
Outcome :
KPI insights became region-specific and more meaningful. Dashboard performance improved by 40%, helping teams make localized, strategic decisions.