Cancelado

Excel Dashboard or PivotTable - Floor Traffic/Sales Analysis

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....

Habilidades: Anúncios, Excel, Marketing, Estatísticas

Ver mais: sales dashboard excel, excel pivot table dashboard, dashboard excel stock sales, floor pivot table, we excel, see web traffic, graphs uses, excel 16, example graphs, advertising radio, sales dashboard pivot table, advertising dashboard excel, advertising excel dashboard, excel sales dashboard, uses excel, excel uses, television marketing, customer data excel, us traffic, tv ad, sales sheet, sales excel, sales dashboard, radio ad, pivot tables

Acerca do Empregador:
( 0 comentários ) CAIRNS, Australia

ID do Projeto: #529511

38 freelancers estão ofertando em média $105 para este trabalho

vserv

Pls see your PMB. Thanks

$100 USD in 5 dias
(53 Comentários)
5.6
dev3dworx

Please check PMB.

$199 USD in 7 dias
(19 Comentários)
4.7
ExactSystems

Please check PMB. regards

$245 USD in 15 dias
(2 Comentários)
4.3
oFAZo

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

$100 USD in 5 dias
(10 Comentários)
3.8
nmppatel

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.

$125 USD in 2 dias
(9 Comentários)
3.7
Lucvba1

Done many times

$35 USD in 3 dias
(1 Comentário)
3.6
edatawiz

Hi - Please check PM for more information.

$150 USD in 6 dias
(7 Comentários)
3.3
oluoch

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 b Mais

$100 USD em 1 dia
(2 Comentários)
2.9
win4t4

Please see PM

$100 USD in 3 dias
(1 Comentário)
1.9
vs1978

Hi, Please see PM for details. Regards,

$125 USD in 5 dias
(1 Comentário)
1.4
intelprince716

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.. :)

$150 USD em 1 dia
(0 Comentários)
0.0
jsingleton

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

$50 USD in 2 dias
(0 Comentários)
0.0
onuoctav

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

$30 USD in 2 dias
(0 Comentários)
0.0
karan2611

assurance of quality work to be delivered in time

$75 USD in 10 dias
(0 Comentários)
0.0
udaras

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

$30 USD em 1 dia
(0 Comentários)
0.0
josefo

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.

$95 USD in 3 dias
(0 Comentários)
0.0
Auricle

Will create a Pivot based reoprt , plaese check the PMB

$30 USD in 5 dias
(0 Comentários)
0.0
navinjayanand

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

$150 USD in 5 dias
(0 Comentários)
0.0
latifoglu80

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.

$30 USD em 1 dia
(0 Comentários)
0.0
damodharreddy

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. A Mais

$130 USD in 15 dias
(0 Comentários)
0.0