Analytics lead / PM

Dashboard spec writer

Immediate result: A dashboard spec: the questions it answers, metrics with definitions, charts, filters and layout.

Problem it solvesDashboards get built with every metric and answer no question.

Download SKILL.md
Add this skill to
ChatGPTClaudeGeminiPerplexity

You paste

Weekly dashboard for the head of a food-delivery city team

You get

Q1: Are we delivering on time? → On-time rate = orders delivered ≤ promised ETA ÷ delivered orders

Chart: line, 8 weeks, with target line at 92%

Filter: zone, hour of day.

About this skill

About Dashboard spec writer

Dashboards built with every available metric end up answering no question. This skill starts from the audience and the decisions they make, lists the three to five questions they ask every week, and defines one metric per question with its formula and source. It recommends the right chart and default time range for each, sketches the layout and filters, and suggests alerts. Give the spec to an analyst or engineer and they can build a dashboard people will actually open on Monday morning. To use it, paste the skill into your assistant and send who the dashboard is for, the decisions they make and the data sources available; the reply opens with “Audience and decisions”.

Dashboard spec writer AI skill for Analytics lead / PM: you paste "Weekly dashboard for the head of a food-delivery city team" and get "Q1: Are we delivering on time? → On-time rate = orders delivered ≤ promised ETA ÷ delivered orders"
Dashboard spec writer — example input and the first lines it returns. Works in ChatGPT, Claude and Gemini.
Job profile
Data & analytics · Analytics lead / PM
Works in
ChatGPT, Claude, Gemini, Copilot, Claude Code
Format
Agent Skills (SKILL.md)
Price
Free, no sign-up
Install instructions

Copy, paste, send

  1. Cold email writerCopy skillCopied ✓1 Copy the skillPress Copy skill.
  2. ANY AI ASSISTANTSKILLPaste here, then press Enter2 Paste it into a new chatChatGPT, Claude, Gemini or Copilot.
  3. ANY AI ASSISTANT3 Send your inputSend who the dashboard is for.
The skill — paste this into your AI assistant
# Skill: Dashboard spec writer

You are running the "Dashboard spec writer" skill for me. I work as: Analytics lead / PM. What I need from you: a dashboard spec: the questions it answers, metrics with definitions, charts, filters and layout.

## When I send you who the dashboard is for, the decisions they make and the data sources available
1. List the three to five questions the audience asks weekly.
2. Define one metric per question, with formula and source.
3. Choose the right chart for each and the default time range.
4. Sketch the layout top to bottom and the filters.

## Reply in this format
- Audience and decisions
- Metric table: name, definition, formula, source
- Charts
- Filters
- Layout (wireframe in text)
- Alerts

## Rules
- Use only the facts I give you; mark anything you had to assume with [ASSUMPTION].
- If something essential is missing, ask me one short question, then continue.
- No preamble or filler: start with the result.

Confirm you're ready in one line, then wait for me to send who the dashboard is for, the decisions they make and the data sources available.

Then sendWho the dashboard is for, the decisions they make and the data sources available. For example: Weekly dashboard for the head of a food-delivery city team

ChatGPT

  1. Fastest: paste the skill as your first message in a new chat, then send your input.
  2. To keep it: open a Project, choose Instructions (or Settings → Personalization → Custom instructions for every chat) and paste it there.
  3. To share it with a team: create a custom GPT and paste the skill into its Instructions.
  4. In the Codex app: copy the skill's folder into ~/.codex/skills/ (or Customize → Skills → Add → Create skill).

Claude

  1. Fastest: paste the skill as your first message in a new chat, then send your input.
  2. To keep it: create a Project, open Project instructions and paste the skill.
  3. As a Claude Skill: download the skill's ZIP, then in Claude open Settings → Skills → Add → Upload skill and choose the file.

Gemini

  1. Fastest: paste the skill as your first message in a new chat, then send your input.
  2. To keep it: open Gems → New Gem, paste the skill into Instructions and save.

Microsoft Copilot

  1. Fastest: paste the skill as your first message, then send your input.
  2. In Microsoft 365 Copilot, save it as a prompt or paste it into an agent's instructions to reuse it.

Any other assistant

  1. Paste the skill as the system prompt or first message in any chat assistant (Perplexity, Meta AI, DeepSeek, Mistral, local models).
  2. Coding agents that read the Agent Skills format (SKILL.md) can load the downloaded file from their skills folder.

Install it permanently

Upload it to Claude, add it to ChatGPT's Codex app, clone it into Claude Code, or download the SKILL.md for any agent. Full guide with screenshots →

Download the ZIP and upload it in Claude. Claude then uses the skill on its own whenever a request matches.

Download ZIP

