Dashboard of CRM and sales data

I want a "living" dashboard in the form of a google drive sheet showing current tally of weekly sales value for all customers. This sheet will be linked to xero and constantly update w new customers.

That is to say: customers down the left most column and weeks across the top row. (That way I can watch for trends in purchase volume, missing weeks, order frequency).

The sheet will also have the capacity to show a colour for missed weeks, average order value for customer (and identify below average weeks and more.

I'd like this data right away. Additional data that can be added later as follows:

Additional tabs on the same sheet will show:

- reports that Steve Fordham has initiated: ie Income by contact; sales revenue by value group; sales by customer; sales by product)

- bar graphs of total sales volume by month in one colour and previous year's values in another colour.

- weekly sales by product (original, pumpkin, banana, coconut cacao, maca chilli, 5 packs) in a line graph

- total sales by channel (cafe/restuaraunt, distributor, markets, health food store, supermarket/cafe, online sales).

- labour cost vs sales by week/month

- freight income vs freight expense

- credits, returns, complaints, wastage by week

- tastings and promotions vs sales (some way to track response and rhythms and quantitative value of our marketing efforts)

- additional customers per month

- insta follower growth

NOTE: I should be able to easily pull out (identify at least, but optimally pull into a sheet) data pertaining to the above as it relates to regions, states, distributor areas, areas that a particular sales person is responsible for, areas or customer groupings where I have recently done a sales trip (so that I can measure a value of a particular activity).

Dovednosti: Účetnictví, Zadávání dat, Zpracování dat, Excel, PHP

Zobrazit více: sales dashboard salesforce, sales manager dashboard salesforce, sales dashboard, salesforce dashboard, crm dashboard examples, best crm dashboards, crm reports samples, crm dashboard design, freelance dashboard crm 2.0, dashboard user activity, dashboard crm open source, excel staff activity dashboard, safety health dashboard, crm activity hsbc, nvq health social care activity

O zaměstnavateli:
( 0 recenzí ) Australia

Identifikační číslo projektu: #17186989

33 freelanceů na tento projekt zveřejnilo nabídku v průměrné hodnotě $480

$250 AUD za 10 dní
(324 Recenzí)

Greeting from Bluewebspark technologies !! We have excellent team of programmers and designers to work on your project efficiently and complete job in time. We have read your deepest requirement at our best and will s Další

$750 AUD za 10 dní
(204 Recenzí)

Hello, I’m an Excel/VBA expert and I would like to help you with your dashboard. Please check my profile and contact me to discuss. Regards.

$750 AUD za 10 dní
(274 Recenzí)

Hello, First of all, its my pleasure to bid on your project, I have gone through your requirements and understand that you need a custom CRM. We are a highly skilled team to provide you the best experience. We are r Další

$500 AUD za 15 dní
(57 Recenzí)

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$500 AUD za 7 dní
(203 Recenzí)

Hi, Hope you are doing great!! I have performed all the mentioned duties upon reference to your job posting and assure you that you’ll get all the expected stuff like a great professional service and a fast turn Další

$750 AUD za 10 dní
(34 Recenzí)

Hi, I have gone through your website Please share list of features you want I read through the Project details extremely carefully and I am absolutely sure that I can do the project very well. I Další

$555 AUD za 10 dní
(83 Recenzí)

Dear,sir. How are you? I hope you are doing well. I have read your project description. And I can assist you to develop your Web App as I have more than 6+ years of strong experience in Web development/designing and Další

$555 AUD za 10 dní
(23 Recenzí)
$250 AUD za 1 den
(123 Recenzí)

mphill in computer engineering having seven years of experience in dashboard designing.

$250 AUD za 1 den
(38 Recenzí)
$500 AUD za 7 dní
(57 Recenzí)

I can perfectly do your project work and able to complete full work in a shortest possible of time with 100% accuracy, perfection and according to your given instruction. I am ready to show you cost-free sample wo Další

$444 AUD za 10 dní
(33 Recenzí)

Contact me for ready CRM.... Contact me for ready CRM.... Contact me for ready CRM.... Contact me for ready CRM.... Contact me for ready CRM.... Contact me for ready CRM.... Contact me for ready CRM.. Další

$750 AUD za 10 dní
(24 Recenzí)

I have gone through the details and I'm confident to work with my experience in similar projects. If you award your project, I'll start from now and complete the work accurately and timely. Also, I'll update you the pr Další

$250 AUD za 5 dní
(23 Recenzí)

Hello, my name is Sasha. I'm CEO of [login to view URL], software integrations company from Kyiv, Ukraine. We work with built from scratch (Laravel) and open source CRM/ERP systems, management dashboards and solutions for busi Další

$555 AUD za 10 dní
(5 Recenzí)

Hi there, I would like to discuss your requirements in more details, can you please come on the chat to discuss? Thanks

$555 AUD za 10 dní
(4 Recenzí)

Thank you for posting a Job. I WILL DO THIS AS PER YOUR REQUIREMENT AND EXPECTATIONS. With the experience of over 300+web development projects including ANDROID, IOS, WEBSITES, WEB APPLICATIONS AND SOFTWARE Další

$555 AUD za 10 dní
(3 Recenzí)

Hello. I am Andrey and have experience for developing accounting systems like ERP, CRM, analytical reports. If you agree with full web-application(PHP, MySQL) so i can help you. If you want the solution based on go Další

$833 AUD za 10 dní
(8 Recenzí)

Greetings, You project caught my attention because I have experience in creating sales dashboard and generating statistics from it. I have used the information you provided to make this prototype that highlights bl Další

$250 AUD za 3 dní
(2 Recenzí)

Hello, I’m pleased to send you my proposal for your project. As an experienced auditor, I have expertise in compiling large amounts of data from multiple sources to produce different kind of reports and develope KP Další

$277 AUD za 5 dní
(1 recenze)