Skip to content

Board Examples

Advanced layout patterns and comprehensive examples.

Marketing Command Center

A complex dashboard combining multiple layout types, content, and charts:

source: examples_db
title: "Marketing Command Center"

queries:
  sales_summary:
    sql: |
      SELECT SUM(revenue) AS revenue, SUM(units_sold) AS units_sold, COUNT(DISTINCT category) AS category_count FROM ecommerce_orders
  sales_by_date:
    sql: |
      SELECT date, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY date ORDER BY date
  sales_by_category:
    sql: |
      SELECT category, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY category ORDER BY revenue DESC
  sales_by_product:
    sql: |
      SELECT product, category, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY product, category ORDER BY revenue DESC
  sales:
    sql: |
      SELECT * FROM ecommerce_orders

charts:
  spend:
    query: sales_summary
    type: kpi
    label: "Total Revenue"
    value: revenue
  clicks:
    query: sales_summary
    type: kpi
    label: "Total Units"
    value: units_sold
  roi:
    query: sales_summary
    type: kpi
    label: "Categories"
    value: category_count
  spend_trend:
    query: sales_by_date
    type: line
    title: "Revenue Over Time"
    x: date
    y: revenue
  channel_mix:
    query: sales_by_category
    type: bar
    title: "Category Mix"
    x: category
    y: revenue
  funnel:
    query: sales_by_product
    type: bar
    title: "Product Funnel"
    x: product
    y: units_sold
  conversion:
    query: sales
    type: table
    title: "Sales Table"
  campaigns:
    query: sales
    type: table
    title: "Campaign Table"
  creative1:
    query: sales_by_date
    type: bar
    x: date
    y: revenue
  creative2:
    query: sales_by_category
    type: bar
    x: category
    y: units_sold
  creative3:
    query: sales_by_product
    type: pie
    theta: revenue
    color: product

rows:
  # Section 1: Top Level KPIs
  - height: "120px"
    cols:
      - spend
      - clicks
      - roi

  # Section 2: Main Trends (Split 50/50)
  - cols:
      - spend_trend
      - channel_mix

  # Section 3: Funnel Analysis
  - rows:
      - text: |
          **Funnel Performance**
          Analyzing conversion rates by product
      - cols:
          - funnel
          - conversion

  # Section 4: Detailed Reports (Tabs)
  - tabs:
      items:
        - title: "Campaigns"
          rows:
            - campaigns

        - title: "Creatives"
          cols:
            - creative1
            - creative2
            - creative3
Marketing Command Center 8.7mn Total Revenue 290k Total Units 3 Categories Jan2024FebMarAprMayJun0   ​20   ​40   ​60   ​80KRevenue Over Time01mn2mn3mn4mnElectronicsAccessoriesToolsCategory Mix Funnel Performance Analyzing conversion rates by product 020,00040,00060,000Widget BWidget AGadget YGadget XWidget CTool ZGadget ZTool AProduct FunnelSales TableDateRegionProductCategoryRevenueUnits sold21 Feb 2024NorthWidget CElectronics2,150868 Mar 2024NorthTool ATools5951726 Apr 2024EastGadget XAccessories1,5984717 Jun 2024NorthWidget AElectronics1,5905319 Apr 2024EastWidget BElectronics8122921 Mar 2024WestGadget ZAccessories1,5405516 Jun 2024NorthWidget AElectronics1,5905318 Jun 2024WestWidget BElectronics2,2408014 Jun 2024WestGadget XAccessories1,394413 May 2024WestTool ZTools5121623 Feb 2024SouthGadget YAccessories1,3204426 Mar 2024SouthTool ZTools480151 Apr 2024SouthWidget BElectronics980357 May 2024WestWidget BElectronics2,324838 May 2024NorthWidget BElectronics1,148414 Mar 2024SouthGadget ZAccessories924334 Feb 2024NorthGadget YAccessories450154 Apr 2024WestGadget XAccessories5101521 Jun 2024EastWidget AElectronics600204 May 2024EastWidget AElectronics1,290431–20 / 6270‹12…314› Campaigns Creatives Campaigns Campaign TableDateRegionProductCategoryRevenueUnits sold21 Feb 2024NorthWidget CElectronics2,150868 Mar 2024NorthTool ATools5951726 Apr 2024EastGadget XAccessories1,5984717 Jun 2024NorthWidget AElectronics1,5905319 Apr 2024EastWidget BElectronics8122921 Mar 2024WestGadget ZAccessories1,5405516 Jun 2024NorthWidget AElectronics1,5905318 Jun 2024WestWidget BElectronics2,2408014 Jun 2024WestGadget XAccessories1,394413 May 2024WestTool ZTools5121623 Feb 2024SouthGadget YAccessories1,3204426 Mar 2024SouthTool ZTools480151 Apr 2024SouthWidget BElectronics980357 May 2024WestWidget BElectronics2,324838 May 2024NorthWidget BElectronics1,148414 Mar 2024SouthGadget ZAccessories924334 Feb 2024NorthGadget YAccessories450154 Apr 2024WestGadget XAccessories5101521 Jun 2024EastWidget AElectronics600204 May 2024EastWidget AElectronics1,290431–20 / 6270‹12…314› Data as of 14:30 UTC on 20 Oct 2026 made withdbt Charts
▶

