Skip to main content

AI/BI for Data Analysts

This course teaches data analysts how to design, build, publish, and operate AI/BI Dashboards in Databricks. AI/BI Dashboards combine governed Unity Catalog data with interactive visualizations, filters, and Genie integration so business users can explore answers without writing code.


The course follows a single end-to-end build. You start with source tables in Unity Catalog and finish with a published, monitored multi-page dashboard. Along the way you learn how dashboards fit into the broader Databricks AI/BI product family and where Genie, datasets, visualizations, and filters each fit in the workflow.


The content covers:

• AI/BI Dashboard fundamentals and how they relate to Genie and the rest of the Databricks platform.

• Exploring source data in Unity Catalog and designing reusable dashboard datasets with SQL.

• Authoring visualizations (KPIs, trends, breakdowns) and laying out a clean multi-page dashboard.

• Using Genie Code to draft SQL, charts, and filters from natural language prompts.

• Adding filters to make dashboards interactive and responsive to viewer questions.

• Publishing, sharing, and managing permissions so the right people can view and edit the dashboard.

• Running the dashboard in production with scheduled refresh, caching, and usage monitoring.


Note: For SCORM lecture files, please ensure that you close the SCORM window after completing the content. Do not click the ‘Next Lesson’ button, as doing so may prevent the SCORM module from being marked as complete.


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

Skill Level
Associate
Duration
2h
Prerequisites

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

• Basic familiarity with the Databricks workspace. You can navigate the workspace UI, open and use notebooks, and attach a SQL warehouse or other compute resource.

• Basic familiarity with Unity Catalog. You understand the three-level namespace (catalog, schema, table) and can find a table in the catalog explorer.

• Working knowledge of SQL, including joins. You can read and write SELECT statements with WHERE, GROUP BY, and aggregates, and you can join two tables on a shared key.

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

Get Started with Databricks for Data Engineering - Mandarin Chinese

本课程介绍在 Databricks Data Intelligence Platform 上执行基本数据工程工作流所需的基础技能。您将浏览 workspace,使用 Unity Catalog,并学习数据工程师在 Databricks 上日常使用的核心构建模块。

本课程采用实践路径。您从熟悉 workspace 开始,然后针对每个主题完成配套的演示笔记本和实验室笔记本。演示部分将由讲师或引导式笔记本带您了解相关概念。

课程内容涵盖:

Databricks Data Intelligence Platform,以及 Databricks workspace、Unity Catalog 和笔记本之间的协作关系。

创建和管理 Delta Lake 表。

使用 INSERT、UPDATE 和 DELETE 修改数据。

浏览 UC 表的版本历史与 time travel 功能。

使用 LakeFlow Connect 的多种方式摄取数据:CTAS、上传 UI 以及 COPY INTO。

构建奖章架构管道,将数据依次经过铜牌、银牌和金牌层进行转换。

使用 LakeFlow Jobs 实现管道自动化。

(附加内容)使用 Apache Spark™ Declarative Pipelines 构建声明式管道。

完成本课程后,您将能够熟练创建 Delta Lake 表、向其中摄取数据、通过奖章管道对数据进行转换,并将整个流程自动化为定时任务。

注意:Databricks Academy 正在将 Databricks 环境中的课堂课程转为基于 notebook 的形式,并停止在讲座中使用幻灯片。您可以在 Vocareum 实验环境中访问课程 notebook。

Free
2h
instructor-led
Onboarding

Questions?

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