Fermé

Build living Dashboard

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

Compétences : Excel

en voir plus : interactive dashboard examples, create dashboard online, excel dashboard, dashboard software, business dashboard, personal dashboard website, live dashboards, dashboards, build online book store php, iphone expense income app, best iphone expense income tracker, expense income control php script, iphone freelance expense income tracker, build google dashboard, build analytics dashboard, build online jewelry store website, build sales dashboard, notional expense income, build online party store, build online supplement store

Concernant l'employeur :
( 0 commentaires ) Australia

Nº du projet : #17512746

14 freelance font une offre moyenne de $433 pour ce travail

SohaibRehman17

Hello sir sir i have 7 years experience with your project skills i can provide you quality work on time Can you please come to the chat box so we can easily discuss about project details.. Thank You

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(5 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(0 Commentaires)
0.0
nbprince

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(6 Commentaires)
0.0
ferozstk

Hello, After reading your project details I believe I'm suitable for this project. As I'm expert on this kind of project with more than 5 years [login to view URL] feel free to contact me.I am looking forward to hear Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(32 Commentaires)
0.0
ammaralsultan27

I can do it , massage me Because I have experience designing control panels and I am a talented, creative and needy person for money

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0
antoinepal

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 t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 6 jours
(6 Commentaires)
0.0
dawoodjan123

Hire.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(0 Commentaires)
0.0
usmanhassan123

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 e Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 4 jours
(36 Commentaires)
0.0
KGeorgy

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 expe Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(1 Évaluation)
0.0
schoudhary1553

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 che Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 6 jours
(245 Commentaires)
0.0
RobinHoo1973

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 proje Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(0 Commentaires)
0.0
elqueabandona

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(199 Commentaires)
0.0
kishu0079

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 an Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(2 Commentaires)
0.0