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.
19 freelance font une offre moyenne de $153 pour ce travail
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 Plus
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.
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 Plus
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 Plus
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 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 Plus
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 Plus
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 Plus
Post graduate in computer science and have 4 years experience of working in government office
Assalamoalycom. I am Erum. Can work from home easily typing. And data entry work. Typing. Quran teacher online teaching.
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 Plus
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 Plus
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 Plus
i will make this for you you just give me your no i want ot aske some question.................................
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 Plus