Templates

Tags intermediate reference visualization

BenchBox templates bundle predefined chart sets and export formats for common content workflows. Instead of manually selecting chart types, choose a template that matches your content goal.

Template Overview

Template

Charts Generated

Export Formats

Best For

flagship

4 charts

PNG, SVG, HTML

Multi-platform comparisons, flagship blog posts

head_to_head

3 charts

PNG, HTML

Two-platform shootouts

trends

2 charts

PNG, SVG, HTML

Performance evolution over time

cost_optimization

2 charts

PNG, SVG, HTML

ROI and cost analysis

default

1-3 charts

PNG, HTML

Quick single-run summaries

Flagship Template

Use case: Comprehensive multi-platform comparisons for flagship blog posts and detailed analysis.

Generates:

  1. Performance Bar Chart (platform comparison)

  2. Query Variance Heatmap (per-query breakdown)

  3. Cost-Performance Scatter (if cost data available)

  4. Distribution Box Plot (latency consistency)

See Chart Types for examples of each chart generated by this template.

Command:

benchbox visualize results/*.json --template flagship --output charts/flagship

Ideal for:

  • “State of the Data Warehouse 2025” style posts

  • 4+ platform comparison articles

  • Detailed benchmark reports

Head-to-Head Template

Use case: Direct two-platform comparisons for shootout-style content.

Generates:

  1. Performance Bar Chart (side-by-side comparison)

  2. Distribution Box Plot (consistency comparison)

  3. Query Variance Heatmap (per-query winners)

See Chart Types for examples of each chart generated by this template.

Command:

benchbox visualize duckdb-results.json snowflake-results.json --template head_to_head

Ideal for:

  • “Platform A vs Platform B” blog posts

  • Migration decision support

  • Quick competitive analysis

Cost Optimization Template

Use case: Price/performance analysis for cloud platform cost optimization.

Generates:

  1. Cost-Performance Scatter Plot (with Pareto frontier)

  2. Performance Bar Chart (raw performance comparison)

See Chart Types for examples of each chart generated by this template.

Command:

benchbox visualize cloud-results/*.json --template cost_optimization --format png,svg

Ideal for:

  • Cloud cost comparison articles

  • CFO-friendly ROI presentations

  • Platform selection recommendations

Default Template

Use case: Quick visualization of a single benchmark run without specifying chart types.

Generates (varies by data):

  • Performance Bar Chart (always)

  • Distribution Box Plot (if query timings available)

  • Query Variance Heatmap (if 2+ platforms)

Command:

benchbox visualize  # Uses latest result automatically

Ideal for:

  • Quick result inspection

  • Development/debugging

  • Single-platform analysis

Template Customization

Templates set defaults but can be overridden:

# Use flagship template but only PNG format
benchbox visualize results/*.json --template flagship --format png

# Use trends template but add cost scatter
benchbox visualize results/*.json --template trends --chart-type time_series,cost_scatter

# Use head_to_head but with dark theme
benchbox visualize a.json b.json --template head_to_head --theme dark

Output Structure

Each template creates a consistent output structure:

charts/
├── tpch_duckdb-snowflake_performance.png
├── tpch_duckdb-snowflake_performance.html
├── tpch_duckdb-snowflake_distribution.png
├── tpch_duckdb-snowflake_distribution.html
├── tpch_duckdb-snowflake_query-variance.png
├── tpch_duckdb-snowflake_query-variance.html
└── ...

File names encode: {benchmark}_{platforms}_{chart-type}.{format}

Metadata Embedding

All exports include embedded metadata for reproducibility:

  • Benchmark name and scale factor

  • Platform names and versions

  • BenchBox version

  • Generation timestamp

  • Source result file paths

Access metadata in HTML exports via browser console or in PNG/SVG EXIF data.