Comparison Reporter

Pro v1.0.0 1 view

Generate executive-ready MoM/QoQ/YoY period comparison reports with automated growth rate calculations, variance analysis, formatted tables, and visualizations to identify key business metric changes.

What You Get

Generate executive-ready period comparison reports in minutes with automated calculations, root cause analysis, and board-ready insights - eliminating hours of manual spreadsheet work.

The Problem

Comparing business metrics across months, quarters, or years requires tedious manual work: calculating growth rates, variance percentages, creating formatted tables, and preparing board-ready reports in spreadsheets. This takes hours and is error-prone.

The Solution

This skill automates the entire comparison analysis workflow by processing your time series data (CSV or Excel files) and performing comprehensive period-over-period analysis. It automatically converts dates, creates period labels, and computes absolute changes, percentage changes, and trend indicators for all your metrics. The skill identifies the biggest changes in your data and performs root cause analysis to explain what drove those changes. For composite metrics like revenue, it breaks down whether changes came from volume, price, or both. It creates professional comparison charts, percent change visualizations, and trend lines. You receive specific, actionable insights with contributing factor breakdowns and executive summaries formatted for board presentations.

How It Works

  1. 1 Upload CSV or Excel file with time series data containing date column and metrics to compare
  2. 2 Skill parses dates and creates period labels based on comparison type (MoM, QoQ, or YoY)
  3. 3 Specify current period and comparison period, then select which metrics to analyze
  4. 4 Skill calculates absolute changes, percentage changes, and trend indicators for all selected metrics
  5. 5 System generates formatted comparison tables with proper alignment, units, and trend emoji indicators
  6. 6 Visualizations created showing period comparisons, percent change bars, and historical trend lines
  7. 7 Skill identifies biggest changes and performs root cause analysis on contributing factors
  8. 8 Receive executive summary with insights, strategic recommendations, and board-ready formatted output

What You'll Need

  • Time series data in CSV or Excel format with a date column and numeric metrics
  • At least two time periods of data available for comparison analysis
  • Python environment with pandas and matplotlib for calculations and visualizations

Get This Skill

Requires Pro subscription ($9/month)

Have Feedback?

Help us improve this skill by sharing your ideas and suggestions.

Request Improvements

Examples

E-commerce Monthly Revenue Comparison

Month-over-month comparison for an online retailer tracking revenue, orders, and customers. Demonstrates standard MoM analysis with growth calculations, contributing factor breakdown, and actionable recommendations for a positive growth scenario.

View example

SaaS Quarterly Metrics Board Report

Quarter-over-quarter analysis for a SaaS company tracking MRR, new MRR, churned MRR, and customer count. Shows board-ready formatting with net new MRR calculations, churn analysis, and strategic recommendations for Q4 planning.

View example

Year-over-Year Decline Analysis

Year-over-year comparison showing declining performance across revenue, orders, and conversion rate. Demonstrates how the skill handles negative growth scenarios with concern flagging, root cause analysis, and critical recommendations for turnaround.

View example
View all examples