Kpiloom

Project Dashboard Templates

Ready-made project dashboards that shows which projects are on time and on budget, and how busy the team is. Choose your platform, then your industry.

The 8 KPIs every project dashboard should track

KPIWhat it tells youFormula
Active projectsProjects currently in progress.COUNT of projects with status = Active
On-time projectsShare of projects on or ahead of schedule.Projects on schedule ÷ Active projects
Budget usedShare of approved budget already spent.Actual cost ÷ Budget
Billable hoursHours that can be charged to clients.SUM of hours where Billable = Yes
Team utilisationShare of available hours spent on project work.Logged project hours ÷ Available hours
Overdue tasksTasks past their due date and not done.COUNT of tasks where Due < Today and Status ≠ Done
Milestones hitMilestones completed on time.COUNT of milestones done by due date
Project marginProfit left after project costs.(Project revenue − Project cost) ÷ Project revenue

Project dashboards by industry

IndustryExcelGoogle SheetsPower BILooker Studio
RetailExcelGoogle SheetsPower BILooker Studio
E-commerceExcelGoogle SheetsPower BILooker Studio
SaaSExcelGoogle SheetsPower BILooker Studio
RestaurantExcelGoogle SheetsPower BILooker Studio
Café & BakeryExcelGoogle SheetsPower BILooker Studio
HotelExcelGoogle SheetsPower BILooker Studio
Real EstateExcelGoogle SheetsPower BILooker Studio
ConstructionExcelGoogle SheetsPower BILooker Studio
ManufacturingExcelGoogle SheetsPower BILooker Studio
LogisticsExcelGoogle SheetsPower BILooker Studio
ClinicExcelGoogle SheetsPower BILooker Studio
HospitalExcelGoogle SheetsPower BILooker Studio
Dental PracticeExcelGoogle SheetsPower BILooker Studio
PharmacyExcelGoogle SheetsPower BILooker Studio
Gym & FitnessExcelGoogle SheetsPower BILooker Studio
Salon & SpaExcelGoogle SheetsPower BILooker Studio
Coaching InstituteExcelGoogle SheetsPower BILooker Studio
SchoolExcelGoogle SheetsPower BILooker Studio
UniversityExcelGoogle SheetsPower BILooker Studio
Marketing AgencyExcelGoogle SheetsPower BILooker Studio
ConsultingExcelGoogle SheetsPower BILooker Studio
Law FirmExcelGoogle SheetsPower BILooker Studio
Accounting FirmExcelGoogle SheetsPower BILooker Studio
InsuranceExcelGoogle SheetsPower BILooker Studio
BankingExcelGoogle SheetsPower BILooker Studio
FintechExcelGoogle SheetsPower BILooker Studio
AutomotiveExcelGoogle SheetsPower BILooker Studio
Car DealershipExcelGoogle SheetsPower BILooker Studio
AgricultureExcelGoogle SheetsPower BILooker Studio
Food ProcessingExcelGoogle SheetsPower BILooker Studio
FMCG DistributionExcelGoogle SheetsPower BILooker Studio
WholesaleExcelGoogle SheetsPower BILooker Studio
Kirana StoreExcelGoogle SheetsPower BILooker Studio
Fashion & ApparelExcelGoogle SheetsPower BILooker Studio
JewelleryExcelGoogle SheetsPower BILooker Studio
Electronics StoreExcelGoogle SheetsPower BILooker Studio
FurnitureExcelGoogle SheetsPower BILooker Studio
PharmaExcelGoogle SheetsPower BILooker Studio
TelecomExcelGoogle SheetsPower BILooker Studio
Solar & EnergyExcelGoogle SheetsPower BILooker Studio
Non-profitExcelGoogle SheetsPower BILooker Studio
EventsExcelGoogle SheetsPower BILooker Studio
Travel AgencyExcelGoogle SheetsPower BILooker Studio
Media & PublishingExcelGoogle SheetsPower BILooker Studio
GamingExcelGoogle SheetsPower BILooker Studio
Creator BusinessExcelGoogle SheetsPower BILooker Studio
FreelancerExcelGoogle SheetsPower BILooker Studio
StartupExcelGoogle SheetsPower BILooker Studio
IT ServicesExcelGoogle SheetsPower BILooker Studio
Security ServicesExcelGoogle SheetsPower BILooker Studio
Cleaning ServicesExcelGoogle SheetsPower BILooker Studio
Printing & PackagingExcelGoogle SheetsPower BILooker Studio
Pet CareExcelGoogle SheetsPower BILooker Studio

Questions

What is a project dashboard?

A project dashboard is a single page that shows which projects are on time and on budget, and how busy the team is. It pulls the key project KPIs, such as active projects, on-time projects, budget used and billable hours, into charts and tables that update when your data changes.

Which tool is best for a project dashboard?

Excel suits offline work and small teams. Google Sheets is best for sharing and live collaboration. Power BI handles large data and drill-down. Looker Studio is free and great with Google data. Every Kpiloom project dashboard comes in all four.

Which KPIs should a project dashboard track?

Start with active projects, on-time projects, budget used, billable hours, team utilisation, overdue tasks, milestones hit and project margin. The table on this page explains each one and how it is calculated.