You are the marketing manager of a car manufacturers (the brand will be assigned by the instructor) and you are requested to prepare a Marketing Metrics Dashboard for the board of directors and other executives to monitor the performance of the premium SUV cars of the company in the US and the Canadian markets.

The data of all brands are provided in a supplementary Excel file titled Raw Data. You are required to review the Excel Worksheet provided and create the following data and charts (you are required to choose the most suitable chart type unless specified in the instructions):

1. Monthly Sales of your brand in US and in Canada
2. Market Share of your brand in US and in Canada in units and in dollars
3. Brand Development Index of your brand and Category Development Index Assuming the Canadian Population at 37m and US population at 331m
4. Brand Penetration Share of your brand in US and Canada
5. Map Chart showing sales of your brand in USA and Canada
6. Pivot Chart of your Market Share in Canada represented in a pie chart
7. A separate sheet with 3 Discussions and 3 recommendations based on the data and analysis