AI/BI for Data Analysts

In this course, you’ll learn how to use the features Databricks provides for business intelligence needs: AI/BI Dashboards and AI/BI Genie. As a Databricks Data Analyst, you will be tasked with creating AI/BI Dashboards and AI/BI Genie Spaces within the platform, managing the access to these assets by stakeholders and necessary parties, and maintaining these assets as they are edited, refreshed, or decommissioned over the course of their lifespan. This course intends to instruct participants on how to design dashboards for business insights, share those with collaborators and stakeholders, and maintain those assets within the platform. Participants will also learn how to utilize AI/BI Genie Spaces to support self-service analytics through the creation and maintenance of these environments powered by the Databricks Data Intelligence Engine.

Skill Level

Associate

Duration

Prerequisites

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

A basic understanding of SQL for querying existing data tables in Databricks.
Prior experience or basic familiarity with the Databricks Workspace UI.
A basic understanding of the purpose and use of statistical analysis results.
Familiarity with the concepts around dashboards used for business intelligence.

Self-Paced

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

Customer registration Partner registration

See all our registration options

Registration options

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

Self-Paced

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

Instructor-Led

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

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

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

Generative AI Engineer

Generative AI Application Deployment and Monitoring

The course covers details about how to deploy, operationalize, and monitor generative AI applications. The course will help you gain skills in the deployment of generative AI applications using tools like Model Serving. It also covers how to operationalize generative AI applications following best practices and recommended architectures. Finally, the course discusses the idea of monitoring generative AI applications and their components using Lakehouse Monitoring.

Note: This is the fourth course in the 'Generative AI Engineering with Databricks’ series.

Free

Associate

Data Engineer

Data Ingestion with Lakeflow Connect

This course provides a comprehensive introduction to Lakeflow Connect as a scalable and simplified solution for ingesting data into Databricks from a variety of data sources. You will begin by exploring the different types of connectors within Lakeflow Connect (Standard and Managed), learn about various ingestion techniques, including batch, incremental batch, and streaming, and then review the key benefits of Delta tables and the Medallion architecture.

From there, you will gain practical skills to efficiently ingest data from cloud object storage using Lakeflow Connect Standard Connectors with methods such as CREATE TABLE AS (CTAS), COPY INTO, and Auto Loader, along with the benefits and considerations of each approach. You will then learn how to append metadata columns to your bronze level tables during ingestion into the Databricks data intelligence platform. This is followed by working with the rescued data column, which handles records that don’t match the schema of your bronze table, including strategies for managing this rescued data.

The course also introduces techniques for ingesting and flattening semi-structured JSON data, as well as enterprise-grade data ingestion using Lakeflow Connect Managed Connectors.

Finally, learners will explore alternative ingestion strategies, including MERGE INTO operations and leveraging the Databricks Marketplace, equipping you with foundational knowledge to support modern data engineering ingestion.

Free

Associate

Data Warehousing Practitioner

SQL Programming and Procedural Logic in Databricks

This course covers both the foundational SQL logic and advanced procedural logic in Databricks. Students will learn to leverage SQL constructs such as CTEs, temporary views, and user-defined functions, along with dynamic SQL and parameterized queries to enhance security and efficiency. The course also delves into procedural logic, where students will explore how to replicate traditional stored procedures using Lakeflow Jobs (Workflows), manage task dependencies, and automate workflows. Additionally, students will discover strategies for migrating legacy stored procedures to Databricks.

Free

Associate