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
Answer 3 questions and Léa tailors the prompt to your situation.
Why this prompt works
<p>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.</p><p>To use it, replace the variables in brackets with your firm's actual data: <strong>[FIRM_NAME]</strong>, <strong>[EXPERTISE_DOMAIN]</strong>, <strong>[SALES_PIPELINE]</strong>, etc. Also adapt the number of practices or client types according to your organization.</p><p>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.</p>
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
Area Overview for an Investor
Attract and convince investors for a targeted sector
Plan a project from scratch
Start a new project in a structured way
Writing a Custom SOP for a Web Agency
Structured prompt to generate a complete and actionable SOP for a web agency, incorporating industry vocabulary and constraints.
Prompt to Write an Organizational Change Announcement Email
Create a clear, reassuring and structured organizational change announcement email to inform your teams while maintaining their engagement.