info systim _ Excel work

Complete the two reports, general questions and what-if analysis included within the attached workbook and upload it. During the class you will be asked individual questions based on the file you submitted. You also need to provide 10 insights about the data you are analyzing. For out years (2,3,4) assume the same revenue per customer unless you are answering specific questions that require further analysis.

Note that the dataset has detailed transactions which must be converted to USD and summed as part of your analysis. If you need additional rows, just add them to the spreadsheet. I strongly recommend that after you cleanse the data, you use pivot tables for the reports and analysis.

Key formula sample:

=SUMIF(B2:B1018,”<>Aikin”,K2:K1018)