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 | 한국어
The content was developed for participants with these skills/knowledge/abilities:
• A working knowledge of using SQL for data analysis purposes.
• Be familiar with how data is created, stored, and managed.
• A basic understanding of statistical analysis.
• 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.
• 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
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 | Your Local Time | Language | Price |
|---|---|---|---|---|
Jun 09 - 10 | 01 PM - 05 PM (America/New_York) | - | English | $1000.00 |
Jun 23 - 24 | 11 AM - 03 PM (Asia/Singapore) | - | English | $1000.00 |
Jun 23 - 24 | 08 AM - 12 PM (America/Los_Angeles) | - | English | $1000.00 |
Jul 07 - 08 | 01 PM - 05 PM (America/Chicago) | - | English | $1000.00 |
Jul 15 - 16 | 01 PM - 05 PM (Europe/Paris) | - | English | $1000.00 |
Jul 15 - 16 | 08 AM - 12 PM (America/Los_Angeles) | - | English | $1000.00 |
Jul 22 - 23 | 11 AM - 03 PM (Asia/Singapore) | - | English | $1000.00 |
Jul 28 - 29 | 08 AM - 12 PM (America/Los_Angeles) | - | 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.
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
Register now
Instructor-Led
Public and private courses taught by expert instructors across half-day to two-day courses
Register now
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
