HIBS Nike & Gap Fashion Analysis Visualization & Key Performance Metrics Worksheet
Question Description
Hello, I need you to make 2 dashboard in excel as the one I provide below for any of the industries in the list. After that you have put in the word document as I placed it below.
Financial Dashboards”
- Select ONE of the following industries of interest
- FinTech
- Asia Tourism
- Packaged food South America
- Beer & Wine Europe
- eCommerce Asia or Africa
- Fashion
- Auto Insurance
- Select 2# companies from the industry that you have chosen. Both the companies should be in the same country.
- Dashboard#1: to showcase a Compare and Contrast of main KPIs that you think are essential to compare and contrast the 2# companies.
- Use the bottom space in Dashboard# 1 to give your 3# recommendations.
- Based on your analysis, which One of the Two companies would you suggest to “look-out ” for / Partner with/ invest in. Please be specific in your recommendations supported with specific data.
- Dashboard#2:Will focus / zoom-in on the company that you “suggest” based on Dashboard# 1.
- You can compare your company against industry averages for metrics that you think are essential to highlight the company.
- You may download the financials of the companies from Publicly available information, and trusted sources such as Mergent, IBIS, D&B Hoovers, Company’s Annual Reports etc.
- Make sure to cite your sources on a separate sheet in your Excel workbook.
Your submission on Canvas:
- Excel workbook – Financial Dashboard:
- What are the 2# companies that you chose?
- You can select your charts from any of the dashboards that we reviewed in-class.
- Additionally, you can also choose to create other Chart formats in Excel.
- Print-Preview of each of your Dashboard should be only on ONE page.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."