Agent skill

Bi Dimension Drilldown

by agentscope-ai in agentscope-ai/QwenPaw-Data

对指标按维度逐层下拆,通过单维度扫描、交叉分析和层级下钻定位关键维度(组)值。当需要知道"从哪些维度拆解、按什么顺序拆解来定位指标变动来源"时调用。

Apache-2.0Auto-check passed

Install Bi Dimension Drilldown

skills CLI
$ npx skills add agentscope-ai/QwenPaw-Data --skill bi-dimension-drilldown -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install agentscope-ai/QwenPaw-Data bi-dimension-drilldown --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/agentscope-ai/QwenPaw-Data.git skills-src && mkdir -p .claude/skills && cp -r skills-src/packages/qwenpaw-data-skills/skills/atomic/bi-dimension-drilldown .claude/skills/bi-dimension-drilldown && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
bi-dimension-drilldown
GitHub stars
127
Token cost
~605 tokens
SKILL.md length
124 words
Files
1
Skills in repo
29
Repo updated
First seen
Licence
Apache-2.0

At a glance

对指标按维度逐层下拆,通过单维度扫描、交叉分析和层级下钻定位关键维度(组)值。当需要知道"从哪些维度拆解、按什么顺序拆解来定位指标变动来源"时调用。

  • Works in 2 steps: 将 D1 中的异常维度两两组合 → 对每个组合执行贡献度计算和分布占比计算,筛选贡献度 Top-N…
  • SKILL.md covers 前置检查 and 执行步骤
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Bi Dimension Drilldown is an agent skill from agentscope-ai/QwenPaw-Data. 对指标按维度逐层下拆,通过单维度扫描、交叉分析和层级下钻定位关键维度(组)值。当需要知道"从哪些维度拆解、按什么顺序拆解来定位指标变动来源"时调用。

Its SKILL.md is about 610 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

The repository describes itself as: Agentic enterprise data analytics: governed facts (DataBridge), reusable methodology (Skill-Hub), and controllable execution (Host). The licence is Apache-2.0.

Example prompts

  • “从哪些维度拆解、按什么顺序拆解来定位指标变动来源”
  • “/bi-dimension-drilldown”

Workflow steps

2 steps, taken from the first numbered list in SKILL.md.

  1. 将 D1 中的异常维度两两组合
  2. 对每个组合执行贡献度计算和分布占比计算,筛选贡献度 Top-N 的维度组合,记异常维度组合集合为 D2

What it can do on your machine

Read from SKILL.md and the folder at commit e0bae36. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Bi Dimension Drilldown loads about 605 tokens when it runs. Until then it costs about 24 tokens; SKILL.md has 124 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~24
When it runs · the whole SKILL.md, loaded when a task matches
~605

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from agentscope-ai/QwenPaw-Data at commit e0bae36, republished under its Apache-2.0 licence (© agentscope-ai). 124 words, ~605 tokens.