Quick setup

  1. In Claude, open Settings → Skills (under Customize).
  2. Click Add → Upload skill.
  3. Choose the ZIP — don't unzip it — and make sure the skill is switched on.
Claude Settings with Skills selected under Customize, and the Add menu open showing Upload skill, Create a skill, Create with Claude and Record your screen

Repositoryscienceofapps.com/skills/ai-skills.git · all 200 skills, one folder each, plain git over HTTPS

What it does

The steps it follows

  1. List the three to five questions the audience asks weekly.
  2. Define one metric per question, with formula and source.
  3. Choose the right chart for each and the default time range.
  4. Sketch the layout top to bottom and the filters.
What you get back

The reply format

  • Audience and decisions
  • Metric table: name, definition, formula, source
  • Charts
  • Filters
  • Layout (wireframe in text)
  • Alerts
FAQs

Questions about Dashboard spec writer

What does the Dashboard spec writer skill do?

Dashboards get built with every metric and answer no question. The skill fixes that: a dashboard spec: the questions it answers, metrics with definitions, charts, filters and layout.

How do I install Dashboard spec writer in ChatGPT, Claude or Gemini?

Copy the skill and paste it as the first message of a new chat, then send your input. To keep it, paste it into a ChatGPT Project or custom GPT, a Claude Project or a Gemini Gem, or upload the SKILL.md file as a Claude Skill.

What do I send Dashboard spec writer after installing it?

Send who the dashboard is for, the decisions they make and the data sources available. If something essential is missing, the skill asks you one short question and then continues.

Is the Dashboard spec writer skill free?

Yes. It's free to copy, use and adapt, with no sign-up, and works in the free versions of ChatGPT, Claude, Gemini and Copilot.

More for data & analytics
Analytics engineer / data analyst

Metric definition doc

ProblemTwo teams report different numbers for 'active users' because nobody wrote the definition down.

You paste

'Activation rate' for a B2B SaaS — people mean different things

You get

Activation rate = new workspaces that invite ≥ 1 teammate and create ≥ 1 project within 7 days ÷ new workspaces

Excludes: internal and test workspaces (domain list).

Edge: workspaces created on day 6 of the window are counted next week.

Immediate resultA precise metric definition: formula, inclusions, exclusions, grain, owner and SQL.

How to use it
Research / insights analyst

Survey analysis

ProblemHundreds of open-text survey answers go unread, and only the scores get reported.

You paste

NPS survey, 340 answers to 'What's the main reason for your score?'

You get

Slow delivery — 92 (27%) · 'Third late order this month'

Detractors mention delivery 3× more than promoters.

Action: show a realistic ETA at checkout, not the best case.

Immediate resultCoded themes with counts, representative quotes and what to do about each.

How to use it
Analyst presenting data

Chart picker

ProblemThe wrong chart hides the point — pie charts with twelve slices, dual axes that mislead.

You paste

Revenue by 9 product lines for 2025 vs 2026 · message: 3 lines drove all the growth

You get

Chart: slope chart (or sorted dot plot), 9 lines, 2025 → 2026.

Why not grouped bars: 18 bars make the 3 winners hard to spot.

Title: 'Three product lines drove all of 2026's growth' · colour only those three.

Immediate resultThe best chart for your data and message, with labelling advice and a mock-up in text.

How to use it

All 14 data & analytics skillsAll 200 skillsRead it in the articleProve it: AI for Data Analysts Certification (free test)

Free PDF · 74 pages · 2 editions

The Laws of UX, in one field guide

60 research-backed principles in 6 categories — what each one means, why it works on the human brain and how to use it on your own screens. Written by Sushant Singh, founder of Science of Apps, who has scaled consumer apps to lacs of users and spent 10+ years leading product across startups and digital businesses in the US, EU & India.

Pick your edition
Free. No card, no paywall — just your email.
Free PDF · 74 pages

Get Laws of UX by email

Choose your edition

You’ll also get occasional UX psychology tips. Unsubscribe anytime. Privacy policy

Free PDF · 90 pages · 2 editions

100+ Subscription Paywalls, decoded

110 real paywalls from top apps, taken apart, rated out of 5 and decoded with the Laws of UX — plus the frameworks, copy and checklists to ship your own. By Sushant Singh, founder of Science of Apps.

  • 110 paywalls rated
  • 34 Laws of UX
  • 12 frameworks

Which paywall scored 4.8 out of 5, and which scored 2.6? It’s all inside.

Pick your edition
Free. No card, no paywall — just your email.
Free PDF · 90 pages

Get 100+ Paywalls, Decoded by email

Choose your edition

You’ll also get occasional UX psychology tips. Unsubscribe anytime. Privacy policy