Visual Sales Dashboard from excel data

$30-250 NZD

Completed

Posted

over 3 years ago

$30-250 NZD

Paid on delivery

We analyse sales of our products by date, area and product franchise (MC Make). This is recorded in an excel sheet. I need to create a simple "Sales Sprint" dashboard from a standard data set that can be sent out weekly as a pdf.I have attached an example of a possible output to show the data required (see notes on this page) - this can be made to look better in terms of layout. I have also attached the dataset where this info will pull from. See notes on the example. The heading is the sprint for a given period - say 3 months. then the report is updated weekly. I will copy the next weeks data onto the bottom of the data and the reports will need to refresh. It needs to be dynamic enough to allow for a choice of MC Make to run the sales sprint for and have the ability to set different targets for different MC makes. It needs to exclude any item where the New/Used = Used, BUT i would also like to be able too run it for any item where new/used = U as a separate category This is all about setting a sales sprint figure and monitoring actual orders v the target sprint, and needs to able to be run for different sales periods (from amd to dates)

Project ID: 27083962

About the project

26 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

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

Awarded to:

@ShivaniGoyalsai

Hi Employer, I have created a dashboard in power BI using your sample data . I would also make a suggestion to include same period data of last year in the data which help you to evaluate (YOY, also last year numbers). I would like to show you the design that I prepared. if you are interested and find it suitable then we connect and can take it further. I have 8 years experience in vba programming , business intelligence ( SQL server,Ms access, hive) and data visualization ( tableau , Birst and Power BI). I worked on similar projects in the past and ensure you to deliver the quality with in the timeline. Thanks Shivani

$60 NZD in 2 days

4.6

(23 reviews)

4.0

26 freelancers are bidding on average $145 NZD for this job

@finecodervw

Hi, I looked at both the attachments. Keen to work on this project. Please suggest suitable time to discuss further on this requirement. I have few queries. I am well versed with Excel and its various features like Userforms, Pivot tables, Slicers, HLookup, Vlookup, Countif, SUMIF, Countifs, Sumifs, Left, Right, Mid, Index Match, drop down, filters, charts, graphs, conditional formatting, mail merge, dashboards and can provide the Excel that you are looking for. If need be I can also do automation using VBA/Macros. I have done good amount of work in Excel macro handling. It includes userform creation, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc. I will be happy to answer any queries that you may have. Looking forward to your response. Thanks

$125 NZD in 4 days

4.9

(141 reviews)

6.6

@zu02

Hi Would you like to have it via ms Access app with Excel automation? If so I can more detail. If you'd like only in Excel then I can code in this way. As my experience shows su,ch things, queries, reports, pdf automation etc with very friendly GUI/interface , better to make via ms Access app. Though , I'm ready to code in any direction. Let me know if u interested with my approach. Best, Zurab

$400 NZD in 7 days

4.8

(40 reviews)

6.0

@sonarkaushik

Sir, Quality and time is my commitment. I have done this many times, I want to say that, I will start right now and funds will be after your satisfaction. Hope you will Consider!

$198 NZD in 3 days

4.6

(54 reviews)

5.8

@professional800

Greetings I have experienced of more than two decades as manager accounts in public listed companies.I have made lot of dashboards in Excel for presenting data to management. I usually made presentation on behalf of Marketing deptt. for analysis. I can do your project and can start immediately and provide unlimited revisions untill you satisfy with your project. Sample of Dashboard is available on my profile.

$35 NZD in 2 days

5.0

(37 reviews)

4.7

@emilianoreyes70

Hello! im an Excel vba programer. Graphics pivot tables Dashboards. Also Google sheets and scripts. regards Juan

$200 NZD in 4 days

5.0

(18 reviews)

4.7

@redbcn

Hello! I have read your project and would like to bid for it. I have done similar projects in the past, such as a tool to visualize statistics based on inputs like a time period, certain products, etc. I can prepare a brief preview of how the report may look with some basic interactions. Let me know if you are interested. Thank you and regards, Adrian

$167 NZD in 2 days

5.0

(4 reviews)

3.7

@Exceltechguru

