Question
in excel and formula please, i want to complete the following requirements, you will need to create any calculated field or measure you will need
in excel and formula please, i want to complete the following requirements, you will need to create any calculated field or measure you will need to complete the analysis inside the data model. All price calculations are to be rounded up to two decimal places and formatted as currency.
1- In the Manager Performance worksheet, create a Pivot Table from your data model that shows annual sales manager performance per product category. This pivot table needs to compare the total sales by sales managers for each year (as a column).
2- In the Timeline worksheet, create a Pivot Table from your data model that shows all sales amounts by sales manager over time (at the year level - as a column). Use a timeline to display sales for 2007 and 2008.
3- In the Countries worksheet, create a Pivot Table from your data model that shows total sales to different countries for each year individually. To visualize sales to the countries, create a bar chart showing the purchases by countries. Add data labels to the highest sales amount in each year. Format the chart appropriately for ease of understanding the data.
4- In the Profitability KPI worksheet. create a Pivot Table from your data model that shows profitability of each sales manager. To do this, you will need to create a KPI that assesses profit by manager (Profit is Unit Price - Cost). Set your first milestone to 500,000. Set your second to 1,000,000. Pick a visualization that suits the data. Use this KPI in your Pivot Table to display a symbol for each manager's profit.
(Sales managers worksheet) A B C 1 Category SalesManager Office 2 Bike Racks Maurizio Macagno Redmond up to # 18 (Sales Worksheet) A- Product Category B-Sales Manager C-Product Subcategory D-Product Code E-Product Name. F-Color. G-Model Name H-Order Quantity I-UnitPrice J- Product Standard Cost K-Slaes Amount L-OrderDate. M-Month Name N-Month Number O-Year. P-CustomerName Q-Marital Status. R-Gender. S-Education. U-Territory Region. V-Territory Country. W-Territory Group.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started