Board Dashboard Due Tomorrow

SprintNew

~3 min (example estimate)

From Salesforce → Tableau workbooks in minutes. Templates + .twbx publish for executive reporting.

Note: Templates mean assembly from pre-built viz types (bar, line, table), not free-form dashboard creation.

The Slack Message

CFO4:47 PM

Board meeting is Monday. I need pipeline by stage, revenue trend, and top 10 deals as Tableau charts on the Executive project. Can you have it by end of day tomorrow?

The Prompt

Three minutes later, this is in Claude Code.

We need Tableau workbooks for tomorrow's board meeting showing:
- Pipeline by stage (bar chart)
- Revenue trend last 6 months (line chart)
- Top 10 deals by amount (table)

Pull fresh data from Salesforce and publish to our 'Executive' project in Tableau Cloud.

Template-Based Viz Creation

Templates use canonical column naming (Dimension, Metric, Date) — we rename your CSV columns to match, then package as .twbx for reliable Tableau Cloud publishing. This approach eliminates brittle XML manipulation while enabling rapid dashboard assembly from pre-built viz types.

How It Works

Query Salesforce

Extract opportunity data with aggregations for each visualization.

Select Templates

Auto-match data to bar_chart, line_chart, and table templates.

Bind Data

Map CSV columns to canonical template roles. Create .twbx packages.

Publish to Tableau

Upload .twbx workbooks to Tableau Cloud Executive project.

After you paste this prompt, Claude Code:

"Board meeting needs 3 viz types. Let me query Salesforce for pipeline, revenue trend, and top deals."

Running

$ g-gremlin sfdc query "SELECT StageName, SUM(Amount) TotalAmount FROM Opportunity WHERE IsClosed=false GROUP BY StageName" --output pipeline.csv

✓ Query complete: 6 stages, 142 opportunities ✓ Written: pipeline.csv

Running

$ g-gremlin sfdc query "SELECT CALENDAR_MONTH(CloseDate) Month, SUM(Amount) Revenue FROM Opportunity WHERE IsClosed=true AND IsWon=true AND CloseDate=LAST_N_MONTHS:6 GROUP BY CALENDAR_MONTH(CloseDate)" --output revenue_trend.csv

✓ Query complete: 6 months of revenue data ✓ Written: revenue_trend.csv

Running

$ g-gremlin sfdc query "SELECT Name, Amount, StageName, CloseDate FROM Opportunity WHERE IsClosed=false ORDER BY Amount DESC LIMIT 10" --output top_deals.csv

✓ Query complete: Top 10 opportunities by amount ✓ Written: top_deals.csv

"Data ready. Now binding to templates: pipeline → bar_chart, revenue → line_chart, top deals → table."

Running

$ g-gremlin tableau template bind bar_chart pipeline.csv --map Dimension=StageName --map Metric=TotalAmount --output pipeline.twbx

[Template] Auto-mapped 2 fields (100% confidence) [Template] Creating canonical Hyper with renamed columns [Template] Packaging .twbx with data extract ✓ Created: pipeline.twbx (bar chart, 6 categories)

Running

$ g-gremlin tableau template bind line_chart revenue_trend.csv --map Date=Month --map Metric=Revenue --output revenue_trend.twbx

[Template] Auto-mapped 2 fields (95% confidence) [Template] Creating canonical Hyper with renamed columns [Template] Packaging .twbx with data extract ✓ Created: revenue_trend.twbx (line chart, 6 months)

Running

$ g-gremlin tableau template bind table top_deals.csv --map Dim1=Name --map Dim2=StageName --map Metric1=Amount --map Metric2=CloseDate --output top_deals.twbx

[Template] Auto-mapped 4 fields (100% confidence) [Template] Creating canonical Hyper with renamed columns [Template] Packaging .twbx with data extract ✓ Created: top_deals.twbx (table, 10 rows)

Running

$ g-gremlin tableau workbooks publish pipeline.twbx --project Executive --name "Pipeline by Stage"

[Tableau] Uploading packaged workbook (1.2 MB) ✓ Published: https://tableau.company.com/views/PipelineByStage Workbook ID: wb-abc123

Running

$ g-gremlin tableau workbooks publish revenue_trend.twbx --project Executive --name "Revenue Trend" && g-gremlin tableau workbooks publish top_deals.twbx --project Executive --name "Top 10 Deals"

[Tableau] Uploading packaged workbook (0.8 MB) ✓ Published: https://tableau.company.com/views/RevenueTrend Workbook ID: wb-def456 [Tableau] Uploading packaged workbook (0.3 MB) ✓ Published: https://tableau.company.com/views/Top10Deals Workbook ID: wb-ghi789

3 Tableau workbooks published to Executive project. Links sent to Slack.

Outputs Supported

Visualization Formats

Tableau Cloud — .twbx workbooks published directly
Google Sheets — CSV data exported to spreadsheets
CSV export — Raw data files for local analysis

Template Library

bar_chart — Category + metric (2-50 values)
line_chart — Date + metric (time series)
table — Multi-dim + multi-metric views

Results

Workbooks published

Salesforce queries

~3 min

Time estimate

~2 hours

Manual alternative

Cost: Depends on your Salesforce and Tableau Cloud API limits and data volume.

Full Documentation

Tableau Quickstart Guide

Setup, authentication, and your first workbook

CLI Command Reference

Complete reference for all Tableau commands

Try This Workflow

Ship board reporting in minutes, not hours.

Start Free Trial More Playbooks