Comprehensive Monthly Excel KPI Dashboard
Budget: $250 – $750 NZD
I am in need of an advanced Excel spreadsheet that will help track and output several key performance indicators (KPIs) on a monthly basis.
The KPI dashboard should integrate the following parameters:
- Sales pipeline
- Revenue - Over $2,000,000 Per month
- Overheads Average 3.75% of revenue for month
- Gross profit 12 %
- Projects on time >90 %
- Defects closed <20 working days
- Customer Satisfaction
- Employee Productivity
- Health and Safety
The desired freelancer should have:
- Proficient skills in Excel including pivot tables, charts, and formulas
- Experience in creating KPI dashboards
- Strong understanding of business metrics
Please note that the dashboard should be mapped to be updated monthly. The focus is on clarity and ease of interpretation of the data. The ability to forecast, compare and highlight trends would be greatly appreciated. Your ideas and improvements to make the tool more efficient are welcome!
The KPI dashboard should integrate the following parameters:
- Sales pipeline
- Revenue - Over $2,000,000 Per month
- Overheads Average 3.75% of revenue for month
- Gross profit 12 %
- Projects on time >90 %
- Defects closed <20 working days
- Customer Satisfaction
- Employee Productivity
- Health and Safety
The desired freelancer should have:
- Proficient skills in Excel including pivot tables, charts, and formulas
- Experience in creating KPI dashboards
- Strong understanding of business metrics
Please note that the dashboard should be mapped to be updated monthly. The focus is on clarity and ease of interpretation of the data. The ability to forecast, compare and highlight trends would be greatly appreciated. Your ideas and improvements to make the tool more efficient are welcome!