Dashboard metrics

dashboardproject_.xlsxHi,

I need help with my dashboard metrics project.

How can I make dashboard that shows metrics per analyst/employee.
Pls try to experiment my file and make it more useful and impressive.
I want this workbook to be more convenient and has link to each tab to make like a summary for each analyst and or for team's metrics.

I'm really having a hard time since Im just a beginner

Thanksdashboardproject_.xlsx

Hi Excelbench,

Impressive!

I suggest you to google some dashboard understand what suits best to you & your team. Creating dashboard is step by step process.

If you can mention what you want in a precise manner then someone can help you.

Cheers!

Regards,
AM

Thank you! I'd like to get some ideas or templates.
It can help me a lot on this project.

Originally Posted by bhenlee

Mabuhay!!!

in your attendance sheet. hide possible error message by using =IFerror in AD & AE

a lot of formulas are available to automate your attendance sheet.

It's not ideal to plot the names of the associates for the rest of the year as you will have changes along the way (attritions/new hires)

remove hyperlinks outside of the workbooks. you want your dashboard to update all by itself without relying on an another workbook which is not available to the user

Do you have a template sample.
Similar to my workbook?

help me please.

Hi,

I have created similar kind of dashboard.I would suggest you to hide the work sheet.Place few graph into first sheet,Automate No of Working Days using NetworkDays formula.
Hide Sheet so people can use your link.Change the Colour of link depending on Which Page you are in.

To Hide all the Sheet:Files->Option->Advance->Display option for this Workbook
Unchecked "Show Sheets Tab"

RegardsExcel Dashboard.jpg
Danish