Excel Dashboard or PivotTable - Floor Traffic/Sales Analysis

  • Status Closed
  • 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....

Get free quotes for a project like this

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