Moderne BI Templates

Starter templates for building reports and dashboards from Moderne CLI telemetry data. Each template includes a SQL query, Jupyter notebook visualization, sample data, and documentation — ready to import into your BI tool of choice (Power BI, Tableau, Looker, Grafana, AWS QuickSight, or any tool that supports SQL).

Data Source

All templates work with the trace.csv produced by the Moderne CLI. The trace format is hierarchical — each CLI command in the workflow (sync, build, run, apply, commit, push) produces a trace that includes data from all prior stages. See the data dictionary for the full column reference.

Available Templates

Templates are sorted by trace hierarchy — earlier pipeline stages first, broadest applicability within each group second.

Template	Description	Minimum CLI Command
Build Success Trend	Monthly build health — success vs. failure rates over time	mod build
Build Tool Distribution	Build tool and version distribution across successfully built repositories	mod build
Recipe Run Trend	Monthly adoption trend — recipe runs, distinct recipes, and unique users over time	mod run
Top Recipes	Most-used recipes by run count, unique users, and repos searched	mod run
Dashboard KPIs	Executive-level snapshot — all-time totals and monthly trend	mod git commit
Commit Trend	Monthly trend correlating recipe execution with committed code impact	mod git commit
Commit Activity	Monthly committed output — successful commits, repos changed, and hours saved	mod git commit
Top Users	User engagement ranking by recipe runs and commits	mod git commit
Top Recipes with Commits	Recipes that produce real committed code changes	mod git commit
Security Recipe Run Trend	Monthly security remediation trend — committed fixes, repos fixed, and hours saved	mod git commit

Getting Started

1. Ensure your Moderne CLI is configured to publish trace data (see CLI telemetry docs)
2. Choose a template from the table above
3. Review the template's README for the report description, required fields, and example output
4. Run the Jupyter notebook with sample data to preview the visualization, or copy the SQL query into your BI tool or query engine (Athena, Trino, BigQuery, etc.)
5. Customize as needed for your organization

Repository Structure

moderne-bi-templates/
├── data-dictionary/
│   └── trace-csv.md              # Full trace.csv column reference
├── samples/                          # Sample CSV data for each template
│   ├── build-success-trend.csv
│   ├── build-tool-summary.csv
│   ├── build-tool-versions.csv
│   ├── commit-activity.csv
│   ├── commit-trend.csv
│   ├── dashboard-kpis-summary.csv
│   ├── dashboard-kpis-trend.csv
│   ├── recipe-run-trend.csv
│   ├── security-recipe-run-trend.csv
│   ├── top-recipes.csv
│   ├── top-recipes-with-commits.csv
│   └── top-users.csv
└── templates/
    ├── build-success-trend/
    ├── build-tool-distribution/
    ├── commit-activity/
    ├── commit-trend/
    ├── dashboard-kpis/
    ├── recipe-run-trend/
    ├── security-recipe-run-trend/
    ├── top-recipes/
    ├── top-recipes-with-commits/
    └── top-users/                    # Each contains README, SQL, notebook, and images/

Each template is a self-contained folder with a README, SQL query, Jupyter notebook visualization, and screenshot. Sample CSV data in the samples/ directory lets you run any notebook immediately.