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

Data Engineer

Build Data Pipelines with Apache Spark Declarative Pipelines - Mandarin Chinese

本课程向用户介绍使用 Databricks 中的 Apache Spark™ Declarative Pipelines (SDP) 构建数据管道所需的基本概念和技能,涵盖通过多个流式处理表和物化视图进行增量批处理或流式处理摄取与处理。本课程专为初次接触 Spark Declarative Pipelines 的数据工程师设计,全面介绍核心组件,包括增量数据处理、流式处理表、物化视图和临时视图,并重点说明其各自的用途与区别。

课程涵盖以下主题:

• 使用 Spark Declarative Pipelines 中的多文件编辑器,通过 SQL 开发和调试 ETL 管道(并提供 Python 代码示例)

• Spark Declarative Pipelines 如何通过管道图形跟踪管道中的数据依赖关系

• 配置管道 compute 资源、数据资产、触发器模式及其他高级选项

随后,课程介绍 Spark Declarative Pipelines 中的数据质量期望,引导用户将期望集成到管道中,以验证和强制执行数据完整性。学员还将浏览如何将管道投入生产,包括调度选项,以及启用管道事件日志记录以监控管道性能和健康状况。

最后,课程介绍如何在 Spark Declarative Pipelines 中使用 AUTO CDC INTO 语法实现变更数据捕获 (CDC),以管理缓慢变化维度(SCD Type 1 和 Type 2),帮助用户将 CDC 集成到自己的管道中。

注意:对于 SCORM 课程文件,请确保完成内容后关闭 SCORM 窗口。请勿点击‘Next Lesson’按钮,否则可能会导致 SCORM 模块无法标记为已完成。

Free
2h
Associate

Questions?

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