Build an Activity Dashboard for Your Consulting Firm
A structured prompt to generate a comprehensive dashboard tailored for a consulting firm, with specific KPIs (utilization rate, revenue per consultant, pipeline).
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
You are a digital strategy consultant. Build an activity dashboard for [FIRM_NAME], a consulting firm specializing in [EXPERTISE_DOMAIN] (e.g., digital transformation, strategy, HR). The dashboard should enable managers, marketers, salespeople, and partners to steer activity in real time, with the following blocks:
- Commercial indicators: amount of [SALES_PIPELINE], lead-to-quote conversion rate, number of [COMMERCIAL_PROPOSALS] in progress, monthly revenue vs. target.
- Production indicators: consultant utilization rate (billable vs. non-billable), gross margin per project, progress of [KEY_PROJECTS] (%).
- HR and skills indicators: total headcount, number of available consultants, attrition rate, training days completed.
- Financial indicators: cumulative revenue, net income, cash position, days sales outstanding.
- Automatic alerts: threshold breach on utilization rate (<70%), automatic reminder of [EXPIRED_QUOTES], alerts on [LOSS-MAKING_ENGAGEMENTS].
The output format must be a visual dashboard (charts, KPI cards) with monthly and quarterly periods. Include a view by [PRACTICE] (e.g., management consulting, IT, HR) and by [CLIENT_TYPE] (large accounts, mid-market, startups). The dashboard must be exportable to PDF and updated weekly. Use consulting-specific metric names: "time-to-bill", "utilization rate", "revenue per FTE", "win rate". Specify the source for each indicator (CRM, time tracking software, ERP).
Personalize this prompt with Léa · AI assistant
Léa rewrites this prompt for your job and your exact goal — 3 quick questions.
Why this prompt works
This prompt is designed to create a custom dashboard for a consulting firm. It integrates key industry indicators such as consultant utilization rate, revenue per employee, and sales pipeline tracking. To use it, replace the variables in brackets with your firm's actual data: [FIRM_NAME], [EXPERTISE_DOMAIN], [SALES_PIPELINE], etc. Also adapt the number of practices or client types according to your organization. This prompt can be used with text generation tools (ChatGPT, Claude) to obtain a detailed specification, or as a template for configuring a BI tool like Power BI or Tableau. Expected outputs include a visual mockup, a list of KPIs, and alert rules.
Use Cases
Expected Output
A detailed dashboard plan structured in 5 blocks, with consulting-specific indicators, data sources, and alert rules. Structured text format ready to be implemented in a BI tool.
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
Be the first to comment on this prompt.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Plan a project from scratch
Start a new project in a structured way
Rewrite an Underperforming Listing
Revitalize stale property listings that aren't attracting enough viewings
Automate your budget tracking
Set up an automated budget tracking system with dashboards, alerts, and reports adapted to your structure.
Presentation to the Executive Committee
Executive Presentation