Virtual Internship offered by Forage
For this virtual internship, I had to do 3 main tasks:
- Data Quality Assessment (Assessment of data quality and completeness in preparation for analysis)
- Data Insights (Targeting high value customers based on customer demographics and attributes)
- Data Insights and Presentation (Using visualisations to present insights)
For the Data Quality Assessment task, I had to go through the KPMG_raw_data_update_final.xlsx dataset and ensure the readines for the analysis in the second step. After identifying the data quality issues (Sprocket_Copy.xlsx), I had to write an email(Email.pdf) to the customer to let him know what the quality issues were.
In the second step I had to prepare a detailed approach for completing the analysis including activities – i.e. understanding the data distributions, feature engineering, data transformations, modelling, results interpretation and reporting and present it all in a Powerpoint presentation(Sprocket_Copy.pdf).
The third step was to visualize the insights with a visualization tool, in this case with Power BI, and the dashboard can be accessed here Spreadsheet.pdf.