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 :
A PySpark script was built to automate reading taxonomy files from Azure Data Lake and generate updated navigation scores. An ADF pipeline was created with scheduled triggers and email alerts to ensure timely, error-free execution.
Outcome :
The process is now fully automated, eliminating manual intervention. Dashboards remain current, accuracy has improved, and incident frequency has dropped to zero.