تشغيل أي مهارة في Manus بنقرة واحدة

chatbi-decision-advisor

النجوم٢

التفرعات١

آخر تحديث١٨ مايو ٢٠٢٦ في ٠٩:٣٠

Use when Codex or another agent needs to generate rule-based decision recommendations from the local ChatBI demo database by computing sales, target achievement, gross margin, region, channel, product, and customer retention metrics first, then deriving structured business advice, actions, priorities, and evidence. Use for 决策意见, 经营建议, 管理建议, 下一步动作, and recommendation generation from existing ChatBI data.

التثبيت

التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.

تشغيل في Manus

المصدر

secary

secary/chat-bi

فتح مستودع GitHub عرض مستودعات المنشئ

تنزيل

تشغيل في Manus

المهن ذات الصلةSOC

استنادا إلى تصنيف SOC المهني

محللو الإدارةمهن الأعمال والعمليات المالية·SOC 13-1111

مستكشف الملفات

6 ملفات

SKILL.md

readonly

name	chatbi-decision-advisor
description	Use when Codex or another agent needs to generate rule-based decision recommendations from the local ChatBI demo database by computing sales, target achievement, gross margin, region, channel, product, and customer retention metrics first, then deriving structured business advice, actions, priorities, and evidence. Use for 决策意见, 经营建议, 管理建议, 下一步动作, and recommendation generation from existing ChatBI data.
trigger_conditions	["用户要经营建议、决策意见、管理建议或下一步动作","问题含区域/渠道/产品等业务范围可供脚本取数"]
when_not_to_use	["用户只要单一指标查询结果（用 chatbi-semantic-query）","对话主题是上传文件分析"]
required_context	["演示库问数场景；首参保留用户原述"]

ChatBI Decision Advisor

Use this skill to produce decision advice from computed ChatBI metrics.

Workflow

Run scripts/generate_decision_advice.py to calculate facts from MySQL and produce rule-based advice.
Use Markdown output for human-facing decision notes.
Use --json when another agent, report generator, or dashboard needs structured facts and recommendations.
Treat the advice as deterministic rule output grounded in metrics. If an LLM is used later, use it only to rewrite or summarize the generated facts and advice.
Use chatbi-semantic-query separately when the user asks for one specific metric query rather than a full decision recommendation.

Commands

python3 scripts/generate_decision_advice.py
python3 scripts/generate_decision_advice.py --json
python3 scripts/generate_decision_advice.py "华东2026年4月决策建议"
python3 scripts/generate_decision_advice.py --question "线上渠道软件服务决策建议" --json

Run commands from this skill directory, or pass the full path to the bundled script.

What It Computes

Overall sales, target achievement, gross margin, order count, and customer count.
Monthly sales trend and monthly margin/target completion.
Region sales, target achievement, and gross margin ranking.
Channel sales and gross margin ranking.
Product category sales and gross margin ranking.
Monthly customer retention, churn, active customers, and new customers.

Natural-Language Scope

The optional question can limit the advice scope by:

Time: 2026年4月, 2026年1月到4月, 2026年
Region: values such as 华东, 华南, 华北, 西南
Department: values such as 商业增长部, 数据产品部, 咨询服务部
Product category/name: values such as 软件服务, 数据产品, 咨询服务, 智能分析平台
Channel: values such as 线上, 渠道, 直销
Customer type: values such as 企业客户, 中小客户

When the scope includes sales-only dimensions such as channel, product, or department, omit customer-retention advice because customer_profile does not contain those fields.

Advice Rules

High target achievement triggers growth target and replication advice.
Low target achievement triggers gap-closing advice.
Positive monthly sales growth triggers growth consolidation advice.
Region ranking triggers regional replication and weak-area follow-up advice.
Channel and product margin ranking triggers portfolio optimization advice.
Customer retention triggers retention and churn management advice.
Low gross margin triggers profitability repair advice.

Visualization Guidance

Use this skill's structured JSON facts to produce an executive-style answer: decision text first, then KPI cards and focused supporting charts. Do not ask the LLM to invent chart data; charts must come from computed facts.

Use KPI cards for overview facts: sales, target achievement, gross margin, order count, customer count, and latest retention.
Use a line chart for monthly sales, monthly target achievement, monthly gross margin, or retention trends.
Use a bar chart for region, channel, or product category rankings.
Use semantic colors in KPI cards: success for strong target achievement, warning for moderate risks, danger for low achievement or low margin, and neutral for context metrics.
Keep advice text and charts linked: every chart should support one recommendation or evidence point in the advice.
Prefer tooltip, legend filtering, click highlight, and dataZoom for monthly trend charts.

Database Defaults

The bundled script defaults to:

Host: 127.0.0.1
Port: 3307
Database: chatbi_demo
User: demo_user
Password: demo_pass

Override with environment variables:

CHATBI_DB_HOST
CHATBI_DB_PORT
CHATBI_DB_USER
CHATBI_DB_PASSWORD
CHATBI_DB_NAME

Safety

This skill runs read-only SELECT queries. Do not make database changes with this skill.

المزيد من هذا المستودع

نفس المستودع

chatbi-database-overview

secary/chat-bi

Use when Codex or another agent needs to summarize the currently connected ChatBI business database, list queryable tables or views, explain what each table contains, show row counts, fields, semantic metrics, dimensions, aliases, or answer questions like 当前数据库有哪些表可以查, 数据库概览, 业务库结构, 表清单, schema 概述.

2026-06-022

chatbi-semantic-query

secary/chat-bi

