Intelligent Data Warehousing and Data Analytics with Databricks SQL (February 2025)

Chapters: 0:00 Welcome & Workshop Overview 5:58 What the Databricks Platform Is 11:56 Cost, Peak Performance & AI Remediation 17:54 Serverless: Scaling Without Managing Compute 23:52 dbt, Standard SQL & Delta Live Tables 29:50 Sharing Results Beyond Databricks Users 35:48 Registering & Launching the Lab Environment 41:46 The SQL Editor's Focus Mode 47:44 Q&A: Large vs. Medium Clusters 53:42 Scaling & Query Bottlenecks 59:40 Creating a Volume 1:05:38 Managed vs. External Storage Locations 1:11:36 Building a Streaming Table 1:17:34 Creating the Bronze Table & Materialized Views 1:23:32 Scheduling Views Without Conflicts 1:29:30 Find and Replace in the SQL Editor 1:35:28 Q&A: Data Modeling Tools That Integrate 1:41:26 AI-Generated Column Descriptions 1:47:24 Identifying When to Change Warehouse Size 1:53:22 Selecting Compute & Creating a Dataset 1:59:20 Generating a Chart from Natural Language 2:05:18 Adding Filters to the Dashboard 2:11:16 Selecting Destination Fields 2:17:14 Sample Queries for Genie 2:23:12 Lab Access & Wrap-Up A hands-on Databricks workshop on intelligent data warehousing, analytics, and BI with Databricks SQL and AI/BI — from the SQL editor and warehouses to dashboards, semantics, and Genie. #databricks #databrickssql #dbsql #analytics #businessintelligence #dataintelligence #techtalk #workshop