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_week:
    sql: |
      SELECT DATE_TRUNC('week', date) AS week, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY week ORDER BY week
  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_week
    type: line
    title: "Revenue Over Time"
    x: week
    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_week
    type: bar
    x: week
    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.7m Total Revenue 290k Total Units 3 Categories Revenue Over Time300   ​350   ​400KJan2024FebMarAprMayJunCategory Mix01m2m3m4mElectronicsAccessoriesTools Funnel Performance Analyzing conversion rates by product Product Funnel020,00040,00060,000Widget BWidget AGadget YGadget XWidget CTool ZGadget ZTool ASales 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› CampaignsCreatives 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:58 UTC on 20 Nov 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_week_category:
    sql: |
      SELECT DATE_TRUNC('week', date) AS week, category, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY week, category ORDER BY week, 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_week_category
    type: line
    title: "Main Analysis"
    x: week
    y: revenue
    color: category

rows:
  - cols:
      - kpi1
      - kpi2
      - cols:
          - mini1
          - mini2
  - main
Complex Dashboard 8.7m Revenue 290k Units Sold Mini Chart 102m4mElectronicsAccessoriesToolsMini Chart 2060,000Widget BWidget AGadget YGadget XWidget CTool ZGadget ZTool A Main Analysis50   ​100   ​150   ​200KJan2024FebMarAprMayJun203.8K Electronics178.5K Accessories53.4K Tools Data as of 14:58 UTC on 20 Nov 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_week_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_week_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. Revenue by Category01m2m3m4mElectronicsAccessoriesTools 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 Trend Analysis0   ​50   ​100   ​150KJan2024FebMarAprMayJun131.8K Gadget X111.7K Widget B61.8K Widget A46.7K Gadget Y35.8K Tool Z30.4K Widget C17.6K Tool A2.1K Gadget Z Data as of 14:58 UTC on 20 Nov 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