Hello Client, Greetings!!! I am Excel Expert with an experience of working in excel for more than 15 years. I will be able to create Sales Dashboard in excel. I have already created Interactive and Dynamic Dashboards in excel, which you can view in my portfolio and reviews provided. Looking forward to work with you!!! Thanks & Regards Parmeshwar Bhandari

$250 NZD in 5 days

5.0

(2 reviews)

2.3

@andriimalyshenko

Hello client I have read your details carefully. So i have all understood what you want. Also i have rich experiences in this assignment. I ensure i can give you good result for this project. I want you to chat with me for more discussing Thanks and Regards. from Andrii M.

$140 NZD in 2 days

5.0

(1 review)

1.4

@abhi1863

I am a reporting analyst and I can complete your project on time and within your budget. I would love to work on your project.

$140 NZD in 7 days

0.0

(0 reviews)

0.0

@luongduyvn

I have office skills, I know how to convert formats back and forth, I think I'll get the project done well

$140 NZD in 7 days

0.0

(0 reviews)

0.0

@dinesh0010chand8

Hi Sir I am a data entry operator, I can do this work for you. I have done this work before also, give me a chance, I will give you this work after completing it.

$200 NZD in 4 days

0.0

(0 reviews)

0.0

@barun2312

Hi sir. Iam Arun. Iam expert in data entry. Iam a self confident working individual who is waiting for opportunities. Iam so gld to work with you. I will surely as best as anyone can. waiting for your opportunity.

$79 NZD in 2 days

0.0

(0 reviews)

0.0

@Chay99

HI I'm a Data Scientist with 5+ years of Experience and build many Dashboards in Sales Domain Especially. I'm an Expert in Ms Excel, Tableau and Power Bi. After seeing your requirements you need a Dashboard which works dynamically and it can be done by 5-6 ways for example writing a simple code. I'll create your dashboard using filters, Charts that matches the need and with so many features.

$100 NZD in 2 days

0.0

(1 review)

0.0

@shirsen

Dear team, I am a expert in Wordpress & Tableau and Excel expert , i can make any type of Visualization in Excel and Tableau and BI. Kindly let us know for a demo will be happy to Showcase you . I am daily doing multiple dashboards in Excel, so your task I can do it easily.

$36 NZD in 7 days

0.0

(1 review)

0.0

@paculbajonalyn

Hi, I can do the work as I have enough knowledge and skills for the project requirements. Regards, Jonah

$200 NZD in 7 days

0.0

(0 reviews)

0.0

@MUKESHKUMARCHOUD

hi sir i have a great experience in data entry work and i read your descripition and i will do your project and i believe you when you work me you are very happy and i will complete your project within the time that i set you please send details me i need your project. Thank you

$30 NZD in 1 day

0.0

(1 review)

0.0

@gerondetorres

I am very proficient in MS excel and any kind of chart or dashboard you need. I can do this fast and accurate with what you wanted. My offered services is very cheap.

$70 NZD in 5 days

0.0

(0 reviews)

0.0

@Zakuma

I promise you to do this job best. As I just joined this site, I have a lot of experience from my previous work.

$30 NZD in 1 day

0.0

(0 reviews)

0.0

@geminikola79

Data Entry Specialist with sound knowledge of preparing documents such as work instructions, reports, annexures, control documents, KPIs, delivery performance reports, quality analysis reports and other audit related standard documents, thus has a sound knowledge of computer applications such as word, excel, power point. Can work for 8+ hours during week days and weekends.

$250 NZD in 7 days

0.0

(0 reviews)

0.0

@msghel

Hello, I am Angel from Philippines! I write a response regarding to your post needing a Virtual Assistant and I have all the skills that you required. I would bring you a resourceful, self-directed and energetic attitude to this role. I am a self-starter and good at verifying information, analyzing errors and managing confidential information. I am deeply familiar with answering emails and social media platforms and MS Office. I also have an experience as a Store Manager Trainee, Assistant Store Supervisor, Insurance Coordinator and Thesis/Research which may help with the work you needed. I hope to hear from you! Let’s discuss this and hoping to contribute on you on-going success. Regards, Angel.

$140 NZD in 5 days