Problem Statement:
The company needed a real-time solution to track and analyze redemption activities across multiple business units, as existing processes lacked timely insights, hindering effective decision-making and trend identification.
Tools and Technologies:
- Azure Data Factory, Microsoft Power BI, Azure SQL
Summary:
- Developed a real-time data dashboard using Power BI to monitor and visualize redemption activities across multiple companies.
- The dashboard includes hourly comparison graphs, yearly redemption summaries, and company-specific redemption data.
- Enabled dynamic filtering to allow users to analyze redemption trends by individual companies.
- The tool effectively tracked over 1.3 million redemptions in 2022 and over 866K redemptions in 2023, providing actionable insights for stakeholders.