Data & Analytics

ahang1598 Skill

Transform data into compelling narratives using visualization, context, and persuasive structure. Use when presenting analytics to stakeholders, creating data reports, or building executive presentations.

ahang1598 Bundle

Generate professional clinical decision support (CDS) documents for pharmaceutical and clinical research settings, including patient cohort analyses (biomarker-stratified with outcomes) and treatment recommendation reports (evidence-based guidelines with decision algorithms). Supports GRADE evidence grading, statistical analysis (hazard ratios, survival curves, waterfall plots), biomarker integration, and regulatory compliance. Outputs publication-ready LaTeX/PDF format optimized for drug development, clinical research, and evidence synthesis.

ahang1598 Bundle

Use CloudBase document database Web SDK to query, create, update, and delete data. Supports complex queries, pagination, aggregation, and geolocation queries.

ahang1598 Bundle

把本地文件上传到云端（阿里云 OSS），返回可公开访问的 HTTPS URL。任何"需要一个 URL 而手头只有本地文件"的场景都走本 skill——例如把生成的图片/视频/报告/CSV/PDF 回传给前端展示、分享给用户、或喂给只接受 URL 入参的下游接口（如商品库更新图片、A+ 图入库、把素材链接写回飞书表格）。用户说"上传文件""把这个图/视频/文件传上去""传到 OSS/云端""给我个下载链接/公开链接""upload this file""get a public url"时触发；即使没说"上传"二字，只要要把本地产物变成可访问链接、或某接口要求传 imageUrls/url 而当前只有本地路径，也应触发本 skill。注意：上传即对外发布，文件会获得公开可访问 URL；上传前确认内容可公开。

ahang1598 Bundle

Use CloudBase document database WeChat MiniProgram SDK to query, create, update, and delete data. Supports complex queries, pagination, aggregation, and geolocation queries.

ahang1598 Bundle

Design KPI frameworks, metric definitions, targets, guardrails, and measurement plans for product or business decisions. Use when success metrics, drivers, guardrails, targets, or the measurement approach need to be defined or improved.

ahang1598 Bundle

Control an open or active Microsoft Excel workbook through the ChatGPT add-in or connected session. Use when the user tags the Microsoft Excel app in Codex or follows up on an established live Excel task. Do not use for standalone spreadsheet files or Google Sheets.

ahang1598 Bundle

Build polished analytical reports for executive, product, business, or technical audiences. Use when the task needs a durable answer-first narrative with evidence-backed findings, visuals or tables, caveats, and source context.

ahang1598 Bundle

投资方律师IP资产台账生成与风险评估，覆盖投前尽调至年度盘点四场景，同步输出xlsx台账+Markdown报告。触发：IP资产盘查/权属核验/许可链追踪/IP出资瑕疵/R&W条款映射。不触发：IP侵权诉讼/合同审查/全面尽调/陷阱条款对抗。

ahang1598 Bundle

Prepare KPI readouts, scorecards, WBR/MBR/QBR updates, and executive summaries from quantitative business or product metrics; use when the task is to report status, compare against targets, explain validated drivers, and state operating implications.

ahang1598 Bundle

Estimate market, segment, or opportunity size with transparent assumptions and uncertainty. Use for TAM/SAM/SOM, sizing scenarios, or comparing the scale of possible opportunities.

ahang1598 Bundle

Validate whether an analysis is accurate, well-supported, and ready to share or use for a decision. Use when reviewing methodology, calculations, comparisons, visuals, caveats, or conclusions.

ahang1598 Bundle

Create or update a reusable personal Codex artifact-template skill. Use when the user invokes $template-creator or asks in natural language to create a reusable template from a reference document, presentation, spreadsheet, ImageGen or Product Design image, email, or Slack message, or explicitly asks to edit or update a passed artifact-template skill. Do not use for one-off creation from an existing template.

ahang1598 Bundle

Design, build, revise, or QA quantitative charts and figures. Use when an analytical answer needs visual judgment, whether for an inline answer, report, dashboard, notebook, or artifact.

ahang1598 Bundle