Nested Grids

Create sophisticated layouts by combining multiple layout types:

source: examples_db
title: "Complex Dashboard"

queries:
  sales_summary:
    sql: |
      SELECT SUM(revenue) AS revenue, SUM(units_sold) AS units_sold, COUNT(DISTINCT category) AS category_count FROM ecommerce_orders
  sales_by_category:
    sql: |
      SELECT category, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY category ORDER BY revenue DESC
  sales_by_product:
    sql: |
      SELECT product, category, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY product, category ORDER BY revenue DESC
  sales_by_date_category:
    sql: |
      SELECT date, category, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY date, category ORDER BY date, category

charts:
  kpi1:
    query: sales_summary
    type: kpi
    label: "Revenue"
    value: revenue
  kpi2:
    query: sales_summary
    type: kpi
    label: "Units Sold"
    value: units_sold
  mini1:
    query: sales_by_category
    type: bar
    title: "Mini Chart 1"
    x: category
    y: revenue
  mini2:
    query: sales_by_product
    type: bar
    title: "Mini Chart 2"
    x: product
    y: units_sold
  main:
    query: sales_by_date_category
    type: line
    title: "Main Analysis"
    x: date
    y: revenue
    color: category

rows:
  - cols:
      - kpi1
      - kpi2
      - cols:
          - mini1
          - mini2
  - main
Complex Dashboard 8.7mn Revenue 290k Units Sold 01mn2mn3mn4mnElectronicsAccessoriesToolsMini Chart 1020,00040,00060,000Widget BWidget AGadget YGadget XWidget CTool ZGadget ZTool AMini Chart 2 1Jan'2481522295Feb1219264Mar1118251Apr81522296May1320273Jun101724010,00020,00030,00040,000Main AnalysisElectronicsAccessoriesTools Data as of 14:30 UTC on 20 Oct 2026 made withdbt Charts
▶

Document-Style Report

source: examples_db
title: "Analytical Report"

queries:
  sales_by_category:
    sql: |
      SELECT category, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY category ORDER BY revenue DESC
  sales_by_date_product:
    sql: |
      SELECT DATE_TRUNC('week', date) AS week, product, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY week, product ORDER BY week, product

charts:
  revenue_by_category:
    query: sales_by_category
    type: bar
    title: "Revenue by Category"
    x: category
    y: revenue
  trends:
    query: sales_by_date_product
    type: line
    title: "Trend Analysis"
    x: week
    y: revenue
    color: product

rows:
  - text: |
      # First-Half Performance Report
      The first half of 2024 showed **strong growth** across all key metrics.
      The following visualizations break down the performance by category.

  - cols:
      - revenue_by_category

      - text: |
          ### Key Insights
          - **Electronics**: Leading category, lifted by Widget B's climb
          - **Accessories**: Accelerating since the Gadget X launch in March
          - **Tools**: Steady, with Tool A easing off

  - trends
Analytical Report First-Half Performance Report The first half of 2024 showed strong growth across all key metrics. The following visualizations break down the performance by category. 01mn2mn3mn4mnElectronicsAccessoriesToolsRevenue by Category Key Insights Electronics: Leading category, lifted by Widget B's climb Accessories: Accelerating since the Gadget X launch in March Tools: Steady, with Tool A easing off Jan2024FebMarAprMayJun0   ​50   ​100   ​150KTrend AnalysisGadget XWidget BWidget AGadget YTool ZWidget CTool AGadget Z Data as of 14:30 UTC on 20 Oct 2026 made withdbt Charts
▶

Best Practices

Logical Grouping

Use boards to group related charts together. This improves readability and organization.

Layout Selection

Layout Best For
Rows Simple vertical flow, mobile, scrolling
Cols Side-by-side comparisons, sidebars
Grid Precise control, dense dashboards
Tabs Managing density, hiding content until needed

Modularity

Extract complex boards into separate files (starting with _ for partials) and include them by referencing their filename.

Performance

  • Keep individual boards focused
  • Use tabs to lazy-load complex sections
  • Split large dashboards into multiple files