The analysis was carried out by extracting the text document, cleaning and transforming the data then loading it to PowerBI desktop for visualization.