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:
The source will always be one of the following:
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....
37 freelancers are bidding on average $105 for this job
I am an Excel expert. I have very good experience with Excel, VBA, Pivot Tables, Charts. I have completed many projects on GAF in Excel skill. I will provide quick & professional service.
very good VBA coder,very familliar with reports, analysis and statistical data.I can offer you more parameters than u asked for in same [url removed, login to view]'s a real bargain