Closed

Excel Dashboard or PivotTable - Floor Traffic/Sales Analysis

This project received 38 bids from talented freelancers with an average bid price of $105 USD.

Get free quotes for a project like this
Employer working
Project Budget
N/A
Total Bids
38
Project Description

We would like a Excel Pivot Table or Excel Dashboard created that uses Sales/Floor Traffic data that we collect at every sale for us to drill down and see where our customers are coming from and when.

We have the following information to use in Excel:
Stock Number
Date
Source
Location
Comments

The source will always be one of the following:
Newspaper
Radio
Television
Location
Friend/Relative
Our Website
Alternate Web
Previous Customer
Other


Ideally we would like to be able to record this information into a Spreadsheet and then use another sheet in the same file to view the data in Graphs or Pivot Tables.

We would then like to be able to see the trends for each Advertising Source (weekly, monthly, yearly) so we can see how many customers come from each source. We can use this data to query how many customers came in off a TV Ad during a time we were running a TV promotion.

We would also like to drill down by Location and show only the sales for that location, during a given period.

Performance of each Advertising Source for the Selected Month/Current Year would be good on a dashboard.

Should be built so that we can keep adding data to the spreadsheet and the data can be queried on (ie. Not built for just the year 2009, will continue to keep working next year)

Example Data File attached....

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

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