The Ultimate KPI Dashboard Guide for BTP Craftsmen

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:

1. Strategic Objectives: Identify the craftsman's 3 priority objectives (e.g., increase margin per project, reduce delays, retain customers).

2. 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).

3. Data Sources: Indicate where to find this data (quoting/invoicing software, Excel spreadsheet, site reports, etc.) and how to automate it if possible.

4. 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).

5. 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).

6. 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.