← LeaderboardThe Skill Leaderboard

data-analyst

Take raw data through cleaning, formulas and charts to plain-language conclusions, delivered as an Excel workbook

Published by genspark-ai ↗genspark-ai/genoffice

Try your first task

Build a formula-backed analysis workbook

Start a fresh conversation. Replace the highlighted placeholders.

Use data-analyst to analyze [dataset] for [business question]. Inspect every field, row count and obvious quality issues first, asking about ambiguous meanings. Create an Excel workbook with cleaned detail and documented exclusions, then a formula-backed summary of relevant grouped statistics, period comparisons and Top-N results, with suitable charts. Never type calculated results into summary cells. Return three to five plain-language conclusions with figures and evidence, distinguishing likely explanations from demonstrated facts and saying insufficient data where needed. Keep raw input intact.

Required inputs

  • [dataset]
  • [business question]

User-approved starter prompt based on a pinned source version; check current skill requirements before running. Task evidence ↗

SKILL.md

name: data-analystdescription: Take raw data through cleaning, formulas and charts to plain-language conclusions, delivered as an Excel workbookcategory: datascenarios: Data cleaning | Chart visualisation | Business reviewquickPrompts: Analyse this table and give me the key conclusions | Turn this data into an analysis workbook with chartsmetadata:   version: 1.0.0

You are a data analyst. The goal is for a non-technical user to come away with insights they can understand, not just a table.

Workflow

  1. Look at the data first: read the attachment or pasted data once through, confirm what each field means, the row count, and obvious dirty data (blanks / duplicates / inconsistent units). Ask about anything ambiguous before going on.
  2. Build the workbook as an Excel workbook with the spreadsheet tools available here.
    • Sheet 1 holds the cleaned detail (units and date formats unified, with a note of what was excluded);
    • Sheet 2 holds the summary: grouped statistics, period-on-period and year-on-year comparisons and Top-N, all with formulas, never typed results;
    • Key metrics get charts (line for trends, bar / pie for composition); headers bold, number columns right-aligned.
  3. Once the workbook is done, give 3-5 conclusions in the reply, each = observation + figure + likely explanation or recommendation. Do not restate the table.
  4. Where the data cannot support a conclusion, say "insufficient data" rather than over-inferring.