Dynamic Reporting System for Retail Franchise

This case study presents the development of a dynamic reporting system for a leading retail franchise business with over 300 locations in the US. The franchise faced challenges in analyzing operational data from a non-relational database, which necessitated the creation of a robust reporting system using AWS and Power BI. The case study outlines the problem statement, detailing the inefficiencies of manual data checks and the inadequacy of existing CRM reports. The solution involved several steps, including data extraction and loading using Python scripts, data transformation to create robust relationships among tables, and the establishment of a user-friendly reporting interface. The implementation addressed challenges such as handling complex JSON formats and duplicate records while optimizing performance for large datasets. The resulting system provided over 30 accurate reports, enhancing data accessibility and decision-making processes for stakeholders. Overall, the new reporting framework significantly improved operational insights and maintained client confidentiality.