Salesman performance anlysis.

[mtahboub]

Hello Everyone,

I recently opened up a retail store. Transactions are completed in a POS system that allows me to download reports. They are however not sufficient for me to do the analysis I need - hence I need excel help please!

I am trying to create a dashboard to measure individual and group sales performance using the raw data I download from the POS reports.

Can anyone help? the file is viewable on the link below:


https://docs.google.com/spreadsheets/d/1gExEyme9LPGsqG4bf36U6EQcFaAKDmNJ_5rrw5VS7Xo/edit?usp=sharing


Thanks one and All.
MT

 

[iggy_]

Is there any other way that the POS produces the data, for example just entire list of sales with the sales person next to sale information. something like in the example below. This will make it a lot easier to pull in the information you need for each individual salesperson.

Rows, 6-9 are pretty straight forward, i put those in your sheet, let me know if that works.


<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 106px"><col width="76"><col width="74"><col width="120"><col width="268"><col width="101"><col width="90"><col width="47"><col width="81"><col width="132"></colgroup><tbody>[TR]
[TD="align: right"]James Isidro[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]04-28-2018[/TD]
[TD]alia[/TD]
[TD]Magnolia Heights EDP 100ml[/TD]
[TD="align: right"]5060284040449[/TD]
[TD]NA[/TD]
[TD="align: right"]838.95[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]838.95[/TD]
[/TR]
</tbody>[/TABLE]
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 106px"><col width="76"><col width="74"><col width="120"><col width="268"><col width="101"><col width="90"><col width="47"><col width="81"><col width="132"></colgroup><tbody>[TR]
[TD="align: right"]James Isidro[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]04-30-2018[/TD]
[TD]waser[/TD]
[TD]Tenue de Soirée EDP 100ml/3.4 Fl.Oz[/TD]
[TD="align: right"]711367122006[/TD]
[TD]NA[/TD]
[TD="align: right"]729.75[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]729.75[/TD]
[/TR]
</tbody>[/TABLE]

 

[jasminethomson]

Can please guide: Is CISePOS POS Software Reliable for my retail store. I wish to buy that software but need recommendation before my final purchase.