Overview: It is essential for a business professional to develop spreadsheet software skills for analyzing a variety of business situations using quantitative means.
This project takes a hands-on approach by placing you in a real-world context. You will utilize technical concepts to interpret a business framework and apply selected quantitative techniques to arrive at accurate information that can be used for sound decision-making.
Specifically, you will assume the role of a business analyst working for a winery in northern California. In this milestone, you are provided a set of raw data, and, from that data set, you must respond to questions from management. You will calculate and present your answers in a consumable way using spreadsheet software.
Prompt: Review the critical elements below and then examine the Excel 2013 Bible chapters assigned for Module One as well as the Final Project Excel Functions document.
Select a function that you believe will help you answer the following questions based on an analysis of the final project raw data set provided.
Specifically, the following critical elements must be addressed:
1. What were total sales by salesperson?
2. What were the total sales of red wine in California over the last six months? Draft this answer graphically and in a way that shows each different salesperson's sales.
3. Which types of wine were the best and worst sellers? Again, draft this answer graphically showing all wine sales by type of wine.
Attachment:- Project raw Data.rar