AnalyticsPro
← Back to Portal

Training & User Guide

Master xFalcon AnalyticsPro — your complete guide to navigating dashboards, understanding KPIs, and answering business questions with data.

Getting Started

Opening the Portal

Open index.html in your web browser to launch the xFalcon AnalyticsPro portal. You'll see:

  • Executive KPI Cards — Top-line metrics: Net Revenue, Gross Profit, COGS, Margin %
  • Key Charts — Trending revenue, margin, and customer metrics
  • Customer Table — Top customers by revenue
  • Dashboard Directory — 11 specialized analytics dashboards
  • Resources Section — Links to documentation and support
Navigation Basics

The portal is organized into 11 focused dashboards, each answering a specific business question:

  • Click any dashboard card in the Directory to open that dashboard
  • Use "← Back to Portal" link in the topbar to return to the home page
  • Use the sticky Table of Contents at the top of this guide to jump between sections
  • All data is read-only — reports refresh automatically based on source data

Understanding KPI Cards

Card Structure

Every KPI card follows the same layout:

  • Label — Metric name (e.g., "Net Revenue")
  • Value — Current period number (e.g., "$31.5M")
  • Arrow — Direction indicator (↑ or ↓)
  • Comparison — Change vs. prior year or period
Interpreting Arrows

Green ↑ = Improvement (higher is better)

Examples: Revenue, Profit, Growth Rate, Customer Count

Red ↓ = Decline (lower may be better)

Examples: COGS, Discounts, Returns, Churn Rate

Real Example

Net Revenue

$31.5M ↑ +45.8%

vs. Last Year

Context Matters

Always consider the business context. For example:

  • COGS ↓ (Red Arrow) — Actually good! Lower cost = higher profit margin
  • Returns ↑ (Red Arrow) — Problem. More returns = lost revenue
  • Fill Rate ↓ (Red Arrow) — Concerning. Out-of-stock hurts sales

Chart Types with Live Examples

Below are the 5 main chart types used across xFalcon dashboards. Each example uses live Chart.js rendering with real-world data patterns.

A. Grouped Bar Chart

Purpose: Compare two or more categories side-by-side across groups (e.g., regions, time periods, brands).

How to read: Taller bar = higher value. Grouped bars let you spot differences between years or products at a glance.

Sample: 2024 vs 2025 Revenue by Region

Gray bars = 2024 data | Blue bars = 2025 growth

B. Horizontal Bar Chart

Purpose: Rank categories with long names. Read top-to-bottom: highest at top, lowest at bottom.

How to read: Length of bar represents value. Easier to read category labels than vertical bars.

Sample: Revenue by Sales Channel

Grocery leads, eCommerce growing, Club smallest

C. Line Chart

Purpose: Track trends over time. Multiple lines show how metrics evolve and compare across periods.

How to read: Steep slope = rapid change. Overlapping lines show if trends are aligning or diverging.

Sample: Monthly Revenue Trend 2024 vs 2025

Gray line = 2024 | Blue line = 2025 (accelerating upward)

D. Waterfall Chart

Purpose: Show how a starting value flows through additions and deductions to arrive at an ending value.

How to read: Each segment shows a step. Down = cost/deduction, Up = addition/gain. Final bar = result.

Sample: Gross Revenue → Net Revenue Waterfall

Start at $36.5M → Trade Discounts (-$5M) → Net $31.5M → COGS (-$17.3M) → Gross Profit $14.2M

E. Annual Trend Bar

Purpose: Quick multi-year performance snapshot. One bar per year shows the arc of growth or decline.

How to read: Bar height = annual value. Consistent growth = rising bars. Flat = mature. Declining = falling bars.

Sample: Annual Net Revenue (2020-2025)

Flat growth 2020-2024, then surge in 2025 (+46%)

Using Filters

Filter Basics

Most dashboards have filter controls at the top. Use them to:

  • Zoom into a specific region, brand, or channel — All charts below update instantly
  • Compare time periods — Select fiscal year, quarter, or month
  • Segment by customer type — Filter to Retail, DTC, or All
  • Focus on product categories — Filter by brand or category
Filter Tips
  • Multi-select: Most filters allow selecting multiple values. Click checkboxes to add/remove.
  • Clear all: Look for a "Reset" button to clear all filters and see full dataset.
  • Charts update automatically: No refresh button needed — filters are real-time.
  • Combine filters: Use region + brand together for detailed deep-dives.

