Executive Dashboard Generator
Transform raw data from CSVs, Google Sheets, or databases into executive-ready reports with visualizations, key metrics, trend analysis, and actionable recommendations. Creates data-driven narratives for leadership. Use when users need to turn spreadsheets into executive summaries or board reports.
What it does
# Executive Dashboard Generator Turn raw data into executive-ready insights with visualizations and recommendations. ## Contents - `references/analysis-coverage.md` — supported data inputs and analysis types per domain (financial, sales/marketing, operations, customer). - `references/output-template.md` — the full Markdown dashboard template to populate. - `references/best-practices.md` — reporting principles, visualization do/don't, trigger phrases, example request. ## Workflow 1. Clarify business context and collect the data sources (files, Sheets links, query output). See `references/analysis-coverage.md` for accepted inputs and the analysis types to run per domain. 2. Discover the data: identify structure, date ranges, granularity, key metrics and dimensions, and any data quality issues. Map relationships across datasets. 3. Analyze: calculate period-over-period changes, identify trends and patterns, flag outliers and anomalies, run cohort analysis, and set benchmarks and targets. 4. Generate insights: synthesize findings into key messages, prioritize by business impact, connect each metric to a business outcome, and develop concrete action recommendations and risk/opportunity flags. 5. Choose visualizations: select chart types built for executive readability and maintain a clear visual hierarchy. See `references/best-practices.md` for the visualization do/don't list. 6. Assemble the report using the structure in `references/output-template.md`. Replace every placeholder with real values; never ship a template with bracketed placeholders left in. 7. Prioritize recommendations and include scenario planning and a risk assessment, then deliver the dashboard. Lead with insights over raw numbers, and answer "So what?" and "What should we do?" Apply the reporting principles in `references/best-practices.md`.
More strategy & finance skills
Bi Measure Builder
Writes, explains, debugs, and optimizes BI calculations - Power BI / Fabric DAX measures and calculated columns, Tableau calculated fields (FIXED/INCLUDE/EXCLUDE LOD expressions, table calculations), and Looker LookML measures, dimensions, and derived tables. Use it whenever the request involves DAX, CALCULATE, a Power BI measure, a Tableau calc or LOD, LookML, or a business metric such as YoY, YTD, rolling 12 months, running total, percent of total, distinct customers, ranking, new vs returning customers, closing balances, or basket analysis. Use it especially when someone says a measure "shows the wrong total", "is blank", "ignores my slicer/filter", "repeats the same value on every row", or "is slow" - those are filter context, context transition, LOD order-of-operations, or fanout bugs this skill is built to diagnose. Produces the formula, the context it evaluates in, and a hand-checkable test with expected numbers.
Board Deck Generator
Generates professional board meeting presentation content (board-deck.md) with executive summary, financials, product updates, GTM metrics, team/hiring, strategic decisions, and appendix. Supports early-stage, growth-stage, and pre-IPO formats. Use when preparing board meeting materials, quarterly board updates, or investor presentations.
Bookkeeping Close
Runs small and midsize business bookkeeping operations - categorizes bank and card transactions to a chart of accounts, reconciles a bank or card statement against the ledger, works a month-end close checklist, and produces a close package for the accountant. Works from QuickBooks Online, Xero, bank CSV/OFX, or Mercury exports, and from the Xero, QuickBooks, or Mercury connectors when present. Use it whenever the user says "reconcile", "bank rec", "categorize transactions", "month end close", "close the books", "books don't match the bank", "reconciliation is off by", "uncategorized expenses", or shares a QuickBooks or Xero export or a bank statement CSV, even if they do not name the task. Never plugs a difference; every unreconciled dollar is explained or listed.
Budget Optimizer
Analyze spending patterns and find savings. 50/30/20 rule, subscription audit, debt payoff strategies, emergency fund roadmap.