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

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#

VariableRequiredDescriptionNoneNoRuns 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