Which Dashboard Do I Use?

Not sure where to find the data you need? Answer a business question below and we'll show you the best dashboard(s) to visit.

How is the business performing overall?

Why is revenue up or down?

Which products should we invest in?

Are we profitable enough?

Who are our most important customers?

Which channels are growing?

Is our supply chain healthy?

Are our promotions working?

What do shoppers actually buy?

Where should we expand?

How is the business performing overall?

Start with 01Executive Overview — this is your executive summary. See top-line KPIs, key metrics, year-over-year growth, and trending performance at a glance.

Open Dashboard →
Why is revenue up or down?

Investigate with 02Sales & Revenue — drill into which brands, regions, and channels drove the result. See waterfall decomposition and trend analysis.

Open Dashboard →
Which products should we invest in?

Review both 03Product Performance (sales volume, growth) and 04Product Margin (profitability). Combine to find high-growth, high-margin opportunities.

Product Performance → Product Margin →
Are we profitable enough?

Go to 04Product Margin to see gross margin by brand and category. Cross-check with 01Executive Overview for company-wide margin trends.

Open Dashboard →
Who are our most important customers?

Use 05Customer Intelligence to identify top customers by revenue, frequency, basket size, and segment. Includes retention and churn analysis.

Open Dashboard →
Which channels are growing?

Check 06Channel & POS Analytics to see revenue and growth by retail channel (grocery, mass, club, eCommerce). Includes point-of-sale trends.

Open Dashboard →
Is our supply chain healthy?

Review 07Shipments & Fill Rate (order fulfillment, delivery health) and 08Inventory (stock levels, turns, weeks of supply).

Shipments → Inventory →
Are our promotions working?

Visit 09Trade Spend / Promo ROI to measure promotional effectiveness, incremental lift, and return on promotional investment by brand and region.

Open Dashboard →
What do shoppers actually buy?

Use 10Consumer Panel to see actual shopper purchase patterns, preferences, brand loyalty, and consumer trends in the market.

Open Dashboard →
Where should we expand?

Start with 11Geographic Performance to identify fast-growing regions and untapped markets. Cross-reference with Customer Intelligence and Channel Analytics.

Open Dashboard →

Analysis Walkthroughs

See how to use multiple dashboards together to answer complex business questions. Each scenario shows a real-world workflow.

Scenario A: Preparing for a Quarterly Business Review

1

Start at Executive Overview (01) — Note top-line KPIs: Net Revenue, Gross Profit, Margin %, Growth vs. prior quarter.

2

Check Sales & Revenue (02) — Identify which brands and channels drove results. Look for surprises.

3

Review Product Margin (04) — Confirm profitability trends. Any margin compression? Which brands are improving?

4

Check Shipments & Fill Rate (07) — Note any supply chain issues that might impact future growth.

5

Summarize findings: Revenue, Margin, Top Brands, Supply Chain status. Ready for the boardroom.

📊
Generate QBR Package

Opens Executive Overview, Sales & Revenue, Product Margin, and Shipments & Fill Rate in new tabs. Use filters on each dashboard to select your time period.

Scenario B: Investigating a Margin Drop

1

Start at Product Margin (04) — Which brands have declining Gross Margin %? Filter by brand to isolate the culprit.

2

Cross-reference with Product Performance (03) — Is it a volume mix problem? Are cheaper SKUs outselling premium ones?

3

Check Trade Spend (09) — Did promotional spend increase? Heavy discounting erodes margin.

4

Review Sales & Revenue waterfall (02) — Where is the leakage? COGS up? Trade discounts spike?

5

Root cause identified. Recommend action: adjust mix, reduce promos, or improve cost structure.

Scenario C: Planning Regional Expansion

1

Start at Geographic Performance (11) — Identify fast-growing regions and market penetration gaps. Which regions are underperforming?

2

Cross-reference with Channel Analytics (06) — Which sales channels are strong in target regions? Retail dominance or eCommerce growth?

3

Check Customer Intelligence (05) — Who are the major retailers/distributors in target regions? What's their growth trajectory?

4

Review Inventory (08) — Do we have sufficient supply to support expansion? What's our current weeks of supply?

5

Build expansion business case. Target region, entry channel, required inventory, expected ROI.

🌎
Generate Regional Expansion Package

