Completed

Build Excel Dashboards to Visualize Data

I need a few analytic dashboards with graphs, charts and maps to visually display some financial data I have. I need 4 dashboards in different tabs each with different visuals

Each tab (3-6) should be clean dashboards that are generated by pivot(s) in tab 2. These visuals are for leaders with no data skills, so they need to be visually appealing, interesting but simple to understand. I need them to be easily adjusted, so keep a dropdown somewhere on the page. If you have any ideas for new visuals that could be helpful to understand this data, feel free to create new tabs.

Tab 3: A heat map of Europe showing how much money is spent there

Tab 4: Bar graphs, pie graphs or other visuals that show the funding by OPR. Also visuals that show the relationship between SV # and events that have been “funded” (I want to see if a higher SV# value correlates to an event being funded instead of “rejected” or “cancelled”). Another should be on the Priority- Does priority mean it is more likely to be funded?

Tab 5: Here I need bar graphs on how much funding each LLP #, country and LOA has received.

Tab 6: Visuals showing how much money gets requested verses how many are approved. One visual should show the OPR by how much was requested/ received

Timeline is two days. It would be nice to have by Friday evening, but it's okay if it takes longer.

I might need larger projects done in the future as well.

Skills: Excel, Visual Basic, Data Processing

See more: making a dynamic dashboard excel, excel dashboard training, interactive dashboard excel template, excel dashboard template, excel dashboard tutorial pdf, how to create a dashboard in excel from scratch, best excel dashboards, excel dashboard templates xls, office 2007 excel pull calendar data outlook, excel download yahoo data, excel macro move data existing cell, excel macro copy data column, import excel sheet sql data base, excel spreadsheet vba data entry form, excel macro enter data database, edit excel file move data, excel vba look data sheet, excel cut paste data macro, excel macro copy data windows application, excel simple macro data comparing copy

About the Employer:
( 7 reviews ) San Diego, United States

Project ID: #24484319

Awarded to:

rinabuoy13

Hello, I am an independent, experienced excel / vba expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.

$30 USD in 2 days
(105 Reviews)
6.2

15 freelancers are bidding on average $25 for this job

tiaratechies

Hello, I'm an experienced advanced excel developer that has years of technical knowledge, if you are interested in hiring a professional kindly drop a message so that I can start working on it and give it to you in a d More

$30 USD in 2 days
(51 Reviews)
6.9
mtdevil369

Hi Vitor, I will make Visual Basic code to import data from different file in master file as per your requirement with good and professional quality without any error. I have completed more then 100 project within 8 mo More

$30 USD in 1 day
(180 Reviews)
6.2
AnowarRatul

$29 Only ------- In just 12 Minutes ------- I can build you the dashboard with professional look and include the graphs and charts absolutely as you want by maintaining 100% accuracy of your data absolutely as you want More

$29 USD in 1 day
(92 Reviews)
5.2
Akib2020

Hi there, I'm javed my computer experience is 12 years more. I'm expert on microsoft advance excel, vba, macro, conditional formatting, consolidate multiple excel sheet, data conversation, data entry, pivot table, dash More

$25 USD in 2 days
(5 Reviews)
2.5
vinodk132

Greetings, Throughout my 35+ years career, I have used Excel extensively to manage the programs / projects / actions and the reporting requirements. Normalized/cleaned up lot of data, collected from various sources an More

$26 USD in 2 days
(2 Reviews)
2.3
cristiangoooo

I would like to help in your project, I have worked a lot of time in Excel and with others MS Office applications, I will be waiting your comments. Regards, Cristian

$30 USD in 2 days
(1 Review)
1.8
satramdas1965

Hi there, How are you!, I had read the details of your project and understood your requirements, I will start the project immediately and finish your work in the least time possible, mostly I will give you a estimated More

$30 USD in 1 day
(1 Review)
0.0
joaoedu97

Hi! Im a data analyst working with data from excel and SQL databases for the biggest company´s in alcohol beverages in portugal. I work mainly with product sales and supermarket sales dashboards and marketing performan More

$20 USD in 2 days
(0 Reviews)
0.0
HarshPratapJohri

Dear Sir/Mam, I have command on excel and i can do this task so easily. I also have expirence in this type of tasks. I ensure you that i will completethis task on time with zero errors. Regards Harsh Johri

$20 USD in 3 days
(0 Reviews)
0.0
Jatin77777

Hello, I have a good experience in data mining, being a part of Reporting & Analytics team in MNC. I have considered all the micro level aspects before putting data in Dashboard. I have created multiple dynamic Dashbo More

$20 USD in 7 days
(0 Reviews)
0.0
Shrishti95

Hi, I'm an MBA with good experience in data analysis - specially using Excel. I've worked for firms like ZS and BCG and can help you with the posted job

$25 USD in 2 days
(0 Reviews)
0.0
TahirAbbas1122

Hi, I have seen the file and required job. i can easily do this as I have done such tasks in the past. I am expert in; Process flow Flowchart Data Flow Diagram Decision Tree Diagrams Entity Relationship Diagrams Proced More

$18 USD in 2 days
(0 Reviews)
0.0
AreebaShamsi

Hi, Hope you're doing great I have a lot of experience in Data visualization. I have made dashboards in Excel, Power BI and Tableau. Clear and simple Graphs (such as Bar/Pie charts) with minimal explanation required More

$22 USD in 2 days
(0 Reviews)
0.0
Greatpersonality

Respected Clients, I am an expert in MS Office. I have more than experience in this field. I can do your work clearly. I hope you will like my work and hair me for this job. I am a student in IT field and know about on More

$25 USD in 7 days
(0 Reviews)
0.0