I would like to hire an Excel Expert -- 4

Tämä projekti päättyy tänään ja sen keskivertotarjous on 25 $(USD) .

Pyydä ilmaisia tarjouksia samanlaisesta projektista
Projektin budjetti
$10 - $30 USD
Huutoja yhteensä
Projektin kuvaus

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:

Vaaditut taidot

Haluatko ansaita rahaa?

  • Aseta budjettisi ja määräaika
  • Hahmottele tarjouksesi
  • Saa maksu työstäsi

Palkkaa freelancereita, jotka tekivät myös tarjouksen tästä projektista

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