Excel Timesheet and Project KPI Dashboard

Completado Publicado hace 7 años Pagado a la entrega
Completado Pagado a la entrega

I need a slick Excel dashboard based on data from timesheet. The timesheet has the date, hours worked, project name/code, activity, area, size of area, project budget, (salary)cost per worker per hour, food allowance. I am looking for a person that can build a dashboard where I can not only see the cost per project and if we are within (based on salary cost) budget but also make visual how much time was spend per activity, per area and compare these values and the cost within one project. The activities (up to 12 different activities) are always the same per area (a project could have up to 20 areas) but the times spend on these activities per area will likely differ, I want the dashboard to make this visible not only by a number. The dashboard or multiple dasboards must also be able to compare the different projects (up to 20) on key performance indicators and present all this in a slick way (not only column charts) with an easy interface (Slicers etc.). There is no need to develop a timesheet, just use the existing data that is generated on a daily base. If you are an Excel Ninja, are creative with making dashboards and expert in visualizing data analysis, then this might be an interesting challenge for you.

Excel

Nº del proyecto: #10810561

Sobre el proyecto

41 propuestas Proyecto remoto Activo hace 7 años

Adjudicado a:

TimHudspith

The developer would need to spend a couple of days looking at the data and bouncing ideas off you. You need something consisting of several pages, but organised with an easy-click menu along the top so that it works mo Más

$30 USD en 14 días
(4 comentarios)
4.1

41 freelancers están ofertando un promedio de $133 por este trabajo

khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

$150 USD en 3 días
(218 comentarios)
6.8
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 USD en 3 días
(135 comentarios)
6.5
cugamelover

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel, macros, and VBA. I've done a lot of similar work. Please see reviews on my profile. It would be m Más

$140 USD en 3 días
(134 comentarios)
6.7
shikhamehta

Hello there, I am an expert in Excel based Dashboards which give the data an elegant visual look. As you would see in my work history here, I have done several dashboards and have been highly rated and recommended f Más

$277 USD en 7 días
(87 comentarios)
6.1
TonmoyRoy111

A proposal has not yet been provided

$166 USD en 3 días
(153 comentarios)
5.8
ShaunKleinOnline

Hi there, Your project sounds fun and interesting! I have over 13 years of corporate experience working in Excel creating advanced automated dashboards and reports and I would love the opportunity to work with you t Más

$133 USD en 4 días
(41 comentarios)
5.6
bizwizz

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have b Más

$200 USD en 3 días
(18 comentarios)
5.7
atifdar

Hi, MS Excel expert here, I can design the required dashboard in MS Excel for you with 100% accuracy Feel free to award Thanks

$99 USD en 3 días
(48 comentarios)
5.2
FIBIN

Hi I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% ac Más

$90 USD en 2 días
(49 comentarios)
5.4
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready Más

$194 USD en 3 días
(39 comentarios)
5.5
beltran0404

Hello, It woul be nice for me to help you in this project. I manage excel and I have done some dashboard. I could do graphics dashboard and an interesting way you could visualize your data, according your needs. It Más

$100 USD en 7 días
(42 comentarios)
4.5
mallikasomu87

i, I read through your requirement and looking forward to commit to this challenging requirement. I have 7 years of experience in MS advanced excel, office(formatting, formulation, reports, dashboards, pivots,chart Más

$83 USD en 2 días
(15 comentarios)
4.1
poldialcalay

Hello. I am able to create an excel document that will allow you to paste some standard data or link it to your database, push a button that will run a macro that will automatically update pivot tables and charts to Más

$100 USD en 3 días
(10 comentarios)
3.9
iqmax99

Hi I would like to work with you on this project. My bid is not for using Excel. It is for using a tool on the web. The tool lets the user build and display professional dashboards. You could use the tool FREE fo Más

$111 USD en 3 días
(8 comentarios)
3.5
humayoonsheikh4u

dear sir: I bid on your project as per my expertise on m.s excel i can do your project as per requirement in couple of days. I can perform various task on excel including dashboard making, statistical analysis, formu Más

$77 USD en 3 días
(8 comentarios)
3.9
tandonshailendra

Evidently you need macro to summaries the data and Pivot table/charts with slicer to visualize the same. Extra dashboard can be prepared as per requirement. I am Mechanical Engineer, proficient in Excel Macro, Pivot Más

$161 USD en 5 días
(9 comentarios)
3.6
hsh564cf84accd96

Hi, I hope you will be fine sir.I am an hard working and dedicated person.I am a certified virtual assistant.I have 3 months experience of working on amazon.I have done product research,price listing,drop shipping.I al Más

$100 USD en 3 días
(1 comentario)
2.4
vraghavendran

Hey Proveide more data and I could get it done for you Have been working with excel and making Dashboards for a NBFC for 4 years. Let me know Thanks

$72 USD en 2 días
(3 comentarios)
1.1
ranmali1965

Dear Sir Madam, I am an enthusiastic and motivated Finance professional with 32 years of expertise with a positive outlook. I am an excellent candidate for this vacancy as it closely matches my skills and experienc Más

$144 USD en 3 días
(0 comentarios)
0.0
sthamizhchelvi

Hi The project description looks interesting.. I have good knowledge in MS office tools..Hope to hear from you soon. . Thanks for considering my proposal!

$166 USD en 5 días
(0 comentarios)
0.0