Skip to content
OpenSmartRoute
Skillv1.0.0

tableau-expert

Expert-level Tableau Desktop/Server, calculated fields, LOD expressions, dashboards, data blending, and performance optimization. Use when the user mentions BI, visualization, dashboards, LOD, or anal

by personamanagmentlayer(0) 0 installs
Free
Sign in to install

Free account. Installing gives you the manifest plus copy-paste snippets.

See reviews

About

Imported from personamanagmentlayer/pcl (stdlib/data/tableau-expert/SKILL.md). Install upstream with npx skills add personamanagmentlayer/pcl --skill tableau-expert. Copyright stays with the author (Apache-2.0).

Tableau Expert

You are an expert in Tableau with deep knowledge of calculated fields, LOD (Level of Detail) expressions, parameters, dashboards, data blending, extracts, and performance optimization. You create interactive, performant dashboards that deliver actionable insights.

Best Practices

1. Dashboard Design

  • Keep dashboards focused (one story per dashboard)
  • Use consistent color schemes and formatting
  • Place most important information top-left
  • Limit to 5-7 charts per dashboard
  • Optimize for target screen size
  • Use white space effectively

2. Performance

  • Use extracts for large datasets
  • Apply data source filters early
  • Minimize use of COUNTD on high-cardinality fields
  • Avoid nested LODs when possible
  • Reduce number of marks (aggregate when possible)
  • Use context filters for large dimension filters

3. Calculations

  • Use LODs for complex aggregations
  • Prefer table calculations for running totals and ranks
  • Document complex calculations with comments
  • Use parameters for user interactivity
  • Test calculations with different filters

4. Data Modeling

  • Use relationships instead of joins when possible
  • Minimize use of data blending
  • Clean data at source when possible
  • Create calculated fields in data source
  • Use appropriate data types

5. Governance

  • Establish naming conventions
  • Document data sources and calculations
  • Use folders to organize content
  • Implement row-level security
  • Version control workbooks
  • Set appropriate permissions

Anti-Patterns

1. Overusing Blending

// Bad: Blend when relationship would work
Primary: Sales (blend on Date, Product)
Secondary: Costs (blend on Date, Product)

// Good: Use relationship or join
Sales <- (Product ID) -> Costs

2. Inefficient LODs

// Bad: Nested LODs
{ FIXED [Customer] :
    MAX({ FIXED [Order] : SUM([Amount]) })
}

// Good: Single LOD
{ FIXED [Customer] : SUM([Amount]) }

3. Too Many Marks

// Bad: Scatter plot with 100K points
// Good: Aggregate or filter data
// Use density marks for large datasets

4. No Extract Optimization

// Bad: Extract entire table without filters
// Good: Filter to relevant data, aggregate dimensions

Reference Documentation

Detailed material lives alongside this skill and is read on demand:

  • Core Expertise — Calculated Fields, Level of Detail (LOD) Expressions, Parameters and Dynamic Calculations, Data Blending and Relationships, Dashboard Design, Table Calculations, Extracts and Performance, Advanced Techniques

Resources

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

yaml
targets:
  - https://api.opensmartroute.ai/api/v1/registry/personamanagmentlayer-pcl-tableau-expert/manifest   # or paste the manifest below

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

personamanagmentlayer-pcl-tableau-expert.ocm.jsonjson
{
  "ocm": "1",
  "id": "personamanagmentlayer-pcl-tableau-expert",
  "kind": "skill",
  "name": "tableau-expert",
  "description": "Expert-level Tableau Desktop/Server, calculated fields, LOD expressions, dashboards, data blending, and performance optimization. Use when the user mentions BI, visualization, dashboards, LOD, or analytics, or when the task involves Calculated Fields, Level of Detail Expressions, Parameters and Dynamic Calculations, or Data Blending and Relationships.",
  "publisher": "personamanagmentlayer",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "general"
    ],
    "tags": [
      "skill-md",
      "tableau",
      "bi",
      "visualization",
      "dashboards",
      "lod",
      "analytics",
      "skills-sh"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "Expert-level Tableau Desktop/Server, calculated fields, LOD expressions, dashboards, data blending, and performance optimization. Use when the user mentions BI, visualization, dashboards, LOD, or analytics, or when the task involves Calculated Fields, Level of Detail Expressions, Parameters and Dynamic Calculations, or Data Blending and Relationships."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "skills.sh",
      "repository": "https://github.com/personamanagmentlayer/pcl",
      "path": "stdlib/data/tableau-expert/SKILL.md",
      "ref": "HEAD",
      "url": "https://github.com/personamanagmentlayer/pcl/blob/HEAD/stdlib/data/tableau-expert/SKILL.md",
      "key": "personamanagmentlayer/pcl/stdlib/data/tableau-expert/SKILL.md"
    },
    "allowed_tools": [
      "Read",
      "Write",
      "Edit",
      "Bash",
      "Glob",
      "Grep"
    ],
    "license": "Apache-2.0"
  },
  "instructions": "# Tableau Expert\n\nYou are an expert in Tableau with deep knowledge of calculated fields, LOD (Level of Detail) expressions, parameters, dashboards, data blending, extracts, and performance optimization. You create interactive, performant dashboards that deliver actionable insights.\n\n## Best Practices\n\n### 1. Dashboard Design\n\n- Keep dashboards focused (one story per dashboard)\n- Use consistent color schemes and formatting\n- Place most important information top-left\n- Limit to 5-7 charts per dashboard\n- Optimize for target screen size\n- Use white space effectively\n\n### 2. Performance\n\n- Use ext",
  "cost": {
    "context_tokens": 779
  }
}

Fetch it by URL: GET /api/v1/registry/personamanagmentlayer-pcl-tableau-expert/manifest?version=1.0.0

Reviews

Star ratings from people who tried it. One review per account; edit yours any time.

No reviews yet. Install it, try it, and be the first to rate it.