BytesAgain BI Dashboard Builder

Build BI dashboard specs from natural language, CSV headers, JSON metrics, or KPI lists. Outputs dashboard plans, SQL query templates, chart definitions, Apache Superset-compatible chart JSON snippets, KPI dictionaries, and dashboard QA reports.

Commands

generate

Create a dashboard plan with KPIs, charts, filters, and layout.

bash scripts/script.sh generate --goal "sales dashboard" --metrics "revenue,orders,aov" --dimensions "date,region,channel"

chart

Create a single chart spec for bar, line, pie, table, metric, or time-series visualization.

bash scripts/script.sh chart --type line --metric revenue --dimension date --title "Revenue Trend"

sql

Generate SQL templates for chart datasets and KPI cards.

bash scripts/script.sh sql --table orders --metrics "revenue,orders" --dimensions "date,region"

superset

Export Apache Superset chart JSON snippets from a chart spec.

bash scripts/script.sh superset --type bar --metric revenue --dimension region --datasource "orders"

kpi

Create KPI formulas, target hints, and owner notes for a BI dashboard.

bash scripts/script.sh kpi --metrics "revenue,orders,aov,conversion_rate" --dimensions "date,channel"

dataset

Create a dataset contract with columns, grain, freshness, and quality checks.

bash scripts/script.sh dataset --table orders --metrics "revenue,orders" --dimensions "date,channel,region"

qa

Audit a dashboard plan for business clarity, chart fit, and missing data definitions.

bash scripts/script.sh qa --goal "ecommerce growth dashboard" --metrics "revenue,orders,aov" --dimensions "date,channel"

validate

Check a dashboard spec for missing metrics, dimensions, filters, and chart titles.

bash scripts/script.sh validate dashboard.json

demo

Print a demo e-commerce BI dashboard with SQL and chart JSON.

bash scripts/script.sh demo

Input Formats

Natural language goal: --goal "growth dashboard"
Metric list: --metrics "revenue,orders,conversion_rate"
Dimension list: --dimensions "date,region,channel"
JSON spec file for validation

Output

Markdown dashboard plan
SQL query templates
JSON chart specs
Apache Superset chart JSON snippets

Setup

| Variable | Required | Description | |----------|----------|-------------| | None | No | Runs with bash and standard Unix tools only |

Notes

Use generic names for slugs and assets. Apache Superset output is supported as an export format, but this skill is a general BI dashboard builder.

Feedback

https://bytesagain.com/feedback/