Analyze data and build interactive dashboards using Databricks SQL for business insights

This course teaches how to work with Databricks SQL, including querying datasets, creating visualizations, managing data assets with Unity Catalog, and building AI/BI dashboards for self-service analytics and reporting.

  • Why get trained: Learn how to use Databricks SQL, Unity Catalog, SQL Editor and AI/BI dashboards to query, analyze and visualize data for business insights.
  • Why it matters: Data analysis capabilities enable organizations to transform raw data into actionable insights that support faster and more informed decision-making.
  • Who should attend: Data analysts, BI professionals and SQL users responsible for querying, visualizing and delivering insights using the Databricks platform.

Build practical data analysis and dashboarding capabilities on Databricks to deliver actionable business insights with Trainocate. HRD Corp Claimable.

Overview

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.

Skills Covered

SQL Analytics on Databricks

  • Data Discovery
  • Data Importing
  • SQL Execution
  • Query Analysis

AI/BI for Data Analysts

  • Dashboards and Visualizations in Databricks
  • AI/BI Genie

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.

Target Audience

  • Everyone who is interested

Course Curriculum

Module 1: 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

Module 2: 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

Dates & Locations

Let’s make it work for you

Can’t find a date that fits? Need to train your whole team? Looking for a discount?
Speak to one of our learning experts today.

x Clear all selections

June 23, 2026 - June 24, 2026

Location: Online
Modal: VILT
Availability: TBC
Exam:
RM 900
RM 4500

July 22, 2026 - July 23, 2026

Location: Online
Modal: VILT
Availability: TBC
Exam:
RM 900
RM 4500
Trainocate exam and cert

Exam & Certification

Databricks Certified Data Analyst Associate.

The Databricks Certified Data Analyst Associate exam evaluates a candidate’s proficiency with the Databricks Data Intelligence Platform, assessing their ability to manage data with Unity Catalog – this includes discovering, querying, cleaning, and managing certified datasets, import data by utilizing various methods such as the UI, S3 ingestion, Delta Sharing for external systems, API-driven intake, Auto Loader, and the Marketplace feature, and excuting and optimizing queries for Data Analysis – including creating views, performing aggregate operations, combining tables with joins, filtering, sorting, and analyzing queries using auditing, history, logs, and Liquid clustering features.  

Additionally, the exam covers the basics of working with Dashboards and Visualisations, understanding the fundamentals of developing, sharing, and maintaining AI/BI Genie spaces within Databricks, data modelling with Databricks SQL, and securing data by adhering to best practices for data storage and management.

This exam covers:

  1. Understanding of Databricks Data Intelligence Platform – 11%
  2. Managing Data – 8%
  3. Importing Data – 5%
  4. Executing queries using Databricks SQL and Databricks SQL Warehouses – 20%
  5. Analyzing Queries – 15%
  6. Creating Dashboards and Visualizations in Databricks – 16%
  7. Developing, Sharing, and Maintaining AI/BI Genie spaces – 12%
  8. Data Modeling with Databricks SQL – 5%
  9. Securing Data – 8%

Training & Certification Guide

Frequently Asked Questions

DTB-DAD teaches you how to analyze data, build dashboards, and generate business insights using Databricks SQL and AI-powered BI tools.

The course focuses on SQL analytics, data visualization, dashboard creation, AI/BI Genie Spaces, Unity Catalog, and query optimization using the Databricks Data Intelligence Platform.

Key learning areas:

  • Databricks SQL analytics
  • Unity Catalog and data discovery
  • Query execution and optimization
  • AI/BI Dashboards
  • AI/BI Genie Spaces
  • Data visualization and reporting
  • Query Insights and performance optimization

Pro Tip: Focus on understanding business analytics workflows and data storytelling, not just SQL syntax.

DTB-DAD is designed for professionals working with analytics, reporting, dashboards, and business intelligence workflows.

The course is ideal for individuals who want to use Databricks for SQL-based analytics and AI-powered business intelligence solutions.

Best suited for:

  • Data Analysts
  • BI Analysts
  • Reporting Specialists
  • SQL Analysts
  • Analytics Engineers
  • Business Intelligence Professionals

Prerequisites include:

  • Working knowledge of SQL
  • Familiarity with data formats such as CSV and JSON
  • Basic understanding of dashboards and analytics concepts

Pro Tip: Strong SQL fundamentals significantly improve your ability to analyze and visualize data effectively in Databricks.

You will learn how to analyze, visualize, and manage enterprise data using Databricks SQL and AI-powered BI tools.

The course emphasizes practical analytics and self-service BI skills required for modern enterprise analytics environments.

Skills gained:

  • Querying and analyzing data with SQL
  • Creating dashboards and visualizations
  • Managing data using Unity Catalog
  • Optimizing SQL analytics workloads
  • Building AI/BI Genie Spaces
  • Sharing and maintaining BI assets

Pro Tip: Query optimization and dashboard usability are highly valuable because business stakeholders depend on fast and reliable analytics insights.

Yes, DTB-DAD prepares learners for the Databricks Certified Data Analyst Associate certification.

The certification validates the ability to use Databricks SQL for analytics, dashboards, visualization, AI/BI workflows, and enterprise data analysis.

Exam areas include:

  • Databricks SQL and SQL Warehouses
  • Data importing and management
  • Query optimization and Query Insights
  • Dashboards and visualizations
  • AI/BI Genie Spaces
  • Data modeling and governance

Pro Tip: Hands-on SQL and dashboard-building practice is essential because the certification emphasizes practical analytics workflows.

Databricks SQL is a cloud-native analytics service used for querying, visualizing, and analyzing large-scale enterprise data.

Organizations use Databricks SQL to perform scalable analytics and business intelligence operations on Lakehouse architectures using familiar SQL workflows.

Common Databricks SQL use cases include:

  • Business intelligence dashboards
  • Enterprise reporting
  • Data visualization
  • Ad hoc analytics
  • Self-service analytics

Pro Tip: SQL remains one of the most important analytics skills because it is widely used across data engineering, BI, AI, and analytics platforms.

DTB-DAD supports data analytics, BI, reporting, and modern analytics platform-related roles.

Organizations increasingly require professionals who can transform raw data into actionable business insights using scalable analytics platforms.

Relevant roles:

  • Data Analyst
  • BI Analyst
  • Reporting Analyst
  • Analytics Engineer
  • SQL Analyst
  • Business Intelligence Developer

Databricks analytics and Lakehouse expertise continue growing in demand as organizations modernize analytics and AI platforms.

Pro Tip: Combining Databricks analytics skills with AI, cloud, or data engineering expertise can significantly strengthen your long-term career opportunities.

Speak to a Training Consultant

All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631

Preferred mode of training
Checkboxes