KPI Dashboard for IT Services Company: Strategic Management
Expert prompt to build a KPI dashboard specific to IT services companies, covering financial, operational, customer and HR dimensions.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
You are a digital strategy consultant specializing in IT services companies (ESNs). Your mission is to design a KPI dashboard for the CEO of an IT services company of size [IT_SERVICES_FIRM_SIZE] (e.g., SME, mid-cap) specialized in [EXPERTISE_DOMAIN] (e.g., cybersecurity, custom development, cloud). The dashboard must cover the following 4 areas:
- Financial performance: include utilization rate (billable production / total capacity), revenue per consultant, margin rate (billing / cost), average collection period.
- Operational productivity: utilization rate indicator (billable time / total time), number of ongoing missions, contract renewal rate, project milestone adherence.
- Customer satisfaction: average Net Promoter Score (NPS), complaint rate, customer retention rate (contracts signed / renewed).
- Human capital: consultant turnover, number of hires, senior/junior ratio, certification rate.
For each KPI, provide the calculation formula, ideal monitoring frequency ([DAILY_WEEKLY_MONTHLY]), alert threshold (e.g., < 75% for utilization rate), and a visualization example (gauge, bar, line). The dashboard must be actionable: suggest improvement levers for each failing KPI, adapted to an IT services company context. Structure the response in clear sections, with a proposed textual mockup. Use fictitious but realistic data for [REFERENCE_YEAR].
Personalize this prompt with LĂ©a
Léa rewrites this prompt for your job and your exact goal — 3 quick questions.
Why this prompt works
<p>This prompt is designed to obtain a comprehensive and actionable dashboard, adapted to the constraints of IT services companies. It includes key indicators such as utilization rate, margin rate, NPS and turnover, which are critical for this sector.</p><p>To use it, replace the variables in brackets with your company's information: <strong>[IT_SERVICES_FIRM_SIZE]</strong> (e.g., SME), <strong>[EXPERTISE_DOMAIN]</strong> (e.g., Cloud), <strong>[DAILY_WEEKLY_MONTHLY]</strong> (choose the frequency), and <strong>[REFERENCE_YEAR]</strong> (e.g., 2025). The prompt will generate formulas, alert thresholds and visualizations.</p><p>Ideal for IT services company CEOs, CIOs or activity management consultants. The result can be used directly to feed a BI tool like Power BI or Tableau.</p>
Use Cases
Expected Output
A structured dashboard with 4 areas, for each KPI: formula, frequency, alert threshold, visualization and improvement levers.
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
- LĂ©aAI
Pour un dirigeant d’ESN, ajoutez un KPI de « marge par consultant » décliné par compétence, et un indicateur de « pipeline commercial » (taux de conversion, chiffre d’affaires en vue) pour anticiper les variations d’activité. Pensez aussi à croiser le taux d’occupation avec l’absentéisme, sinon le suivi reste trop théorique. Enfin, adaptez les seuils d’alerte selon votre taille : un taux d’occupation <75 % est critique en PME, mais supportable en ETI diversifiée.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.