A loyalty platform catering to multiple retail brands managing their customer loyalty rewards and analytics resulting in complex reporting requirements
Time taken in transaction level data refresh was often resulting in errors in data refresh pipelines in Power BI as it’s a full refresh of the entire data
Maintenance, performance and robustness of the Power BI architecture was not in alignment with the growth in customers and multiple reporting requirements
Approach
Consulting engagement to review Data Modelling, reports and Power BI architecture
AS IS study
Data Quality and Sufficiency
Alternate Data Sources and Connectivity
Data refresh process
Historical relevance and quality
Power BI reports
Power BI strategy
Power BI user governance
Data security
Recommendation
High level outline of target “To Be” Architecture
Roadmap definition over short-medium-long term
Achievements
Robust architecture having an ETL layer to cloud data warehouse that will help manage data size growth at Power BI layer as client scales to 200+ customers
Establishment of an ETL layer configured to support incremental data refresh - only the most recent data that has changed needs to be refreshed resulting in elimination of refresh cycle failures and high improvement in report performances
Cost optimization by implementing row level security, parameterizing Power BI reports, leveraging Power BI workspaces to manage custom reports.
