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

This course teaches data analysts how to design, build, publish, and operate AI/BI Dashboards in Databricks. AI/BI Dashboards combine governed Unity Catalog data with interactive visualizations, filters, and Genie integration so business users can explore answers without writing code.

The course follows a single end-to-end build. You start with source tables in Unity Catalog and finish with a published, monitored multi-page dashboard. Along the way you learn how dashboards fit into the broader Databricks AI/BI product family and where Genie, datasets, visualizations, and filters each fit in the workflow.

The content covers:

• AI/BI Dashboard fundamentals and how they relate to Genie and the rest of the Databricks platform.

• Exploring source data in Unity Catalog and designing reusable dashboard datasets with SQL.

• Authoring visualizations (KPIs, trends, breakdowns) and laying out a clean multi-page dashboard.

• Using Genie Code to draft SQL, charts, and filters from natural language prompts.

• Adding filters to make dashboards interactive and responsive to viewer questions.

• Publishing, sharing, and managing permissions so the right people can view and edit the dashboard.

• Running the dashboard in production with scheduled refresh, caching, and usage monitoring.

Note: Databricks Academy is transitioning to a notebook-based format for classroom sessions within the Databricks environment, discontinuing the use of slide decks for lectures. You can access the lecture notebooks in the Vocareum lab environment.