Download SKILL.mdSave it as .claude/skills/bi-dimension-drilldown/SKILL.md (or your agent's skills folder).
name
bi-dimension-drilldown
description
对指标按维度逐层下拆,通过单维度扫描、交叉分析和层级下钻定位关键维度(组)值。当需要知道"从哪些维度拆解、按什么顺序拆解来定位指标变动来源"时调用。

bi-dimension-drilldown

对指标按归因维度逐层下拆,通过单维度扫描、交叉分析和层级下钻,定位驱动指标变动的关键维度(组)值。

典型场景:

  • 用户要求"按渠道拆一下 DAU 的贡献度"
  • 异动分析流程中,异常检测发现异常后需要定位原因

前置检查

开始前确认以下信息已明确:

  • 下拆指标:需要下拆的指标及其类型(量值 / 率值 / 加权平均)
  • 归因拆解维度:下拆的维度列表及其层级关系(哪些是 0 级平级维度,哪些有父子关系)
  • 分布指标(可选):需要展示分布占比的重点指标

执行步骤

1:数据准备

根据前置检查确认的指标和维度,准备包含往期和当期数据的 CSV 文件,至少包含以下列:

列说明示例
维度列所有涉及的归因拆解维度(每个维度一列,可能多列)渠道、端类型
往期值列下拆指标的往期值DAU_往期
当期值列下拆指标的当期值DAU_当期
分布指标列分布指标值(可选,有分布指标时需要)访问用户数

若上游步骤已产出可用数据文件则直接使用,否则自行取数。

2:维度下拆

在每一步下拆中,针对当前拆解的维度(组),计算:

  • 贡献度(相对于下拆指标):各维度(组)值对该下拆指标整体变动的贡献大小
  • 分布占比(相对于需要展示占比的分布指标):各维度(组)值在分布指标整体中的比例

按以下步骤逐步拆解:

2.1 单维度扫描

对每个 0 级归因维度逐一执行贡献度计算和分布占比计算,筛选贡献度 Top-N 的维度值,记异常维度值集合为 D1。

2.2 交叉分析(平级维度)

若 D1 中多个平级维度同时出现异常维度值:

  1. 将 D1 中的异常维度两两组合
  2. 对每个组合执行贡献度计算和分布占比计算,筛选贡献度 Top-N 的维度组合,记异常维度组合集合为 D2

若只有一个维度出现异常,跳过此步。

2.3 层级下钻(层级维度)

取 D2(若存在)或 D1 中的异常维度(组),沿层级关系逐级向下拆解:

  1. 对异常维度值,找到其下一级子维度
  2. 在该异常维度值的数据范围内,执行贡献度计算和分布占比计算,筛选 Top-N
  3. 继续向下拆解(0 级 → 1 级 → 2 级 → ...),直到无更下级维度

每一级的下拆结果都保留,用于最终汇总。

补充说明:

  • 默认参数:若用户未要求或其他源未指定,默认 N = 3
  • 正负分离判断:默认按整体贡献度排序;当某方向变动量超过整体变动的 30% 时,说明正负抵消严重,需分别筛选正/负贡献度 Top-N

示例:下拆指标为 DAU(日活跃用户数),分布指标为访问用户数,0 级归因维度有"渠道"和"端类型","渠道"下有 1 级子维度"子渠道"。

  1. 单维度扫描:分别按"渠道"和"端类型"下拆 DAU,发现"渠道=自然流量"贡献度 +45%、"端类型=APP"贡献度 +30%,同时计算各维度值的访问用户数分布占比。两个维度均出现异常 → D1 = {渠道:自然流量, 端类型:APP}
  2. 交叉分析:"渠道"与"端类型"是平级维度,按"渠道 × 端类型"组合下拆,发现"自然流量 × APP"组合贡献度 +38% → D2 = {自然流量 × APP}
  3. 层级下钻:"渠道"下有子维度"子渠道",在"自然流量 × APP"这个组合下继续按"子渠道"下拆,发现"子渠道=搜索引擎"贡献度 +32%,最终定位到异常来源
3:汇总下拆结果

将各层级的下拆结果汇总输出。示例:

单维度扫描(渠道):

 维度值    DAU贡献度  访问用户数占比
 自然流量   +45%        52.3%
 付费投放   -12%        28.1%

单维度扫描(端类型):

 维度值    DAU贡献度  访问用户数占比
 APP        +30%        61.5%
 Web        +15%        38.5%

交叉分析:

 维度组合           DAU贡献度  访问用户数占比
 自然流量 × APP      +38%        35.2%
 自然流量 × Web       +7%        17.1%

层级下钻:

 父维度值           子维度    DAU贡献度  访问用户数占比
 自然流量 × APP     搜索引擎   +32%        22.8%
 自然流量 × APP     社交分享    +6%        12.4%

© agentscope-ai, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in packages/qwenpaw-data-skills/skills/atomic/bi-dimension-drilldown of agentscope-ai/QwenPaw-Data.

Open the folder on GitHubat commit e0bae36

Compare with similar skills

Bi Dimension Drilldown next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Bi Dimension Drilldown compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Bi Dimension Drilldown this skillagentscope-ai/QwenPaw-Data127—~605Automated safety check: PassApache-2.0
Dimensionsthedaviddias/Front-End-Checklist74k—~926Automated safety check: PassMIT
Modeling Dimension TablesPostHog/posthog40k—~1.4kAutomated safety check: PassCustom licence
Six Dimension Code Reviewa5c-ai/babysitter1.8k—~700Automated safety check: PassMIT
Cja Dimension Analysisadobe/skills197—~3.3kAutomated safety check: PassApache-2.0
Gram Telemetry Query Dimensionsspeakeasy-api/gram273—~2.4kAutomated safety check: PassAGPL-3.0

Similar skills

  • Dimensions

    thedaviddias/Front-End-Checklist

    A skill your agent uses when reviewing image assets, markup, and CDN or build transforms related to Set explicit width and height on images.

    74k GitHub stars~926 tokensUpdated 4 days ago
    Frontend & DesignAuto-check passed
  • Official

    Build reusable dimension / lookup tables for a star schema — country/region, timezone, currency, date, plan/product, and other descriptive attributes — on either PostHog data-warehouse views (HogQL)…

    40k GitHub stars~1.4k tokensUpdated today
    DatabasesAuto-check passed
  • Six Dimension Code Review

    a5c-ai/babysitter

    Structured pull-request review across six fixed dimensions — correctness, clarity, consistency, coverage, complexity, and change-scope — producing a per-dimension verdict plus severity-tagged…

    1.8k GitHub stars~700 tokensUpdated 24 days ago
    DevelopmentAuto-check passed
  • Comprehensive dimension analysis and reporting for CJA. An agent skill from adobe/skills.

    197 GitHub stars~3.3k tokensUpdated today
    Data & AnalyticsAuto-check passed
  • How to add a new attribute value (dimension) that the generic org-scoped telemetry.query analytics endpoint can group by and filter on.

    273 GitHub stars~2.4k tokensUpdated today
    DatabasesAuto-check passed
  • Asserting Bounds And Dimensions

    skydoves/android-testing-skills

    A skill your agent uses to verify Compose layout measurements from a UI test using assertWidthIsEqualTo, assertHeightIsEqualTo, assertWidthIsAtLeast, assertHeightIsAtLeast…

    334 GitHub stars~3.3k tokensUpdated 4 mo ago
    MobileAuto-check passed

More from agentscope-ai/QwenPaw-Data

All 29 skills in this repo
  • Bi Report Generation

    agentscope-ai/QwenPaw-Data

    将 BI 数据分析结果组织成可视化 HTML 报告。当分析完成、需要生成报告时调用. An agent skill from agentscope-ai/QwenPaw-Data.

    127 GitHub stars~1.2k tokensUpdated 5 days ago
    Auto-check passed
  • Fetch Data

    agentscope-ai/QwenPaw-Data

    取数 / 查数据 / 拉数据 / 跑 SQL。把自然语言取数需求转为 SQL,经数据湖仓执行后返回查询结果供下游分析。任何需要业务数据的任务在工作区缺少对应文件时都必须先调用此技能——覆盖 BI 业务分析、留存 / 转化 / 同期群分析、数据探索 EDA、统计建模、定量计算、元数据查询、数据查询。命中任一即触发:(1) 直接索要指标或记录,如「DAU 多少」「上月销售额」「3…

    127 GitHub stars~2.5k tokensUpdated 5 days ago
    Auto-check passed
  • Bi Adaptive Threshold

    agentscope-ai/QwenPaw-Data

    通过量化历史数据的自然波动幅度,自适应计算判定阈值。当需要从数据本身确定阈值(如波动阈值、影响度阈值等)、而非使用固定值时调用。仅适用于日/周粒度阈值确定。

    127 GitHub stars~726 tokensUpdated 5 days ago
    Auto-check passed
  • Bi Anomaly Detection

    agentscope-ai/QwenPaw-Data

    基于阈值检测时间序列中的显著异常波动点。当需要找出指标异常波动日期、识别数据异动时调用. An agent skill from agentscope-ai/QwenPaw-Data.

    127 GitHub stars~637 tokensUpdated 5 days ago
    Auto-check passed
  • Bi Attribution Analysis

    agentscope-ai/QwenPaw-Data

    计算各维度(组)值对指标变动的贡献度,支持可加型量值指标和加权平均型/率值指标。当需要计算贡献度、解释指标"为什么涨/跌"时调用。

    127 GitHub stars~1.2k tokensUpdated 5 days ago
    Auto-check passed
  • Bi Causal Attribution

    agentscope-ai/QwenPaw-Data

    从运营周报、活动文档、对话输入或文档工具 API 中提取业务事件,与指标异常时间窗口对齐,生成有证据支撑的因果归因假设并排序。当已知指标存在异常波动、需要从外部文档证据中解释"为什么"时调用。

    127 GitHub stars~1.3k tokensUpdated 5 days ago
    Auto-check passed

Questions about Bi Dimension Drilldown

What does Bi Dimension Drilldown do?

对指标按维度逐层下拆,通过单维度扫描、交叉分析和层级下钻定位关键维度(组)值。当需要知道"从哪些维度拆解、按什么顺序拆解来定位指标变动来源"时调用。. Bi Dimension Drilldown is an agent skill from agentscope-ai/QwenPaw-Data.

How do I install Bi Dimension Drilldown in Claude Code?

Run `npx skills add agentscope-ai/QwenPaw-Data --skill bi-dimension-drilldown -a claude-code`. Or copy the skill folder (packages/qwenpaw-data-skills/skills/atomic/bi-dimension-drilldown in agentscope-ai/QwenPaw-Data) into .claude/skills/bi-dimension-drilldown in your project. Claude Code loads it when a task matches its description.

How do I install Bi Dimension Drilldown in Codex?

Run `npx skills add agentscope-ai/QwenPaw-Data --skill bi-dimension-drilldown -a codex`. Or copy the skill folder (packages/qwenpaw-data-skills/skills/atomic/bi-dimension-drilldown in agentscope-ai/QwenPaw-Data) into .agents/skills/bi-dimension-drilldown in your project. Codex loads it when a task matches its description.

Can I use Bi Dimension Drilldown in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add agentscope-ai/QwenPaw-Data --skill bi-dimension-drilldown -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/bi-dimension-drilldown, .gemini/skills/bi-dimension-drilldown, .github/skills/bi-dimension-drilldown and .opencode/skills/bi-dimension-drilldown in your project.

What does Bi Dimension Drilldown need to run?

SKILL.md names no scripts, command-line tools or credentials: Bi Dimension Drilldown is instructions for the agent only.

Does Bi Dimension Drilldown access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Bi Dimension Drilldown safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Bi Dimension Drilldown use?

Bi Dimension Drilldown is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Bi Dimension Drilldown use?

About 605 tokens (SKILL.md is roughly 2.4k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Bi Dimension Drilldown?

Skills that share tags, products or a category with Bi Dimension Drilldown: Dimensions (thedaviddias/Front-End-Checklist, 74k stars), Modeling Dimension Tables (PostHog/posthog, 40k stars), Six Dimension Code Review (a5c-ai/babysitter, 1.8k stars) and Cja Dimension Analysis (adobe/skills, 197 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Bi Dimension Drilldown?

agentscope-ai (a GitHub organization) maintains it in agentscope-ai/QwenPaw-Data, which has 127 GitHub stars. The repository holds 29 skills in this directory. The repository was last updated on October 5, 2026.

Source: agentscope-ai/QwenPaw-Data on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.