Find Jobs
Hire Freelancers

Build living Dashboard

$250-750 AUD

Chiuso
Pubblicato più di 5 anni fa

$250-750 AUD

Pagato al completamento
Id like spreadsheet built that works as a realtime dashboard for my business. Integrating info from Xero that updates realtime into useable daya is essential. I want a "living" dashboard in the form of (perhaps) 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 Our sales director 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 - tab for social media 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). Skills: Accounting, Data Entry, Data Processing, Excel, PHP
Rif. progetto: 17512746

Info sul progetto

13 proposte
Progetto a distanza
Attivo 6 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
13 freelance hanno fatto un'offerta media di $436 AUD
Avatar dell'utente
Hello, I can help with you in your project Build living Dashboard I have more than 5 years of experience in Excel. We have worked on several similar projects before! We have worked on 380+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$500 AUD in 6 giorni
5,0 (275 valutazioni)
7,6
7,6
Avatar dell'utente
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
$600 AUD in 10 giorni
5,0 (206 valutazioni)
6,8
6,8
Avatar dell'utente
PhD in computer science having seven years of experience in Excel dashboard designing. sir you are at right place I already designed many Excel dashboards like : Mortgage Dashboard. Pms dashboard. Mock-up dashboard etc. sir I can deliver you quality work with guarantee. give me a chance.
$500 AUD in 4 giorni
4,7 (53 valutazioni)
6,0
6,0
Avatar dell'utente
Hello, I am an experienced Data Analyst with over 8 years experience in the field. I can build you a full automated reporting system in Power BI or excel that covers all the areas you want. Please check my portfolio to see my work. Thanks!
$500 AUD in 6 giorni
4,9 (21 valutazioni)
4,9
4,9
Avatar dell'utente
Hey, I have all those skills which you have mentioned at the end of project and able to create this kind of dashboard for you.
$264 AUD in 10 giorni
4,8 (10 valutazioni)
3,6
3,6
Avatar dell'utente
Hi, Thanks for your job posting. I've read your project description carefully. You are going to build dashboard for your business that shows statics and daily information. As a senior web developer, I have rich experience in this kind of project. I am sure I can handle this project as you expected. If you have desire to work with me, please respond me to discuss more. Thanks.
$555 AUD in 10 giorni
4,8 (2 valutazioni)
3,6
3,6
Avatar dell'utente
Hello, I can do this project for you. I have completed this type of project recently. So , It will be easy for me to complete this task. I have more than 2 years of experience in google sheets, google apps script and API. I have done 10+ projects, on Freelancer and 30-40 projects on another websites like Freelancer.com. I can work on both long-term projects and short-term projects. If you are interested, Please contact me ,So I can finish it as soon as possible. Waiting for your response. Thanks in advance.
$500 AUD in 2 giorni
4,8 (3 valutazioni)
2,4
2,4
Avatar dell'utente
I can do it , massage me Because I have experience designing control panels and I am a talented, creative and needy person for money
$250 AUD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
$555 AUD in 10 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hi, As I have plenty of experience in dashboard design and programing for collecting the realtime data from mysql backend database and populate in the way customer required. I hope I could support your in your project for the dashboard portion and also could provide the professional suggestions on any other dashboard related perspectives. Thanks and look forward providing the best service for you! Best Regards Robin Hoo
$555 AUD in 10 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: AUSTRALIA
Australia
0,0
0
Membro dal mag 5, 2018

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.