Back to Cookbook

Dashboard Auditor

Find out which dashboards are actually earning their keep

Audits your BI platform's usage data to identify unused dashboards, duplicate reports, conflicting metrics, and orphaned data sources. Generates a cleanup plan with recommendations for archival, consolidation, and maintenance.

CommunitySubmitted by CommunityWork5 min setup

PROMPT

Create a skill called "Dashboard Auditor". Connect to my BI platform's API (I'll tell you if it's Tableau, Power BI, Looker, or Metabase) and audit all dashboards/reports. For each, collect: title, creator, creation date, last modified date, last viewed date, total views in last 30/60/90 days, unique viewers, data sources used, and metrics displayed. Then analyze: (1) Unused dashboards — not viewed in 90+ days. (2) Duplicates — dashboards using the same data sources with similar metrics. (3) Orphaned data sources — connections not used by any active dashboard. (4) Stale dashboards — data sources that haven't refreshed recently. Generate a cleanup report with recommended actions (archive, consolidate, refresh, keep) and estimated maintenance savings.

How It Works

Every BI deployment ends up with hundreds of dashboards, most of which nobody

uses. They clutter search results, confuse new analysts, and sometimes show

wrong numbers that nobody notices because nobody looks at them. This skill

audits the graveyard and helps you clean it up.

What You Get

  • Usage statistics for every dashboard (views, unique viewers, last accessed, filters used)
  • Unused dashboard list (not viewed in 30/60/90 days — configurable)
  • Duplicate detection (dashboards with overlapping data sources and metrics)
  • Orphaned data source identification
  • Owner mapping (who created each dashboard and when)
  • A prioritized cleanup plan: archive, consolidate, or keep

Setup Steps

  1. Ask your Claw to create a "Dashboard Auditor" skill with the prompt below
  2. Connect it to your BI platform's API (Tableau, Power BI, Looker, Metabase)
  3. Run the initial audit
  4. Review the cleanup plan and archive with confidence

Tips

  • Start with a "no delete" policy — archive first, delete after 90 days if nobody asks
  • The duplicate detection often reveals the source of conflicting metrics
  • Run monthly to prevent the graveyard from growing back
  • Share the usage report with dashboard creators — some will voluntarily clean up
Tags:#business-intelligence#dashboards#governance#cleanup