Đang Thực Hiện

Simple Data Mining

I manage a promotional company selling merchandise and clothing items to businesses and sporting clubs, etc. Our most common products include tee shirts, polo shirts, caps, printed pens, stress balls, can holders (koozies), etc.

I have exported a sales report out of my industry specific accounting software package into excel (see attached). It shows the orders taken by our organisation in the last 8 weeks (approx 200 orders). These orders are seperated by sales reps.

I need to accurately get a figure as to what is our average number of products per order for each of our main sales people (Emma Dawson, Emma Fairless, Kris Grattan, and Varsity). I cannot get a report to show me this as my software includes, artwork, setup, printing, embroidery, etc as products. However I just want the products to count, not the decoration and printing.

Can someone go through these and give me the average number of products per order for each sales rep? This is a simple project that I do not expect to have to pay much for.

Kỹ năng: Khai thác dữ liệu, Excel

Xem thêm: my emma, get sales rep, data mining sales, kris grattan, sales rep company, the tee, tee shirts, sporting, printing sales, polo, kris, decoration, data printing, data mining software, data mining simple project, data mining company, sales project report excel, clothing data excel, package selling, company industry data, businesses data, excel count, mining simple project, company rep, tee company

Về Bên Thuê:
( 25 nhận xét ) Sale, Australia

Mã Dự Án: #1019058

Đã trao cho:

muthumuni

Hi sir kindly check your massage box

$30 AUD trong 0 ngày
(7 Đánh Giá)
3.8

9 freelancer đang chào giá trung bình $45 cho công việc này

SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$150 AUD trong 5 ngày
(14 Đánh Giá)
5.8
dataconsultants

Please check PMB for details, Thank you

$33 AUD trong 1 ngày
(51 Đánh Giá)
5.3
simplicityq88

Don't accept no ones bid, wait 15 minutes!

$30 AUD trong 0 ngày
(44 Đánh Giá)
4.8
oFAZo

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

$40 AUD trong 0 ngày
(11 Đánh Giá)
3.7
Shijidhar

Hai Please check PM. Thank you

$30 AUD trong 1 ngày
(5 Đánh Giá)
3.7
mohit14s

It can be done easily by putting each row for each item sold along with its order number, date, sales representative in a database table - Then we can draw out any report of any kind with a simple SQL query. I can do Thêm

$30 AUD trong 2 ngày
(0 Đánh Giá)
0.0
DesignMasr

kindly check PM.

$30 AUD trong 1 ngày
(0 Đánh Giá)
0.0
manojmalhotra987

Find the sample for Emma Dawson. Please check PM

$30 AUD trong 0 ngày
(0 Đánh Giá)
0.0