Skip to main content

Menu

LEVEL 0
0/5 XP
HomeAboutTopicsPricingMy VaultStatsPractice TestsCertifications

Categories

🎓 Certifications
🤖 Artificial Intelligence
☁️ Cloud and Infrastructure
💾 Data and Databases
💼 Professional Skills
🎯 Programming and Development
🔒 Security and Networking
📚 Specialized Topics
CheatGrid
HomeAboutTopicsPricingMy VaultStatsPractice TestsCertifications
LVLEVEL 0
0/5 XP
GitHub
© 2026 CheatGrid™. All rights reserved.
Privacy PolicyTerms of UseAboutContact

Databricks Dashboards Cheat Sheet

Databricks Dashboards Cheat Sheet

Back to Business Intelligence
Updated 2026-05-26
Next Topic: DAX (Data Analysis Expressions) Cheat Sheet

Databricks Dashboards (formerly Lakeview) is an AI-assisted business intelligence platform deeply integrated into the Databricks Lakehouse, enabling interactive data visualization and reporting with enterprise-grade governance through Unity Catalog. Unlike traditional BI tools that operate as separate systems, Databricks Dashboards leverages native compute resources, inherits data permissions directly from Unity Catalog, and supports both AI-powered authoring with Genie Code agents and programmatic deployment through Declarative Automation Bundles (DABs). The key mental model: dashboards are governed analytical objects that sit alongside tables and views in Unity Catalog, connecting data modeling (datasets, local metric views, custom calculations, metric views) with visual storytelling—making them ideal for self-service analytics, embedded reporting, and CI/CD-managed dashboard workflows. Legacy DBSQL dashboards reached end of life on March 5, 2026 and are no longer available.

What This Cheat Sheet Covers

This topic spans 20 focused tables and 176 indexed concepts. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.

Table 1: Core Dashboard ComponentsTable 2: Visualization TypesTable 3: AI-Assisted AuthoringTable 4: Data Modeling and DatasetsTable 5: Custom Calculations and FunctionsTable 6: Interactive FilteringTable 7: Dashboard Publishing and SharingTable 8: Dashboard EmbeddingTable 9: Scheduling and AutomationTable 10: Multi-Page and Canvas LayoutTable 11: Themes and AppearanceTable 12: Unity Catalog GovernanceTable 13: CI/CD and AutomationTable 14: Dashboard API OperationsTable 15: Dashboard Performance and OptimizationTable 16: Advanced InteractivityTable 17: Legacy vs. AI/BI DashboardsTable 18: Common Use CasesTable 19: Troubleshooting and Best PracticesTable 20: Licensing and Access

Table 1: Core Dashboard Components

Every AI/BI dashboard is built around two workspaces: the Data tab where semantic objects and SQL datasets are defined, and the Canvas tab where visualizations are laid out. Understanding these building blocks is the foundation for everything else.

ComponentExampleDescription
Data tab
Define datasets from Unity Catalog tables/views
• Central workspace for defining datasets, custom calculations, and parameters
• all data modeling happens here before visualization.
Canvas tab
Drag-and-drop visualizations onto 12-column grid
• Layout editor where charts, filters, text widgets, and counters are arranged
• supports multi-page organization.
Dataset
SELECT * FROM catalog.schema.sales_data
A Unity Catalog table, view, or custom SQL query serving as a reusable data source for multiple visualizations.
Local metric view
Visual interface defines dimensions, measures, joins
• A dashboard-scoped semantic object created without publishing to Unity Catalog
• ideal for prototyping before promoting to global metric views.
Custom calculation
[Revenue] * 0.3 for calculated measure
• Enables new measures or dimensions defined in the dashboard layer without modifying underlying SQL
• supports aggregations, LOD expressions, and window functions.

More in Business Intelligence

  • Databricks AI-BI Genie Conversational Analytics Cheat Sheet
  • DAX (Data Analysis Expressions) Cheat Sheet
  • Agentic Analytics and AI Copilots in BI Cheat Sheet
  • Data Storytelling Cheat Sheet
  • Looker Studio Cheat Sheet
  • QlikView Cheat Sheet
View all 61 topics in Business Intelligence