Excel Spreadsheet

Part 1: Download the data file bikesales_2018-2019.xlsx and save the file. Be sure to create a table for your data. Create three PivotTables and Charts to show the following information: a. Total Sales by Product Category and Country b. Total Sales by Year, Product Category and Product (include drill down capabilities on your dashboard to the product level) c. Total Sales by Country and Distribution Channel Part 2: Dashboard On a separate worksheet labeled “Dashboard,” create an interactive dashboard showing the sales information for the company. Add a title and professional formatting to your dashboard and insert slicers so the data can be filtered by product category, distribution channel, and country. (see example on page 2). Please be creative with your dashboard and insert your own design elements (logo, colors, fonts, layout, etc.).