trend-analysis

Grades Excel data by group and forecasts performance using tiered growth rates.

2|Updated May 19, 2026

Search Tags:#data visualization #excel #forecasting #trend analysis #grading #kpi evaluation

Ready to run

npx skills add https://github.com/aiyinluya/SenseNova-Skills-Studio --skill trend-analysis-aiyinluya

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: trend-analysis
Source: https://github.com/aiyinluya/SenseNova-Skills-Studio/tree/main/skills/sn-da-excel-workflow/capability/excel-data-analysis/trend-analysis
Command: npx skills add https://github.com/aiyinluya/SenseNova-Skills-Studio --skill trend-analysis-aiyinluya

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It helps you turn multi-dimensional performance data into ranked evaluations and actionable trend forecasts without manual calculation and charting.

Core Features & Use Cases

Multi-dimensional grading: Groups data by a specified dimension, ranks aggregate performance, and assigns each group a grade (high/medium/low).
Differential growth-rate forecasting: Applies different growth-rate assumptions per grade to compute predicted values and overall growth.
Comparison visualization: Generates horizontal bar charts comparing current vs. forecasted values with grade labels for quick stakeholder communication.

Quick Start

Provide your Excel file, specify the group column and target value column, and ask the skill to produce graded forecasts with a comparison chart and an overall growth conclusion.

Frequently Asked Questions about trend-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I forecast future KPI performance from Excel data?▼

KPI forecasting from Excel data is done by grouping records, assigning performance grades, and applying grade-specific differential growth rates to calculate future predicted values and generate comparison bar charts.

What is the best way to compare departmental performance and predict future trends?▼

Comparing departmental performance and predicting trends involves grouping data by dimension, ranking aggregate values into grades, and applying differential growth rates to compute forecasts and visualize comparison bar charts.

Can I use Excel datasets for multi-dimensional grading and target setting?▼

Excel datasets support multi-dimensional grading and target setting by loading tables into pandas, aggregating values by group columns, assigning high/medium/low performance grades, and applying differential growth rates to compute forecasted targets.

How do I generate comparison bar charts showing current vs forecasted values?▼

Generating comparison bar charts for current versus forecasted values requires computing grade-based predictions for grouped data and rendering horizontal bar charts with grade labels and Chinese font support for stakeholder communication.

Does trend analysis forecasting work with pandas for periodic planning?▼

Trend analysis forecasting works with pandas for periodic planning by loading Excel datasets, aggregating grouped data, mapping performance grades to growth-rate parameters, and computing predicted values to visualize overall growth trends.