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.
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
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.
Bu iş için 19 freelancer ortalamada $153 teklif veriyor
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.
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
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 Daha Fazla