skills.rest
aiyinluya
aiyinluyaCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/aiyinluya/SenseNova-Skills-Studio --skill trend-analysis-aiyinluya
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
niranjannavniranjannav

excel_data_analysis

Analyze Excel spreadsheets to extract summaries, formulas, and data quality issues.

Community
Intermediate
OliverOuyangOliverOuyang
1

html-report-framework

Generate responsive HTML reports from data and templates with PDF export.

Community
Advanced
MichaelYang-lyxMichaelYang-lyx
110

category-statistics

Extract category distributions and generate bar, pie, and horizontal charts from datasets.

Community
Intermediate
MichaelYang-lyxMichaelYang-lyx
110

trend-analysis

Evaluate multi-dimensional data and forecast trends with pandas and matplotlib.

Community
Advanced