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

Data Ingestion with Lakeflow Connect - Mandarin Chinese

本课程全面介绍 LakeFlow Connect——一种可扩展且简便的解决方案,用于将来自各种来源的数据摄取到 Databricks 中。您将首先浏览 LakeFlow Connect 连接器的不同类型(标准型和托管型),并学习各种数据摄取技术,包括批处理摄取、增量批处理摄取和流式处理摄取。您还将了解使用 Delta 表和金银铜架构的主要优势。

接下来,您将培养使用 LakeFlow Connect 标准连接器从云对象存储摄取数据的实践技能。这包括使用 CREATE TABLE AS SELECT(CTAS)、COPY INTO 和 Auto Loader 等方法,并重点介绍每种方法的优势和注意事项。您还将学习如何在将数据摄取到 Databricks Data Intelligence Platform 的过程中,向铜层表追加元数据列。课程随后介绍如何使用救援数据列处理与表架构不匹配的记录,以及管理和分析此类数据的策略。您还将探索摄取和展平半结构化 JSON 数据的技术。

此后,您将探索如何使用 LakeFlow Connect 托管连接器执行企业级数据摄取,以引入来自数据库和软件即服务(SaaS)应用程序的数据。课程还将介绍 Partner Connect,作为将合作伙伴工具集成到摄取工作负载中的一种选项。

最后,课程以替代摄取策略作为总结,包括 MERGE INTO 运营以及利用 Databricks Marketplace,为您奠定坚实的基础,以支持现代数据工程用例。

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

Free
2h
Associate

Questions?

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