usiness Intelligence and Analytics ote: This case study is designed to work with the Excel file titled AmazingMartEU2.xlex file available in he Course Content | Visualization folder on the class website. Save it to your desktop. his assignment is less structured than the earlier visualization assignments, and will be graded using e rubric on the assignment page of the class website (and provided below). Please review the rubric efore submitting your assignment as it shows the point allocation for appropriate use of one or more ata views, which display the appropriate data fields, headings, labels, sorting and colors to address each the seven questions below. Your visualizations should be formatted to provide the best information resentation to the user. reate one or more data views or dashboards to show: 1. Overall profit by product category 2. Top 3 most profitable product sub-categories (i.e., with the highest amount of profit) 3. Top 10 most popular products (i.e., with the highest quantity) 4. Bottom 5 cities by profit margin ratio (i.e., profit-to-sales ratios). You will need to create a calculated field and the result will be a ratio or percentage. The ratios will be negative because these cities have a negative profit (loss). 5. Profit by country 6. Profit by region. What percentage of total profit is earned in each region? 7. Month-to-month profit trends. Consider both (1) months only and (2) months over several years to better understand the trends. In other words, create two charts