Goal: Reduce workload time from 14+ hours to <1 hour through performance optimization

We successfully optimized a customer’s performance and Reduce workload time around 14 hours to under an hour. Allow me to share the details of how we achieved this impressive feat. The system is designed to receive data from external systems and can be categorized into different dimensions for analysis. The analysis process involves externalizing important formulas to give users better access to data and applying various algorithms to extract information from the dimensions generated from each record.