In the initial phase of the analysis, a thorough examination of the source data was done, to ensure that all the essential fields were present. Subsequently data modification, cleaning, and transformation techniques were applied to ensure that the data aligned with the specific requirements for the calculations. Utilizing the Formula Tool, the necessary computations to derive the required fields were met. To focus on addressing the key questions the data was effectively filtered to extract relevant insights.