Kapalı

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.

Beceriler: Excel

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Melbourne, Australia

Proje NO: #23473496

Bu iş için 19 freelancer ortalamada $153 teklif veriyor

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 Daha Fazla

$240 AUD in 5 gün içinde
(321 Değerlendirme)
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 in 3 gün içinde
(339 Değerlendirme)
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 Daha Fazla

$140 AUD in 2 gün içinde
(82 Değerlendirme)
6.1
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 Daha Fazla

$120 AUD in 4 gün içinde
(13 Değerlendirme)
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 in 7 gün içinde
(12 Değerlendirme)
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 Daha Fazla

$180 AUD in 2 gün içinde
(2 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
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 Daha Fazla

$250 AUD in 7 gün içinde
(0 Değerlendirme)
0.0
$155 AUD in 5 gün içinde
(0 Değerlendirme)
0.0
kuldeepgirdoniya

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

$155 AUD in 3 gün içinde
(0 Değerlendirme)
0.0
SWEETY324

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

$155 AUD in 5 gün içinde
(0 Değerlendirme)
0.0
$155 AUD in 3 gün içinde
(0 Değerlendirme)
0.0
$155 AUD in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$250 AUD in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$111 AUD in 7 gün içinde
(0 Değerlendirme)
0.0
$155 AUD in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$160 AUD in 3 gün içinde
(0 Değerlendirme)
0.0
arsalanshahid529

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

$30 AUD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$166 AUD in 10 gün içinde
(0 Değerlendirme)
0.0