I would like to hire an Excel Expert -- 4

Dette projekt slutter om 4 dage og har et gennemsnitligt bud på $25 USD.

Få gratis pristilbud for et projekt som dette
$10 - $30 USD
Bud i alt

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:

Færdigheder påkrævet

Ønsker du at tjene nogle penge?

  • Fastsæt dit budget og din tidsramme
  • Beskriv dit forslag
  • Bliv betalt for dit arbejde

Ansæt Freelancere, der også bød på dette projekt

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online