Opens Geographic Performance, Channel & POS, Customer Intelligence, and Inventory in new tabs. Use filters on each dashboard to select year and region.

Dashboard Reference

Here are all 11 analytics dashboards in the xFalcon suite. Click any to open.

› 01 Executive Overview
Company-wide KPIs, year-over-year comparisons, and trending metrics. Your starting point for any business review.
Open Dashboard →
› 02 Sales & Revenue
Revenue trends, waterfall decomposition, sales by brand and channel, growth drivers, and competitive analysis.
Open Dashboard →
› 03 Product Performance
Sales volume, velocity, SKU performance, new product launches, and product-level growth trends.
Open Dashboard →
› 04 Product Margin
Gross margin by product, brand, and category. Profitability analysis, margin trends, and cost structure deep-dives.
Open Dashboard →
› 05 Customer Intelligence
Top customers by revenue, segments, cohort analysis, retention rates, churn trends, and customer value.
Open Dashboard →
› 06 Channel & POS Analytics
Revenue by sales channel (Grocery, Mass, Club, eCommerce). Point-of-sale trends, channel mix shifts, and growth rates.
Open Dashboard →
› 07 Shipments & Fill Rate
Order fulfillment rates, shipping timelines, on-time delivery, backlog analysis, and supply chain health metrics.
Open Dashboard →
› 08 Inventory
Stock levels by location and SKU, inventory turns, weeks of supply, out-of-stock incidents, and seasonal patterns.
Open Dashboard →
› 09 Trade Spend / Promo ROI
Promotional spending, incremental lift by campaign, ROI by brand and region, and effectiveness benchmarks.
Open Dashboard →
› 10 Consumer Panel
Shopper behavior, brand loyalty, purchase frequency, category trends, and consumer preference insights.
Open Dashboard →
› 11 Geographic Performance
Regional revenue, growth rates, market penetration, expansion opportunities, and geographic trends.
Open Dashboard →

Tips & Best Practices

Glossary

Quick reference for key analytics terms used across xFalcon dashboards.

AUR (Average Unit Revenue)
Revenue per unit sold. Higher AUR = selling more valuable products or achieving better pricing.
Basket Size
Average transaction value — how much a customer spends per shopping trip.
COGS (Cost of Goods Sold)
Direct costs to manufacture or acquire products (raw materials, labor, packaging). Higher COGS = lower profit.
Comp / Like-for-Like
Comparable sales — growth from the same stores/channels over the same period (year-over-year, same geography).
DTC (Direct-to-Consumer)
Sales directly to end consumers (e.g., own website), bypassing retail intermediaries.
Fill Rate
Percentage of customer orders successfully fulfilled. High fill rate = good inventory, low = stockouts.
Gross Profit
Revenue minus COGS. The profit left after paying for products (before operating expenses).
Gross Margin %
Gross Profit divided by Revenue (as a percentage). Shows profitability before overheads.
Incremental Lift
Additional sales generated by a promotion or campaign above baseline sales. Measures true promotional impact.
Inventory Turns
How many times inventory is sold and replenished in a period. Higher = more efficient, lower = slow-moving stock.
Net Revenue
Gross Revenue minus trade discounts, returns, and allowances. True revenue after all deductions.
OOS (Out of Stock)
When a product is unavailable to sell. High OOS rates indicate supply chain issues or demand forecasting problems.
POS (Point of Sale)
Retail checkout data. POS analytics show what actually sold at retail, by store and time.
Promo ROI
Return on Promotional Investment — incremental profit generated per dollar spent on promotions.
QoQ (Quarter over Quarter)
Growth comparing the same quarter in consecutive years (e.g., Q1 2025 vs Q1 2024).
SKU (Stock Keeping Unit)
Unique product identifier. One product variation (e.g., "Chicken 5kg Bag") = one SKU.
Trade Discount
Discount given to retailers or distributors. Higher trade discounts = higher wholesale costs, lower net revenue.
WOS (Weeks of Supply)
How many weeks of inventory on hand at current sales rate. Low WOS = risk of stockouts, high = excess inventory.
YoY (Year over Year)
Comparison of the same metric across the same period in consecutive years.
YTD (Year to Date)
Cumulative performance from the start of the fiscal year through the current period.

xFalcon AnalyticsPro Training Guide — Last Updated April 2026

← Back to Portal