Use when Codex or another agent needs to answer Chinese natural-language data questions against the local ChatBI demo MySQL database, map business terms to governed metrics and dimensions, generate safe read-only SQL, execute metric queries, or return JSON/table results for sales, revenue, gross margin, target achievement, customer, retention, region, channel, product, and monthly trend analysis.

2026-06-012

chatbi-alias-manager

secary/chat-bi

Use when Codex or another agent needs to add missing Chinese synonyms, aliases, or business phrasing to the local ChatBI semantic layer, especially when a natural-language query uses a new word that should map to an existing metric or dimension in alias_mapping. Supports safely inserting aliases for governed metrics and dimensions such as 销售额, 毛利, 目标完成率, 客户留存率, 区域, 时间, 部门, 产品类别, 产品名称, 渠道, and 客户类型.

2026-05-182

chatbi-auto-analysis

secary/chat-bi

Auto-analysis middleware for uploaded tables. It profiles table rows, proposes metrics for user confirmation, executes accepted metrics with deterministic calculations, and emits frontend-ready analysis proposal/dashboard JSON for charts and dashboards.

2026-05-182

chatbi-chart-recommendation

secary/chat-bi

BI chart recommendation for ChatBI and analytics workflows. Use when Codex needs to choose chart types and emit frontend-ready chart recommendation JSON from a user's analysis intent, Query Intent JSON, SQL result metadata, or tabular data, especially after natural language to SQL to data pipelines.

2026-05-182

chatbi-comparison

secary/chat-bi

Use when the user asks for month-over-month (环比) comparison of business metrics such as sales, gross margin, order count, or customer count. Triggers on phrases like "环比", "上月对比", "月度对比", "和上个月比", "比上月", "月环比". Returns a comparison table with absolute change and percentage change, plus a grouped bar chart plan.

2026-05-182

name	chatbi-decision-advisor
description	Use when Codex or another agent needs to generate rule-based decision recommendations from the local ChatBI demo database by computing sales, target achievement, gross margin, region, channel, product, and customer retention metrics first, then deriving structured business advice, actions, priorities, and evidence. Use for 决策意见, 经营建议, 管理建议, 下一步动作, and recommendation generation from existing ChatBI data.
trigger_conditions	["用户要经营建议、决策意见、管理建议或下一步动作","问题含区域/渠道/产品等业务范围可供脚本取数"]
when_not_to_use	["用户只要单一指标查询结果（用 chatbi-semantic-query）","对话主题是上传文件分析"]
required_context	["演示库问数场景；首参保留用户原述"]

ChatBI Decision Advisor

Use this skill to produce decision advice from computed ChatBI metrics.

Workflow

Run scripts/generate_decision_advice.py to calculate facts from MySQL and produce rule-based advice.
Use Markdown output for human-facing decision notes.
Use --json when another agent, report generator, or dashboard needs structured facts and recommendations.
Treat the advice as deterministic rule output grounded in metrics. If an LLM is used later, use it only to rewrite or summarize the generated facts and advice.
Use chatbi-semantic-query separately when the user asks for one specific metric query rather than a full decision recommendation.

Commands

python3 scripts/generate_decision_advice.py
python3 scripts/generate_decision_advice.py --json
python3 scripts/generate_decision_advice.py "华东2026年4月决策建议"
python3 scripts/generate_decision_advice.py --question "线上渠道软件服务决策建议" --json

Run commands from this skill directory, or pass the full path to the bundled script.

What It Computes

Overall sales, target achievement, gross margin, order count, and customer count.
Monthly sales trend and monthly margin/target completion.
Region sales, target achievement, and gross margin ranking.
Channel sales and gross margin ranking.
Product category sales and gross margin ranking.
Monthly customer retention, churn, active customers, and new customers.

Natural-Language Scope

The optional question can limit the advice scope by:

Time: 2026年4月, 2026年1月到4月, 2026年
Region: values such as 华东, 华南, 华北, 西南
Department: values such as 商业增长部, 数据产品部, 咨询服务部
Product category/name: values such as 软件服务, 数据产品, 咨询服务, 智能分析平台
Channel: values such as 线上, 渠道, 直销
Customer type: values such as 企业客户, 中小客户

When the scope includes sales-only dimensions such as channel, product, or department, omit customer-retention advice because customer_profile does not contain those fields.

Advice Rules

High target achievement triggers growth target and replication advice.
Low target achievement triggers gap-closing advice.
Positive monthly sales growth triggers growth consolidation advice.
Region ranking triggers regional replication and weak-area follow-up advice.
Channel and product margin ranking triggers portfolio optimization advice.
Customer retention triggers retention and churn management advice.
Low gross margin triggers profitability repair advice.

Visualization Guidance

Use KPI cards for overview facts: sales, target achievement, gross margin, order count, customer count, and latest retention.
Use a line chart for monthly sales, monthly target achievement, monthly gross margin, or retention trends.
Use a bar chart for region, channel, or product category rankings.
Use semantic colors in KPI cards: success for strong target achievement, warning for moderate risks, danger for low achievement or low margin, and neutral for context metrics.
Keep advice text and charts linked: every chart should support one recommendation or evidence point in the advice.
Prefer tooltip, legend filtering, click highlight, and dataZoom for monthly trend charts.

Database Defaults

The bundled script defaults to:

Host: 127.0.0.1
Port: 3307
Database: chatbi_demo
User: demo_user
Password: demo_pass

Override with environment variables:

CHATBI_DB_HOST
CHATBI_DB_PORT
CHATBI_DB_USER
CHATBI_DB_PASSWORD
CHATBI_DB_NAME

Safety

This skill runs read-only SELECT queries. Do not make database changes with this skill.