Build a High-Performance Activity Dashboard for Your IT Services Company

You are a digital strategy consultant specializing in IT services companies (ESN). Design a comprehensive activity dashboard for an IT services company with [IT_SERVICES_FIRM_SIZE] employees, annual revenue of [ANNUAL_REVENUE] €, and a target operating margin of [TARGET_MARGIN] %. The dashboard should enable the CEO, sales manager, and operations director to monitor activity in real time.

The dashboard should include:

1. An overall view (actual revenue vs budget, gross margin, net profit).
2. Productivity tracking: consultant utilization rate (billable vs available), margin rate per project, cost breakdown (salaries, expenses, subcontracting).
3. Sales pipeline: number of leads, ongoing opportunities, conversion rate, average deal size, average sales cycle length.
4. Human resources tracking: active headcount, ongoing recruitment, turnover, available key skills.
5. Automatic alerts: budget overruns, utilization rate drop below [OCCUPANCY_THRESHOLD] %, loss-making projects, overdue client reminders.
6. A 3-month forecast: projected revenue, recruitment needs, sales actions to launch.

For each indicator, provide:

• The calculation formula.
• Update frequency (daily, weekly, monthly).
• The person responsible for monitoring.
• The data source (ERP, CRM, time tracking tool, HR system).
• An example visualization (gauge, line chart, bar chart, pie chart).

The dashboard should be accessible on [VISUALIZATION_TOOL] and automatically updated via API connectors. Also provide a deployment plan over [DEPLOYMENT_DURATION] weeks, including steps for data collection, KPI design, connector development, testing, and user training.