Project Detail

Excel Dashboard or PivotTable - Floor Traffic/Sales Analysis  

Excel Dashboard or PivotTable - Floor Traffic/Sales Analysis is project number 529511
posted at Freelancer.com. Click here to post your own project.

 

| More
Free Trial For New Buyers
 

Status: Cancelled

Selected Providers: -

Budget: $30-250

Created: 10/16/2009 at 0:54 EDT

Bid Count: 38

Average Bid:
$ 105

10/21/2009 at 0:54 EDT

Project Creator: trippo
Employer Rating: (No Feedback Yet)

Bid On This 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....


Additional files submitted:
MarketingInfo.xls

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

125

2 days

10-16-2009 17:51 EDT

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.

help

 

250

5 days

10-16-2009 01:19 EDT

Hello I make this dashboard for you along with reports. I will make you a desktop software that will read input data from excel sheet and then will display desired reports and graphs. All reports will be printable and excel/pdf convertable etc. Let me know Best Regards Umer

help

 

150

6 days

10-16-2009 03:41 EDT

Hi - Please check PM for more information.

help

 

100

5 days

10-16-2009 01:22 EDT

Pls see your PMB. Thanks

help

 

100

5 days

10-18-2009 15:05 EDT

Exceptional quality & Quick work. Please refer to Profile & PMB for details. Thanks FAZ

help

 

245

15 days

10-16-2009 06:25 EDT

Please check PMB. regards

help

 

199

7 days

10-16-2009 14:47 EDT

Please check PMB.

help

 

100

1 day

10-16-2009 10:42 EDT

I can give you all the presentation in excel with graphs charts and all in different forms within a day and put it in a very professional manner with all the color schemes in addition i can also create for you a data base and store this information or give you instructions online , thanks and best regards

help

 

125

5 days

10-17-2009 02:15 EDT

Hi, Please see PM for details. Regards,

help

 

100

3 days

10-16-2009 01:48 EDT

Please see PM

help

 

100

3 days

10-16-2009 13:08 EDT

Hello Please see PM for sample.

help

 

200

7 days

10-18-2009 10:06 EDT

(No Feedback Yet)

Hi I am a highly expericenced statistican. I can do this job, Please seeme at PM. Thanks

help

 

100

1 day

10-16-2009 02:21 EDT

(No Feedback Yet)

we have experience in doing this activity

help

 

90

0 days

10-16-2009 02:56 EDT

(No Feedback Yet)

please read my PM

help

 

50

1 day

10-16-2009 04:20 EDT

(No Feedback Yet)

Please view PMB

help

 

40

1 day

10-16-2009 08:17 EDT

(No Feedback Yet)

Hi, I'm VBA Developer I can do it very easily. Thanks. ITSOLUTION

help

 

75

3 days

10-16-2009 09:01 EDT

(No Feedback Yet)

I am very interesting for this job, and i have an experience for data processing in excell.

help

 

150

2 days

10-16-2009 09:56 EDT

(No Feedback Yet)

I am having a good grip on the VBA Excel automation. i can make the automation for this kind of analysis.

help

 

225

4 days

10-16-2009 10:02 EDT

(No Feedback Yet)

I have expertise in preparing management reports. Good at using excel. This project will give me an opportunity to use my skills. Looking forward to know more about this project.

help

 

90

3 days

10-17-2009 13:18 EDT

(No Feedback Yet)

I am willing to take up this assignment. Value for money is assured.

help

 

75

2 days

10-16-2009 14:25 EDT

(No Feedback Yet)

Hi, I have good experience in excel and can accomplish the task at hand. I look forward to working with you. Best, Koon

help

 

35

3 days

10-16-2009 16:15 EDT

(No Feedback Yet)

Done many times

help

 

120

3 days

10-17-2009 13:01 EDT

(No Feedback Yet)

Dear Sir. We have the good mix of talents with the domain knowledge of Business Intelligence Dashboards and expertise in Excel pivots. Efective drilldowns can be implemented based on the level of interestingness of each KPIs. Thanks

help

 

100

5 days

10-17-2009 21:19 EDT

(No Feedback Yet)

I am pretty good at excel. I can deliver whatever you want in MS Excel.

help

 

100

3 days

10-18-2009 03:16 EDT

(No Feedback Yet)

Interested. I am an Accountant and have worked with excel for many years and hence I can make several pivot based worksheets based on the requirement and the summary in the summary sheet.

help

 

30

2 days

10-18-2009 23:17 EDT

(No Feedback Yet)

help

 

30

1 day

10-18-2009 23:25 EDT

(No Feedback Yet)

I will be able to do this. I have done this before

help

 

150

1 day

10-18-2009 13:37 EDT

(No Feedback Yet)

I am regularly making use of pivot table and graphs on my job.. Further changes to the same project will be free of cost from my side.. :)

help

 

50

2 days

10-18-2009 16:29 EDT

(No Feedback Yet)

Please check your PMB for details of my bid. Regard, J. Singleton

help

 

75

10 days

10-19-2009 15:03 EDT

(No Feedback Yet)

assurance of quality work to be delivered in time

help

 

30

2 days

10-19-2009 12:48 EDT

(No Feedback Yet)

very good VBA coder,very familliar with reports, analysis and statistical data.I can offer you more parameters than u asked for in same money.that's a real bargain

help

 

95

3 days

10-19-2009 22:22 EDT

(No Feedback Yet)

Hi, I am an expert in building Excel reports. Please see your PMB to view a sample report I have built for you using your data you provided.

help

 

30

5 days

10-20-2009 05:52 EDT

(No Feedback Yet)

Will create a Pivot based reoprt , plaese check the PMB

help

 

150

5 days

10-20-2009 09:17 EDT

(No Feedback Yet)

HI I would like to take it up. Please send me some data to get an idea of the work

help

 

30

1 day

10-20-2009 10:07 EDT

(No Feedback Yet)

It's so much easy for me. I have a 10 years experience with excel. I can send you similar files I have prepared before.

help

 

130

15 days

10-20-2009 14:19 EDT

(No Feedback Yet)

Hi , I am interested in your project. As i can expalin you the thing right away . I am Using the software to generate the graphs as per Your needs another sheet in the same file to view the data in Graphs. And the Graphs are given on (weekly, monthly, yearly) as per the customer , If your Interested I can handle this Work . I am giving the detail how to contact me through mailing.

help

 

90

4 days

10-20-2009 16:53 EDT

(No Feedback Yet)

Heres what I can do : Give you all that you need plus more. Comments(only if its not free text) and Locations can also be hard fed so that there are drop downs to be used and minimizes errors. User will be add to add/remove more comment if required. I know exactly what you are llooking for and will give you options for the charts which will best represent your data so that you have a clear picture. You will be able to look at trends in almost any combination you like at the click of a button. What you will do : Maually feed data as and when you have it in the first sheet (as mentioned by you). One excel sheet has a million rows, you will be able to have those many records. For more than that is possible but will cost more. I will also build in a small "What If" module.

help

 

50

2 days

10-21-2009 00:00 EDT

(No Feedback Yet)

I have 10 years of experience in the IT field and I'm familiar with developing this kind of dashboards using Cognos and Excel.

help


    Bid on this Project