Skip to main content

Data Analysis with Databricks

This course provides a comprehensive introduction to Databricks SQL. Learners will ingest data, write queries, produce visualizations and dashboards, and configure alerts. This course will prepare you to take the Databricks Certified Data Analyst Associate exam.

This course consists of two four-hour modules. 

SQL Analytics on Databricks

In this course, you'll learn how to effectively use Databricks for data analytics, with a specific focus on Databricks SQL. As a Databricks Data Analyst, your responsibilities will include finding relevant data, analyzing it for potential applications, and transforming it into formats that provide valuable business insights. 

You will also understand your role in managing data objects and how to manipulate them within the Databricks Data Intelligence Platform, using tools such as Notebooks, the SQL Editor, and Databricks SQL. 

Additionally, you will learn about the importance of Unity Catalog in managing data assets and the overall platform. Finally, the course will provide an overview of how Databricks facilitates performance optimization and teach you how to access Query Insights to understand the processes occurring behind the scenes when executing SQL analytics on Databricks.

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.

Languages Available: English | 日本語 | Português BR | 한국어
Skill Level
Associate
Duration
8h
Prerequisites
  • A working knowledge of using SQL for data analysis purposes. 
  • Be familiar with how data is created, stored, and managed.
  • A basic understanding of the purpose and use of statistical analysis results
  • Understand the structure and defining characteristics of specific data formats such as CSV, JSON, TXT, and Parquet.
  • Be familiar with the user interface of the Databricks Data Intelligence Platform.
  • Prior experience or basic familiarity with the Databricks Workspace UI.
  • Familiarity with the concepts around dashboards used for business intelligence.

Outline

SQL Analytics on Databricks


Data Discovery

Using Unity Catalog as a Data Discovery Tool

Understanding Data Object Ownership

Use Unity Catalog to Locate and Inspect Datasets


Data Importing

Ingesting Data into Databricks

Uploading Data to Databricks Using the UI

Programmatic Exploration and Data Ingestion to Unity Catalog

Import Data into Databricks


SQL Execution

Databricks SQL and Databricks SQL Warehouses

The Unified SQL Editor

Manipulate and Transform Data with Databricks SQL

Creating Views with Databricks SQL

Manipulate and Analyze a Table


Query Analysis

Databricks Photon and Optimization in Databricks

Query Insights

Best Practices for SQL Analytics


AI/BI for Data Analysts


Dashboards and Visualizations in Databricks

AI/BI Dashboards

Just enough SQL

Designing Datasets for Dashboards

Creating Visualizations and adding Summary Statistics to Dashboards

AI Enhanced Features

Filters

Sharing Dashboards with Stakeholders and Others

Managing Dashboards in Production

Dashboard and Visualization Lab Activity


AI/BI Genie

AI/BI Genie

Developing Genie Spaces

Sharing Genie Spaces

AI/BI Genie Development Activity Lab

Upcoming Public Classes

Date
Time
Language
Price
Jun 02 - 03
02 PM - 06 PM (America/New_York)
English
$1000.00
Jun 16 - 17
11 AM - 03 PM (Asia/Singapore)
English
$1000.00
Jun 20
09 AM - 05 PM (Europe/London)
English
$1000.00
Jun 20
09 AM - 05 PM (America/Los_Angeles)
English
$1000.00
Jun 27
09 AM - 05 PM (Europe/London)
English
$1000.00
Jul 01
09 AM - 05 PM (America/New_York)
English
$1000.00
Jul 07
09 AM - 05 PM (Europe/London)
English
$1000.00
Jul 09
09 AM - 05 PM (Australia/Sydney)
English
$1000.00
Jul 10 - 11
02 PM - 06 PM (America/New_York)
English
$1000.00
Jul 14 - 15
11 AM - 03 PM (Asia/Singapore)
English
$1000.00
Jul 28 - 29
02 PM - 06 PM (Europe/Paris)
English
$1000.00
Aug 18
09 AM - 05 PM (Australia/Sydney)
English
$1000.00
Aug 18
09 AM - 05 PM (Europe/London)
English
$1000.00
Aug 18
09 AM - 05 PM (America/Los_Angeles)
English
$1000.00
Aug 25 - 26
11 AM - 03 PM (Asia/Singapore)
English
$1000.00
Aug 25 - 26
02 PM - 06 PM (Europe/Paris)
English
$1000.00
Aug 25 - 26
02 PM - 06 PM (America/New_York)
English
$1000.00
Sep 08
09 AM - 05 PM (Europe/London)
English
$1000.00
Sep 15
09 AM - 05 PM (Australia/Sydney)
English
$1000.00
Sep 15
09 AM - 05 PM (America/Los_Angeles)
English
$1000.00
Sep 22 - 23
02 PM - 06 PM (Europe/Paris)
English
$1000.00
Sep 29 - 30
11 AM - 03 PM (Asia/Singapore)
English
$1000.00
Sep 29 - 30
02 PM - 06 PM (America/New_York)
English
$1000.00
Oct 06
09 AM - 05 PM (Europe/London)
English
$1000.00
Oct 06
09 AM - 05 PM (America/Los_Angeles)
English
$1000.00
Oct 13
09 AM - 05 PM (Australia/Sydney)
English
$1000.00
Oct 20 - 21
11 AM - 03 PM (Asia/Singapore)
English
$1000.00
Oct 20 - 21
02 PM - 06 PM (Europe/Paris)
English
$1000.00
Oct 20 - 21
02 PM - 06 PM (America/New_York)
English
$1000.00

Public Class Registration

If your company has purchased success credits or has a learning subscription, please fill out the Training Request form. Otherwise, you can register below.

Private Class Request

If your company is interested in private training, please submit a request.

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

Questions?

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