Element / Retail - Localized Currency Views in Sales Dashboards
Localized Currency Views in Sales Dashboards
Problem :
Power BI dashboards displayed all KPIs in GBP, limiting the ability of marketing and sales teams to interpret regional performance accurately. A lack of localized insights hindered decision-making.
Solution :
A currency conversion feature was developed using PySpark to reflect KPI values in USD, EUR, and MEA currencies based on the selected region. The process was integrated into the existing Azure Data Factory pipelines, and results were tested for consistency in Power BI.
Outcome :
The dashboard became region-aware, allowing stakeholders to make informed decisions tailored to local markets. Overall dashboard performance improved by 40%, increasing usability and insight accuracy.