Закрыт

Excel koi summary dashboard

Hi there,

i would like to see if the following is possible and at what cost.

i am running many P6 schedules and would like to create a consolidated KPI dashboard to collate all the relevant information relating to 17 KPI milestones and how they are tracking

I have created a summary KPI Dashboard with the Data from P6 and what a desired output should look like if possible (Dashboard_example) tab.

There are 17 KPI's out of which some projects have most of them but others only have some.

Output 1:

A nice dashboard that provides the following:

Total number of projects and how many total KPI's they have

Total number of outstanding/forecast activities per KPI

Total Number that are ahead of schedule per KPI

Total number that are on time per KPI

Total number behind schedule by less than 30 days per KPI

Total numer behind schedule by more than 30 days per KPI

I think some information that might help with the categories might be the following fields in the Data Tab: FInish Date, Activity Status (if its been complete, In Progress and Not started), BL Project Finish Date and Variance - BL Project Finish Date

Output 2:

Clean up of the activities report that i have attempted to do.

It is essentially a transpose of the Data into a useable format. It lists the projects on the y AXIS and the KPI's and dates as an x-axis.

One requirement for this is to strip the "A" from any dates that have been actualised. ie cell C3 and C4 i would like the "A" to be taken out and only listed in the column to the right. I havnt figured out the best way to do this yet.

Квалификация: Excel

Показать больше excel online marketing dashboard, excel access architecture dashboard, excel visual basic dashboard, simple kpi dashboard excel, sales dashboard excel templates free download, safety dashboard excel templates free, employee kpi template excel, best excel dashboards free download, dynamic dashboard template in excel free download, dynamic dashboard template in excel, production kpi dashboard excel template, excel website analytics dashboard template, excel vba expert dashboard, cost developing customized excel based sales dashboard, excel project kpi dashboard, excel proposal management dashboard, excel management summary daily sales, excel business sales dashboard, excel record entry dashboard, excel social media dashboard

О работодателе:
( 0 отзыв(-а, -ов) ) Melbourne, Australia

ID проекта: #23473496

20 фрилансеров(-а) в среднем готовы выполнить эту работу за $152

schoudhary1553

Hello, I can help you with your project - Excel koi summary dashboard I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed sev Больше

$240 AUD за 5 дней(-я)
(318 отзывов(-а))
7.9
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.

$200 AUD за 3 дней(-я)
(335 отзывов(-а))
7.4
aimefx

Hi, I am an expert in Excel, Access, Powerpoint, VBA, MySQL, Google Sheet, Google Data Studio and Power BI. I can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interact Больше

$140 AUD за 2 дней(-я)
(79 отзывов(-а))
6.0
IgeS

Hi there, You need to have a dashboard that will represent the 17 kpi's in a tabular layout using cards (Power BI term for visualization using text) in an Excel? Please allow me help you build it. I can also clean the Больше

$120 AUD за 4 дней(-я)
(12 отзывов(-а))
4.5
NeetuSinghal

I have 9 years of experience in excel and data analysis. I have created lots of analysis in excel, automated reports, developed high level customized dashboard in excel for different type of analysis

$100 AUD за 7 дней(-я)
(12 отзывов(-а))
3.9
mohjib092

Hi there, Certified developer I have read your project and i want to discuss about project details i feel confident to work on your project And provide you quality work in the end as i provide to my previous clients Больше

$180 AUD за 2 дней(-я)
(2 отзывов(-а))
3.4
SupremeWriters

Hi... I have gone through your project specification you have provided and it seems like it is doable for me. I am a professional and experienced writer who would like to work on your project. You will get your work d Больше

$30 AUD за 1 день
(0 отзывов(-а))
0.0
Bslwan

Hi The task you described is challenging but you already provided a good skeleton. I already have some ideas on the links required to automate the data as much as possible. We would need to discuss what exactly you ex Больше

$250 AUD за 7 дней(-я)
(0 отзывов(-а))
0.0
$155 AUD за 5 дней(-я)
(0 отзывов(-а))
0.0
kuldeepgirdoniya

Post graduate in computer science and have 4 years experience of working in government office

$155 AUD за 3 дней(-я)
(0 отзывов(-а))
0.0
$155 AUD за 3 дней(-я)
(0 отзывов(-а))
0.0
SWEETY324

Assalamoalycom. I am Erum. Can work from home easily typing. And data entry work. Typing. Quran teacher online teaching.

$155 AUD за 5 дней(-я)
(0 отзывов(-а))
0.0
$155 AUD за 3 дней(-я)
(0 отзывов(-а))
0.0
jpawitro

Hi, I'm an experienced analyst and had an opportunity to work with a big organization (+/- 2000 employees) for ISO 55001 implementation, which is a lot of KPI formulation such as cascading down organizational objective Больше

$140 AUD за 7 дней(-я)
(0 отзывов(-а))
0.0
Ivanov913

Hi, sir! How are you? I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well. If need, I first can do a demo and send it asap. And then you can see it and decide on this proj Больше

$250 AUD за 3 дней(-я)
(0 отзывов(-а))
0.0
MrPunjani

Hello, We have recently executed a complete excel dashboard on some other freelancing platform, we can show some samples of it in inbox Let's discuss your project, we will execute your project as per our committed ti Больше

$111 AUD за 7 дней(-я)
(0 отзывов(-а))
0.0
$155 AUD за 3 дней(-я)
(0 отзывов(-а))
0.0
verinahalim

Hello Sir/Madam, I have seen the attached material included in this job post, and I have an idea to clear up the excel sheet to make it more user friendly and effective to read. I have experience in creating excel shee Больше

$160 AUD за 3 дней(-я)
(0 отзывов(-а))
0.0
arsalanshahid529

i will make this for you you just give me your no i want ot aske some question.................................

$30 AUD за 7 дней(-я)
(0 отзывов(-а))
0.0
MikeIzard

Happy to help with this. As an excel expert in large data processing, cleaning and dashboard report creation I am sure we can have a successful collaboration. Took a look at the file you attached, probably would want t Больше

$166 AUD за 10 дней(-я)
(0 отзывов(-а))
0.0