◎ Web Application • V2 Rebuilt from Ground Up

Spire Analytics

The next generation of Analytics for Spire — rebuilt with AI-powered report assistance, scheduled email delivery, 50+ templates, and a modern dashboard. Unlimited users included.

Purchase Price $3,500
Annual Assurance $700/year
AI Assistant (optional) $20/month
Unlimited users • All modules included
Spire Analytics v1.0.0
Dashboard
Report
Pivot
Templates
Financial
Admin
Tables
Sales (19)
Inventory (36)
Purchasing (10)
GL (22)
4
Saved Reports
0
Templates
0
Favorites
Saved Reports
Sum Inventory By Vendor
Inventory Summary By Vendor
Monthly Sales
Recent Queries
inventory, vendors, vendor_pricing
inventory, vendors, vendor_pricing
inventory, vendors, vendor_pricing

Everything You Need for Spire Reporting

A complete analytics platform with visual query building, pivot tables, charts, and AI assistance.

Visual Report Builder

Build reports visually with drag-and-drop joins, filters, sorting, and formula columns. No SQL required.

Pivot Tables

Drag fields to rows, columns, and values. Apply SUM, COUNT, AVG aggregations. Instant pivot analysis.

Charts & Visualization

Bar charts, line charts, and more. Light and dark mode support. Export-ready visualizations.

AI Assistant

Get AI-powered report reviews. Validates joins, filters, sorting, and formulas. Suggests improvements.

Scheduled Reports

Email reports daily, weekly, monthly, or custom cron. Multiple recipients supported.

50+ Templates

Pre-built reports for Executive, Sales, Inventory, Purchasing, GL & Financials, Production, Operations.

Modern, Intuitive Design

A clean interface that makes complex reporting accessible to everyone.

Report Builder Visual Query
Joins
Inventory.Preferred Vendor LEFT JOIN Vendors.Vendor No
Vendor Pricing.Inventory ID LEFT JOIN Inventory.ID
Filters
Onhand Qty (Inventory) equals 0 ×
Sort
Name (Vendors) ↑ ASC ×
Formulas
Extended Current Cost
{inventory.onhand_qty} * {inventory.current_cost}
Extended Vendor Cost
{inventory.onhand_qty} * {vendor_pricing.price}
AI Assistant
What's Working Well
  • Joins are correct — Inventory links to Vendors via preferred_vendor
  • Filter is sensible — Only showing items where onhand_qty > 0
  • Formula columns detected — f_ext_vendor_cost, f_ext_current_cost
Things to Consider
  • Multiple Vendor Pricing rows per item may cause duplicates
Ask about your data...
Pivot Table Drag & Drop
Part No Inventory
Description Inventory
Onhand Qty Inventory
Price Vendor Pricing
ROWS
Vendor ×
COLUMNS
Drag fields here
VALUES
Ext Current Cost SUM
Ext Average Cost SUM
FILTERS
Drag fields here
VendorExt Current CostExt Average Cost
AEROPARTS PLUS INC.1,6811,558
CANREP INC.5,2334,854
COILHOSE PNEUMATICS15,59214,183
COXREELS17,63817,635
HOLMBURY INC.193,917197,528
Charts Visualization
📊
📈
🔄
⬆️
X: Part No | Y: Extended Current Cost
■ Extended Current Cost
Schedule Reports Email Delivery
Schedule Report
Schedule Name
Inventory Summary By Vendor Schedule
Frequency
Daily at 8am Weekly (Mon 8am) Monthly (1st 8am) Every 6 hours Custom
Cron Expression
0 8 * * *
Recipients
email@example.com, another@example.com
Financial Reports Print, PDF, Excel
Financial Statements

Balance Sheet

Assets, Liabilities, and Equity as of a specific date

Profit & Loss

Revenue and expenses with YoY comparison

Trial Balance

Account balances with debit and credit columns

Receivables & Payables

Customer Statement

Transaction history with running balance

AR Aging

Outstanding balances by aging buckets

AP Aging

Outstanding vendor balances by aging buckets

50+ Pre-Built Report Templates

Get started instantly with templates for every department.

Company Revenue vs Costs

Side-by-side revenue and COGS from invoice history

ExecutivePivot

Customer Concentration

Revenue per customer ranked by total — spot dependency risk

ExecutivePivot

Product Profitability

Revenue, cost, gross profit, and margin per product

ExecutivePivot

Sales YoY Comparison

Compare year-to-date revenue against last year

ExecutivePivot

Revenue by Territory

Total revenue, order count, and average order size by territory

ExecutivePivot

Sales Order Backlog

All open and shipping sales orders with customer and aging

SalesPivot
+ 44 more templates across Executive, Sales, Inventory, Purchasing, GL & Financials, Production, Operations

Everything Included

One purchase price. Unlimited users. All modules.

Unlimited Users

No per-seat licensing

50+ Templates

Ready-to-use reports

Scheduled Email

Automated delivery

AI Assistant

$20/mo optional add-on

Ready to Upgrade Your Spire Reporting?

See how Spire Analytics can transform your data into actionable insights.

Request Demo