跳到正文
cccskills
免费在 GitHub 公开

data-analyst

Turn raw data into an Excel workbook with cleaned records, formula-based summaries, and charts. Get three to five plain-language conclusions grounded in figures, with possible explanations or recommendations and clear acknowledgment when the data is insufficient.

中文简介正在准备中。当前显示英语简介。

原文查看原文说明

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

集成工具Excel

实测评分 未实测

查看安装方法

适用场景

  • Cleaning inconsistent units and date formats
  • Comparing results across periods or years
  • Visualizing trends and composition
  • Preparing key findings for a business review

包含的文件(1)

  • SKILL.md1.4 KB

SKILL.md(原文)

安装前可以查看交给 AI 代理的指令内容。

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.

评价

还没有评价。欢迎分享你的使用感受。

评论

无需登录即可发表。欢迎分享使用感受、提问,或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

提交后会立即公开。请勿填写邮箱、电话等个人信息。URL 最多 2 个。

0 / 1000 字

此表单受 reCAPTCHA 保护,适用 Google 的隐私权政策和服务条款。

同一仓库的技能

Use product facts and audience information to create ten tagline options, benefit statements backed by evidence, and brand stories for websites and social media. Compare alternatives in a Markdown document with recommendations and tone guidance.

中文简介正在准备中。当前显示英语简介。

  • Compare tagline options for a product
  • Rewrite product features as customer benefits
  • Create brand stories for a website and social media
genspark-ai/genoffice1.1万2026年10月23日 更新

Turn a business plan or project spending details into an Excel budget workbook. Organize monthly costs, account and quarterly summaries, confirmed assumptions, and a change log, with formulas that update calculations when assumptions change.

中文简介正在准备中。当前显示英语简介。

  • Build an annual department budget from a business plan
  • Organize project spending into a monthly budget
  • Compare budget totals with previous-year results
genspark-ai/genoffice1.1万2026年10月23日 更新

Turn a project idea or unfinished draft into a Word business plan for fundraising or internal approval, covering customers, market size, competitors, revenue model, team, and three-year financial projections with clearly stated assumptions.

中文简介正在准备中。当前显示英语简介。

  • Prepare a business plan for fundraising
  • Develop a proposal for internal project approval
  • Complete financial projections and competitor analysis
genspark-ai/genoffice1.1万2026年10月23日 更新

Turn notes, data, and source documents into a structured Word business report. An executive summary, evidence-based findings, actionable recommendations, and open questions give readers a clear conclusion, with consistent wording and sources for the figures.

中文简介正在准备中。当前显示英语简介。

  • Turning notes and data into a business report
  • Writing an assessment to support a decision
  • Preparing a sourced report for a client
genspark-ai/genoffice1.1万2026年10月23日 更新

Turn campaign goals, audience details, timing, and budget into a Word plan for review. Develop theme options, schedules, promotion channels, materials, cost breakdowns, measurable targets, contingency plans, and a template for reviewing results.

中文简介正在准备中。当前显示英语简介。

  • Plan a product launch event
  • Design a seasonal sales promotion within a budget
  • Map participation and conversion steps for an online campaign
genspark-ai/genoffice1.1万2026年10月23日 更新

Prepare a reference contract draft in Word from the parties, scope, payment terms, and other agreement details. Include a pre-signing checklist explaining unfavorable clauses and unresolved negotiation points, with a reminder to obtain licensed legal review.

中文简介正在准备中。当前显示英语简介。

  • Drafting a services outsourcing contract
  • Identifying risks in an agreement before signing
  • Listing unresolved contract negotiation points
genspark-ai/genoffice1.1万2026年10月23日 更新

查看 genspark-ai 的全部技能

报告此技能的问题