TCHouse-C（ClickHouse）自然语言 SQL 生成 Skill。用户通过自然语言描述分析需求，AI 自动理解意图、生成对应 SQL 语句，并给出图表可视化建议与中文业务解读思路。 ⚠️ 当前版本仅生成 SQL 与分析建议，不直接执行 SQL；用户需自行将生成的 SQL 复制到 TCHouse-C 控制台的 SQL 工作区（DMS）或其他客户端执行。 触发词：数据分析、统计、报表、趋势图、柱状图、饼图、折线图、数据查询、NL2SQL、自然语言查询、帮我写SQL、帮我生成SQL、帮我查一下、帮我统计、帮我分析、按天统计、按月统计、分组统计、TOP排名、占比分析、同比、环比、趋势分析、ClickHouse查询、TCHouse-C查询、cdwch、SQL生成、GMV、DAU、转化率、支付金额、订单量。 本 Skill 包含 3 个子能力：①自然语言转 SQL（NL2SQL）②智能图表可视化推荐 ③中文业务结论摘要撰写建议。 何时不触发：慢 SQL 诊断与自动调优（已有 SQL 的性能分析）、集群健康诊断与故障排查（监控指标/告警/节点故障）、集群选型与架构推荐、智能建表与数据建模、集群扩缩容操作、权限管理、数据导入导出等非 SQL 生成相关问题不走本 Skill。

ahang1598 Bundle

Build source-backed dashboards for monitoring performance, exploring drivers, or acting on product and business metrics. Use when the task needs a dashboard, scorecard, or monitoring view with clear metrics, filters, source definitions, and QA.

ahang1598 Skill

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

ahang1598 Bundle

Create, edit, or validate reproducible SQL or Python notebooks. Use for notebooks, SQL/Python scratchpads, reproducible exploration, audit trails, or runnable companions where the analysis should be reviewable or rerunnable.

ahang1598 Bundle

TCHouse-C（ClickHouse）智能建表与数据建模 Skill。AI 根据用户描述的业务场景（日增数据量、查询模式、数据保留周期等），推荐合适的表引擎，设计分区策略与排序键，生成完整的 DDL 语句及设计理由说明。支持新建表设计、MySQL 迁移方案、现有表结构优化诊断。 ⚠️ 当前版本仅生成 DDL 与设计方案，不直接执行建表；用户需自行将生成的 DDL 复制到 TCHouse-C 控制台的 SQL 工作区（DMS）或其他客户端执行。 触发词：建表、DDL、CREATE TABLE、表设计、表结构、数据建模、分区策略、排序键、ORDER BY、PARTITION BY、表引擎、MergeTree、ReplacingMergeTree、AggregatingMergeTree、CollapsingMergeTree、SummingMergeTree、VersionedCollapsingMergeTree、数据模型、schema设计、索引设计、跳数索引、主键设计、分区键、TTL、数据保留、数据过期、宽表、维度表、事实表、日志表、订单表、用户表、MySQL迁移、迁移方案、表结构优化、ClickHouse建表、TCHouse-C建表、cdwch。 本 Skill 包含 4 个子能力：①表引擎推荐 ②分区策略与排序键设计 ③完整 DDL 生成 ④现有表结构优化诊断。 何时不触发：慢 SQL 诊断与自动调优（已有 SQL 的性能分析）、NL2SQL 数据分析查询、集群健康诊断与故障排查、集群选型与架构推荐、集群扩缩容操作、权限管理、数据导入导出等非建表/数据建模相关问题不走本 Skill。

ahang1598 Bundle

Diagnose why a metric changed or differs from expectation. Use when the task is to identify likely drivers of a metric movement, anomaly, gap, or discrepancy.

ahang1598 Skill

This is the required documentation for agents operating on the CloudBase Relational Database. It lists the only four supported tools for running SQL and managing security rules. Read the full content to understand why you must NOT use standard Application SDKs and how to safely execute INSERT, UPDATE, or DELETE operations without corrupting production data.

ahang1598 Bundle

Create, update, inspect, or repair Data Analytics semantic layers. Use when the user asks to save data context or create a semantic layer that future Data Analytics work can inspect and cite.

ahang1598 Bundle

Assess whether structured data, query results, dashboards, or analytical evidence are trustworthy enough to use. Use when the task is to check data quality, reconcile conflicting sources or metric definitions, or decide whether evidence is safe to cite.

ahang1598 Bundle

ABA 新词挖掘专家（ABA New Keyword Mining Expert）——完整流程：ABA 智能查询返回 searchTerm + searchFrequencyRank，AI 批量翻译为中文，合并导出 6 列 CSV（序号/搜索词/中文翻译/搜索频率排名/标记/备注），支持 OFFSET 分页获取不重复批次。用户说"找季节性关键词""找爆发词""找新进入榜单的词""ABA挖词""导出ABA结果""找去年某月突然上榜的词""找近N周新进榜单的词""批量挖ABA关键词""导出CSV方便筛选""ABA关键词翻译""ABA新词挖掘""seasonal keyword mining""ABA keyword export""find trending search terms""export ABA to CSV""translate ABA keywords""ABA new keyword mining"时触发。即使用户没说"挖掘"二字，只要意图是"用ABA数据按时间/排名条件筛选搜索词并导出"就应触发本skill。与linkfox-aba-intelligent-query的区别：本skill专注"挖掘+翻译+导出"完整工作流，自带AI翻译、CSV落盘和分页去重；如果只需查单个词的排名趋势或Top ASIN点击转化，用linkfox-aba-intelligent-query。按动态规则计费，同一会话同参数24h缓存。

