Data Analysis with Databricks Training in Ireland

Data Analysis with Databricks provides a comprehensive introduction to using Databricks SQL for modern data analytics. Participants learn how to ingest data, write SQL queries, create visualisations and dashboards, and configure alerts within the Databricks environment.

The course is also designed to support preparation for the Databricks Certified Data Analyst Associate certification exam.

The programme is delivered in two four-hour modules. The first focuses on SQL analytics on Databricks, while the second explores business intelligence capabilities through AI/BI Dashboards and AI/BI Genie.

Participants should have:

• Working knowledge of SQL for data analysis,
• Familiarity with data formats such as CSV, JSON, TXT, and Parquet,
• An understanding of how data is created, stored, and managed,
• Previous experience with or familiarity with the Databricks Workspace user interface,
• A basic understanding of how dashboards are used in business intelligence.

Participants who are not yet confident with SQL should have equivalent introductory or intermediate SQL querying knowledge before attending.

This course is particularly suitable for:

• Data Analysts and BI professionals who want to use Databricks for SQL-based analytics,
• Business professionals who need to turn raw data into actionable insights,
• Teams responsible for dashboards, reporting tools, and automated alerts,
• Organisations adopting Databricks to scale data intelligence and self-service analytics.

SQL Analytics on Databricks

By completing this section, participants will understand how to use Databricks effectively for data analytics, with a particular focus on Databricks SQL.

Participants will be able to:

• Locate and inspect relevant data for analysis,
• Analyse datasets for potential business use,
• Transform data into formats that provide meaningful business insights,
• Manage and manipulate data objects within the Databricks Data Intelligence Platform,
• Work with tools such as Notebooks, the SQL Editor, and Databricks SQL,
• Explain the importance of Unity Catalog in managing data assets and platform resources,
• Understand how Databricks supports performance optimisation,
• Use Query Insights to explore what happens behind the scenes when SQL analytics are executed.

AI/BI for Data Analysts

This section focuses on the Databricks features used to support business intelligence requirements, including AI/BI Dashboards and AI/BI Genie.

Participants will learn to:

• Create AI/BI Dashboards,
• Develop AI/BI Genie Spaces,
• Manage access to these assets for stakeholders and other users,
• Maintain dashboards and Genie Spaces as they are edited, refreshed, or retired,
• Design dashboards that communicate business insights,
• Share analytical assets with collaborators and stakeholders,
• Use AI/BI Genie Spaces to support self-service analytics through environments powered by the Databricks Data Intelligence Engine.

SQL Analytics on Databricks

Data Discovery

• Use Unity Catalog as a data discovery tool
• Understand data object ownership
• Locate and inspect datasets with Unity Catalog

Data Importing

• Ingest data into Databricks
• Upload data to Databricks through the user interface
• Explore and ingest data programmatically into Unity Catalog
• Import data into Databricks

SQL Execution

• Databricks SQL and Databricks SQL Warehouses
• Work with the Unified SQL Editor
• Manipulate and transform data using Databricks SQL
• Create views with Databricks SQL
• Manipulate and analyse a table

Query Analysis

• Databricks Photon and optimisation in Databricks
• Query Insights
• Best practices for SQL analytics

AI/BI for Data Analysts

Dashboards and Visualisations

• Dashboards and visualisations in Databricks
• AI/BI Dashboards
• Essential SQL for dashboard development
• Design datasets for dashboards
• Create visualisations and add summary statistics
• Use AI-enhanced features
• Apply filters
• Share dashboards with stakeholders and other users
• Manage dashboards in production
• Lab: Dashboard and visualisation activity

AI/BI Genie

• Introduction to AI/BI Genie
• Develop Genie Spaces
• Share Genie Spaces
• Lab: AI/BI Genie development activity