P
⚡ProductiviteAdvancedAll AIs

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

Adapt this prompt

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:

  1. Commercial indicators: amount of [SALES_PIPELINE], lead-to-quote conversion rate, number of [COMMERCIAL_PROPOSALS] in progress, monthly revenue vs. target.
  2. Production indicators: consultant utilization rate (billable vs. non-billable), gross margin per project, progress of [KEY_PROJECTS] (%).
  3. HR and skills indicators: total headcount, number of available consultants, attrition rate, training days completed.
  4. Financial indicators: cumulative revenue, net income, cash position, days sales outstanding.
  5. 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

Create a management dashboard for a strategy consulting firmDefine KPIs to track for a consulting sales teamAutomate consulting activity reporting for partners

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 Optimizer

Comments

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

⚡ProductiviteIntermediateAll AIs

Plan a project from scratch

Start a new project in a structured way

475
⚡ProductiviteIntermediateAll AIs

Rewrite an Underperforming Listing

Revitalize stale property listings that aren't attracting enough viewings

362
⚡ProductiviteBeginnerAll AIs

Automate your budget tracking

Set up an automated budget tracking system with dashboards, alerts, and reports adapted to your structure.

11124
⚡ProductiviteAdvancedAll AIs

Presentation to the Executive Committee

Executive Presentation

491