ahang1598 Bundle

Amazon搜索建议词（自动补全）挖掘工具。完整自动化「手动下拉框挖词技巧」， 基于 www.amazon.com/suggestions API，从种子词出发批量扩展长尾关键词。 支持7种模式：批量扩展(expand)/A-Z后缀(az)/A-Z前缀(az_prefix)/数字拓展(numbers)/空格间隙插入(gap)/逆向滚雪球(reverse)/深度递归(deep)。 内置随机抖动+指数退避重试防封机制。支持23个Amazon全球站点+种子词自动翻译，最终交付 Excel(xlsx) 多Sheet结构化词库。 用户说"搜索建议词""自动补全""suggestion""autocomplete""长尾词挖掘""搜索词扩展""关键词扩展" "suggestion mining""keyword expansion""Amazon下拉词""搜索框建议""搜索联想词""手动挖词""下拉框挖词"时触发。 即使用户没说"挖掘"二字，只要意图是"从Amazon搜索框扩展大量长尾关键词并导出Excel"就应触发本skill。 与 linkfox-aba-new-keyword-miner 的区别：本skill从搜索框自动补全扩展长尾词（种子词驱动）， ABA新词挖掘从ABA品牌分析数据库按时间/排名条件筛选搜索词（条件驱动）。两者互补，可串联使用。 直接调Amazon公开API，不通过LinkFox网关，不计费。建议每2-4周重新挖掘一次以获取最新数据。

ahang1598 Bundle

Gather business context from connected or provided sources so downstream analysis starts with the right framing. Use when an analytical question depends on missing context, such as what a metric means, what changed recently, or which sources should be checked. If the same prompt asks for diagnosis, recommendation, or a deliverable, gather context first and continue to the focused skill.

ahang1598 Bundle

Analyze product or business data to support a decision or recommendation. Use when a decision depends on metric-backed evidence, such as choosing a direction, prioritizing an opportunity, evaluating a change, segmenting users, sizing tradeoffs, or deciding what to do next.

ahang1598 Skill

Publish a validated Data Analytics report or dashboard artifact through Sites. Use automatically for durable artifacts in any positively identified Work Mode when the full Sites lifecycle is callable, or in ChatGPT Desktop outside Work Mode only after an explicit Sites request or acceptance of the optional post-handoff sharing offer.

ahang1598 Bundle

Narrow conversion skill. Invoke only when the user explicitly asks to convert an existing Data Analytics report, dashboard, or inline chart export into a PDF artifact.

ahang1598 Skill

Tabular review — one row per document, one column per data point, every cell cited to source. Built for M&A diligence ("review these 200 target contracts for change-of-control, assignment, and MAC clauses") but works for any batch review that needs a spreadsheet out the other end. Use when user says "tabular review", "review grid", "build a grid", "extract these fields from these contracts", "review these documents for X, Y, Z", "give me a spreadsheet of", "batch review", or points at a folder of documents and asks to compare them.

ahang1598 Skill

Entity compliance tracker — initialize, report upcoming deadlines, update status, run health audit, export to CSV. Maintains a compliance-tracker.yaml built from the entity table, calculates filing deadlines by entity and jurisdiction, and surfaces what's due in the next 30/60/90 days. Use when user says "entity compliance", "filing deadlines", "annual reports due", "entity tracker", "what filings are due", "entity health", or "good standing".

ahang1598 Bundle

Create a spreadsheet using the Project Tracker template and its retained reference file. Use when the user selects or names Project Tracker. Manage workstreams, tasks, owners, status, priority, dates, launch pulse, and a Gantt schedule.

ahang1598 Bundle

Create a spreadsheet using the Financial Budget template and its retained reference file. Use when the user selects or names Financial Budget. Model actuals, budget and scenario forecasts, variances, cash runway, and departmental plans.

ahang1598 Bundle

Create a spreadsheet using the Operating Calendar template and its retained reference file. Use when the user selects or names Operating Calendar. Plan annual and monthly operating milestones, campaigns, launches, deadlines, and recurring events.

ahang1598 Bundle

Create a spreadsheet using the Analytics Dashboard template and its retained reference file. Use when the user selects or names Analytics Dashboard. Monitor acquisition, engagement, retention, revenue, and conversion funnel KPIs with charts.

ahang1598 Bundle

Create a spreadsheet using the Three-Statement Forecast template and its retained reference file. Use when the user selects or names Three-Statement Forecast. Build an integrated income statement, balance sheet, and cash flow forecast with assumptions, checks, and an executive summary.