Find Jobs
Hire Freelancers

Dashboard of CRM and sales data

$250-750 AUD

Closed
Posted almost 6 years ago

$250-750 AUD

Paid on delivery
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).
Project ID: 17186989

About the project

33 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
33 freelancers are bidding on average $480 AUD for this job
User Avatar
Hi there, I would like to discuss your requirements in more details, can you please come on the chat to discuss? Thanks
$555 AUD in 10 days
5.0 (4 reviews)
0.0
0.0
User Avatar
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 Responsive designing. Skills: Wordpress,PHP, HTML, CSS, UI/UX, Mysql, jquery, javascript, HTML5/CSS3, AJAX, etc. Also, I have deep knowledge in wordpress theme and plugin customization. Please elaborate your requirements in more detail so that i can quote you for the exact work of your website. Please have a look on my work in web development . . Looking forward to work with you and developing a long term business relationship. Thanks.
$555 AUD in 10 days
4.9 (25 reviews)
0.0
0.0
User Avatar
mphill in computer engineering having seven years of experience in dashboard designing.
$250 AUD in 1 day
4.8 (40 reviews)
0.0
0.0
User Avatar
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 work for the project right now. I can say undoubtedly that I am the right person for whom you are looking for the project. Let’s discuss in PM so that we can start working on your project right away. I am waiting to have your quick positive reply. Thanks.
$444 AUD in 10 days
4.8 (33 reviews)
0.0
0.0
User Avatar
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 in 10 days
4.9 (278 reviews)
0.0
0.0
User Avatar
Hello my name is Haneen, I am professional php web developer. I can what do you need please give me chance. please contact me. Thanks
$555 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 7 days
5.0 (210 reviews)
0.0
0.0
User Avatar
I made recently dashboard of quality parameters for call center if You are interested in of how it looked like please contact me and I show You some samples. Sheets are my passion and can spedn hours fiddling with them :)
$277 AUD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir/Madam: I offer to make your Dashboard. I can offer 4 hour per day till finish, I estimate deliver in 6 days first working system, to finish in 14 days. Full services: programming, PM, technical translation/writing. Expertise since 90s. Software architecture and engineering. Personalized service, full back-end and front-end programming. Background Samples at my portfolio tsftportfolio wordpress com, Office apps VBA, ERPs, scripting, ETL, DBA, SysAdmin, Wordpress, Python, .NET, Clarion, PHP are part of my skills and experience, including UML, BPMN as well as GIMP for graphic design. Remote Work -Online distance working -Online collaboration: easier system for you. -Daily communication automatized workflow. -Extreme programming, Agile methods. Kind regards.
$333 AUD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 google sheets, form so my opinion this is not very good. Because of low performance, low responde on users action. Moreover it is required to create role based authentication usually. Thanks.
$833 AUD in 10 days
5.0 (9 reviews)
0.0
0.0
User Avatar
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 progress on a daily. Thanks
$250 AUD in 5 days
4.8 (23 reviews)
0.0
0.0
User Avatar
Good day! I've been doing data entry, admin work, lead generation and even market research for more than 7 years now. I'm a very persistent person as I always put my heart in everything that I do. My profile, skills on my account here including my LinkedIn profile says it all. No promises but tried and tested with results and my deadlines. Let me know when to start and I'd be glad to help you in any way. Give it a shot and I'll offer what you truly deserve in terms of my craft. #TryMe #YouWontRegretIt Looking forward to work with you in the soonest possible time, let me know when... Stay blessed! =) Please see my skills below for reference...  SKILLS: • Admin work, reporting, encoding/data entry • Internet Marketing • Recruiting, Contract Recruitment • HR Strategy • HR Development and Planning • Account Management • New Business Development • Lead Generation • Pre-sales, Solution Selling & Sales Process • Business Relationship Management, Key Client Relationship, Client Development OTHER SKILLS: • Computer Literate • Both efficient in oral and written English • Can work under pressure with minimal supervision. • Is flexible and can easily adapt to different kinds of situation and environment. MARIEFIE M@f!:) MOJICA (+63) 0927.487.7888 "Give your stress wings and let it fly away..." "It’s not about being the best,      It’s about being better than you were yesterday..."
$666 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 KPIs and dashboards. You can see in my profile that I have experience in a variety of tasks. Now I'm working on becoming a freelancer, looking forward to engaging in new projects. Please feel free to contact me anytime. Thank you, Regards, Angélica
$277 AUD in 5 days
5.0 (1 review)
0.0
0.0
User Avatar
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.... 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.... Contact me for ready CRM.... Contact me for ready CRM.... Contact me for ready CRM....
$750 AUD in 10 days
4.4 (24 reviews)
0.0
0.0
User Avatar
Hey! I'm KASERP I have reviewed your complete job description. I have fully understood your requirements and I fulfill all the qualifications required for this project. Quality work is my Priority. Let’s discuss rest details over chat. THANKS Regards KASERP
$250 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there, I am HR of Dipsun Technology. This is a leading Accounting and Taxation firm with over 5 years of experience in the field of Account and Finance world wise. Our organization has qualified and energetic professional Charted Accountant having positive approach to provide expert and professional services with due care of professional ethics. If you have any questions, I would glad to answer. Thank you for your attention to my application. Regards HR Dipsun Tech
$555 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there I fully understand your requirement and the business need behind it. I've developed many similar dashboards and reports during my 15 years of analytics career. I can make the report full flexible and easy to use. Such report should also have control limits and agreed action assigned to any deviation from the expected trend. I can also you help you with designing this action plan using this dashboard to drive the real business improvement.
$555 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have very good knowledge in data visualization on tool like tableau, splunk and excel. I am working on these tool on regular basis.
$277 AUD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Australia
0.0
0
Member since Jun 17, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.