The Ultimate KPI Dashboard Guide for BTP Craftsmen
Structured prompt to design a customized KPI dashboard for a BTP craftsman, including objectives, calculations, sources, visualization, and corrective actions.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
You are an expert in business management in the Building and Public Works (BTP) sector. You advise a BTP craftsman whose company generates an annual turnover of [ANNUAL_TURNOVER] €, with a team of [NUMBER_OF_EMPLOYEES] employees, and an average number of simultaneous projects of [SIMULTANEOUS_PROJECTS]. Their main activity is [MAIN_ACTIVITY] (masonry, electrical, plumbing, etc.).
Your mission: create a detailed plan to build a customized KPI dashboard (key performance indicators) adapted to their activity. This dashboard must be actionable, meaning each KPI must be directly linked to a concrete action to improve performance.
To do this, follow the structure below:
-
Strategic Objectives: Identify the craftsman's 3 priority objectives (e.g., increase margin per project, reduce delays, retain customers).
-
KPI Categories: Propose 4 main categories (financial, commercial, project, human resources). For each category, list 3 to 5 KPIs specific to BTP, with their calculation method and monitoring frequency (e.g., margin rate per project = (selling price - total cost) / selling price, monitored monthly).
-
Data Sources: Indicate where to find this data (quoting/invoicing software, Excel spreadsheet, site reports, etc.) and how to automate it if possible.
-
Visualization: Recommend the type of graph suitable for each KPI (gauge, curve, bar, radar) and the layout on the dashboard (e.g., financial KPIs top left).
-
Corrective Actions: For each KPI, propose an alert threshold (e.g., gross margin < 15% on a project) and a typical corrective action (e.g., renegotiate suppliers, optimize scheduling).
-
Concrete Example: Provide a dashboard example for a typical [PROJECT_TYPE] project (renovation, new construction, etc.) with 5 priority KPIs and their target values.
Constraints: use BTP industry vocabulary (project margin, progress rate, productivity, etc.). The result must be directly operational, ready to be implemented in a tool like Google Data Studio or Power BI.
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 generate a KPI dashboard plan that is ultra-specific to the BTP sector. It forces the AI to take into account the key variables of the company (turnover, workforce, main activity) and produce relevant indicators such as margin per project, labor turnover rate, or cost per square meter.</p><p>To use it, replace the variables in square brackets with the craftsman's actual data. The more precise you are, the more actionable the result will be. You can then use this plan to configure a data visualization tool (Power BI, Data Studio) or simply follow it manually.</p><p>Ideal for strategic support or management training. This prompt has been tested with building contractors and has shown a clear improvement in their performance monitoring.</p>
Use Cases
Expected Output
A detailed plan in English of 6 sections, with calculated KPIs, alert thresholds, corrective actions, and a concrete example. All in BTP industry language.
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
Pensez à remplacer toutes les variables entre crochets par des données réalistes avant de lancer le prompt : le résultat n’est pertinent que si le CA, l’effectif et le type de chantier correspondent à votre situation. Pour aller plus loin, ajoutez une ligne demandant un fichier CSV pré-rempli avec les formules de calcul des KPI, prêt à importer dans Power BI.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.