skills.rest
TheGrowthExponent
TheGrowthExponentOFFICIAL
Explore all skills by this author →
WebsiteGitHub

Analytics & Dashboards Skills

Create Databricks dashboards and query Unity Catalog system tables for governance monitoring.

Updated Feb 23, 2026
Search Tags:#dashboards#cost-analysis#data-governance#databricks#unity-catalog#genie#system-tables
One-click install
npx skills add https://github.com/TheGrowthExponent/c7-databricks --skill analytics-dashboards-skills
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Analytics & Dashboards Skills
Source: https://github.com/TheGrowthExponent/c7-databricks/tree/main/docs/skills/analytics
Command: npx skills add https://github.com/TheGrowthExponent/c7-databricks --skill analytics-dashboards-skills

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill solves the challenge of building business intelligence dashboards and implementing data governance monitoring on Databricks by consolidating guidance for AI/BI Dashboards, Genie Spaces, and Unity Catalog system tables into a single reference, eliminating the need to search across disjointed official documentation.

Core Features & Use Cases

It provides step-by-step guidance for creating AI-powered dashboards with natural language querying via Genie, querying system tables for usage monitoring, audit logging, cost analysis, and data lineage tracking. Common use cases include building executive KPI dashboards, tracking query performance, auditing access to sensitive data, and attributing Databricks compute costs to internal teams.

Quick Start

Use this Skill to generate a SQL query that retrieves the top 10 most expensive Databricks SQL queries from the past 7 days using the system.query.history system table to identify cost optimization opportunities.

Frequently Asked Questions about Analytics & Dashboards Skills

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build Databricks BI dashboards and monitor data governance in one place?▼

You can build Databricks BI dashboards and monitor data governance by consolidating AI/BI Dashboards, Genie Spaces, and Unity Catalog system tables into a single workflow reference. This enables executive reporting, compliance auditing, and cost attribution.

What is the best way to query Databricks system tables for cost analysis and usage monitoring?▼

The best way to query system tables for cost analysis is to use SQL against Unity Catalog system tables. You can retrieve historical query data, such as the top 10 most expensive Databricks SQL queries from the past 7 days, to identify cost optimization opportunities.

How do I set up Genie Space integration for natural language querying in Databricks?▼

Genie Space integration enables AI-powered natural language querying directly within Databricks BI dashboards. Setting it up involves configuring Genie Spaces to translate user prompts into SQL queries, allowing non-technical users to track operational performance.

Can I use Unity Catalog system tables for compliance auditing and tracking data lineage?▼

Yes, Unity Catalog system tables can be queried for compliance auditing and tracking data lineage. This allows you to monitor access to sensitive data, audit user activity, and maintain oversight of your data governance workflows.

Does this approach to dashboard creation require prior knowledge of Databricks SQL?▼

While generating queries from system tables requires Databricks SQL knowledge, AI-powered Genie Spaces allow users to create executive KPI dashboards using natural language, lowering the barrier for operational performance tracking.

How do I attribute Databricks compute costs to internal teams using system tables?▼

You attribute Databricks compute costs to internal teams by querying system tables for historical usage and billing data. Analyzing the system.query.history table allows you to identify expensive queries and allocate costs accurately.

Related Skills

Explore More Data & Analytics Skills→
leary-pokenleary-poken
1

databricks-unity-catalog

Query Unity Catalog system tables, volumes, and lineage for governance.

Community
Advanced
lloydchanglloydchang
2

route-alerts

...

Community
Advanced
thbehthbeh

databricks-genie

Create and query Databricks Genie Spaces for natural language SQL exploration.

Community
Advanced
m19cm19c

databricks-aibi-dashboards

Automate creation, testing, and deployment of Databricks AI/BI dashboards.

Community
Advanced