I have a data analysis task to use the excel pivot tables. Data Analysis Report
Imagine the following scenario - You are hired as the new assistant to the executive board. You are asked to prepare a meeting for tomorrow, in which the board will expect a full briefing based on the data you have been given (raw data set). Remember, they already know the data - your job is to reveal the trends, patterns, find information, dig for the hidden gems that will help the organization improve!
Do the data analysis and creation of visuals in your excel file – save it with a file name reflecting that work - include your name in the file name please. You should end up with tabs like the following snip, at a minimum. Submit this file along with your finalized project.
Tabs: Data, Overview, Sales Overview, Sales Overview Diagram, Top Customers, Top Customers Diagram, Top Products, Top Products Diagram, Top Regions, Top Regions Diagram
At a minimum, you must discuss the following questions, and offer visual support for each:
Sales Overview:
How have sales developed in 2013 – compared to the year before?
Who are the top 10 customers in each year? What changes can be noted?
What are the top 10 products in each year? What changes can be noted?
How are sales distributed over the regions? Have shifts occurred?
What else might be helpful?
TIP: You should be able to produce visuals that look similar to these snips:
Dear Hiring manager,
Hi thank you for looking at my proposal. I would like to work on your project. I have been in this industry for 4 years and these jobs are my daily practice.
I have a sound knowledge in Statistics (Bsc Special) and familiar with almost all the statistical softwares like Excel, Minitab, SPSS, SAS, R and etc. Doing statistical analysis is my passion. You can check profile for the feedbacks which I got these similar type of works.
I can assure you that if you work with me once, you will always work with me for these kind of projects. I’m very much interested, Contact me soon so that we can discuss further things.
I’ll be available to you when you need me and you can contact me anytime through freelancer.
I can complete your project on time and within your budget.
Regards
Mugunthan
$55 USD in 1 Tag
4,9 (13 Bewertungen)
4,7
4,7
6 Freelancer bieten im Durchschnitt $43 USD für diesen Auftrag
I am a professional freelancer having expertise in MS Excel and I can complete your task effectively and efficiently in a timely manner.
Portfolio: https://www.freelancer.in/u/KavTan.html