Skip to main content

Get Started with SQL Analytics and BI on Databricks

This course introduces the Databricks Data Intelligence Platform and the core skills a data analyst needs for day-to-day SQL analytics and BI work. You'll navigate the workspace and Unity Catalog, write SQL queries against governed Delta tables from a Serverless SQL Warehouse, use Genie Code to generate and debug SQL, work with Delta Lake (DML, version history, time travel, and restore), build and publish AI/BI Dashboards, and create Genie Spaces for conversational analytics. Each topic pairs a guided Demo notebook with a hands-on Lab.


Languages Available: English | 日本語 | Português BR | 한국어

Skill Level
Onboarding
Duration
2h
Prerequisites

The content was developed for participants with these skills/knowledge/abilities:  

• A basic understanding of data analytics principles and topics such as ANSI SQL, statistical analysis, and data preparation and presentation.

Self-Paced

Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos

See all our registration options

Registration options

Databricks has a delivery method for wherever you are on your learning journey

Runtime

Self-Paced

Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos

Register now

Instructors

Instructor-Led

Public and private courses taught by expert instructors across half-day to two-day courses

Register now

Learning

Blended Learning

Self-paced and weekly instructor-led sessions for every style of learner to optimize course completion and knowledge retention. Go to Subscriptions Catalog tab to purchase

Purchase now

Scale

Skills@Scale

Comprehensive training offering for large scale customers that includes learning elements for every style of learning. Inquire with your account executive for details

Upcoming Public Classes

AI/BI for Data Analysts - Mandarin Chinese

本课程面向数据分析师,讲授如何在 Databricks 中设计、构建、发布和运维 AI/BI Dashboards。AI/BI Dashboards 将受 Unity Catalog 治理的数据与交互式可视化、筛选器和 Genie 集成相结合,使业务用户无需编写代码即可探索答案。

本课程围绕一个端到端构建项目展开。您将从 Unity Catalog 中的源表开始,最终完成一个已发布、受监控的多页面仪表盘。在此过程中,您将了解仪表盘如何融入更广泛的 Databricks AI/BI 产品系列,以及 Genie、数据集、可视化和筛选器在工作流中的各自作用。

课程内容包括:

• AI/BI Dashboard 基础知识,以及它与 Genie 和 Databricks 平台其他部分的关系。

• 探索 Unity Catalog 中的源数据,并使用 SQL 设计可复用的仪表盘数据集。

• 创建可视化(KPI、趋势和细分),并设计简洁的多页面仪表盘布局。

• 使用 Genie Code,根据自然语言提示词起草 SQL、图表和筛选器。

• 添加筛选器,使仪表盘能够进行交互并响应查看者的问题。

• 发布和共享仪表盘并管理权限,确保适当的人员可以查看和编辑仪表盘。

• 通过定时刷新、缓存和使用情况监控,在生产环境中运行仪表盘。

注意:对于 SCORM 讲授文件,请确保在完成内容后关闭 SCORM 窗口。请勿点击“Next Lesson”按钮,否则可能导致 SCORM 模块无法被标记为已完成。

Languages Available: English | 日本語 | Português BR | 한국어 | Español | française

Free
2h
Associate

Questions?

If you have any questions, please refer to our Frequently Asked Questions page.