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.

Taidot: Excel

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Melbourne, Australia

Projektin tunnus: #23473496

19 freelanceria on tarjonnut keskimäärin 153$ tähän työhön


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 Lisää

$240 AUD 5 päivässä
(321 arvostelua)

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 päivässä
(339 arvostelua)

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 Lisää

$140 AUD 2 päivässä
(82 arvostelua)

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 Lisää

$120 AUD 4 päivässä
(13 arvostelua)

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 päivässä
(12 arvostelua)

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 Lisää

$180 AUD 2 päivässä
(2 arvostelua)

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 Lisää

$30 AUD 1 päivässä
(0 arvostelua)

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 Lisää

$250 AUD 7 päivässä
(0 arvostelua)
$155 AUD 5 päivässä
(0 arvostelua)

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

$155 AUD 3 päivässä
(0 arvostelua)

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

$155 AUD 5 päivässä
(0 arvostelua)
$155 AUD 3 päivässä
(0 arvostelua)
$155 AUD 3 päivässä
(0 arvostelua)

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 Lisää

$250 AUD 3 päivässä
(0 arvostelua)

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 Lisää

$111 AUD 7 päivässä
(0 arvostelua)
$155 AUD 3 päivässä
(0 arvostelua)

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 Lisää

$160 AUD 3 päivässä
(0 arvostelua)

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

$30 AUD 7 päivässä
(0 arvostelua)

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 Lisää

$166 AUD 10 päivässä
(0 arvostelua)