Bytesagain Bi Dashboard Builder

Build BI dashboard specs, chart plans, SQL queries, and Apache Superset chart JSON. Use when creating dashboards, BI reports, KPI charts, or visualization layouts.

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

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

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

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

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

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

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

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

bash scripts/script.sh validate dashboard.json

demo

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

bash

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/

Powered by BytesAgain | bytesagain.com