tableau development

Managing Tableau workbooks manually is slow and error-prone. This skill automates the transition from a Tableau Data Source (.tds/.tdsx) to a fully functional workbook (.twbx). It scans your data source, identifies every available KPI, and generates a visual catalog where you can select the specific charts and trends you need. Once selected, it builds the entire workbook programmatically, ensuring every worksheet is correctly mapped to its dimensions and time grains.

What it does

• KPI cataloging scans .tds or .tdsx files to identify calculated fields and measures for reporting.
• Interactive selection generates HTML and Markdown checklists for picking KPIs, dimensions, and trend grains.
• Workbook generation builds a .twbx file containing formatted KPI cards, comparison bar charts, and trend lines.
• Automated validation checks generated XML against Tableau official schemas and cross-references fields before saving.
• Verification tool optionally triggers Tableau Desktop to confirm the file loads without internal errors.

How it works

1. Analyze run build_catalog.py on your data source to generate the selection interface and JSON fingerprint.
2. Select use the generated HTML page to tick boxes for specific KPIs and chart types, then save the selection.
3. Build run build_workbook.py passing the selection file to generate the final .twbx workbook.
4. Verify run the optional verification script to launch Tableau and check the application logs for loading errors.

Frameworks & tools

This skill requires Python 3.9+ with the lxml library. It interacts with Tableau .tds, .tdsx, and .twbx XML formats. Optional verification requires Tableau Desktop installed on the host machine.

Why this beats prompting it yourself

Prompting an LLM to write Tableau XML from scratch usually results in corrupted files that Tableau refuses to open. This tool uses a structured twb_builder library and official schemas to ensure the XML is syntactically perfect and follows Tableau internal mapping rules.

Use cases

• Rapidly prototyping a suite of executive dashboards from a new data source.
• Generating standardized KPI catalogs for business stakeholders to review.
• Mass-producing trend and comparison sheets for dozens of metrics simultaneously.
• Ensuring consistent chart types and naming conventions across enterprise workbooks.

Known limitations

Does not package external files for loose .tds connections unless using .tdsx. Cannot create the initial data source or joins; requires a finished source file as input.