lab playground

Azure Databricks Sales Data Query Playground

Beginner
Up to 2h 15m
324
3.5/5
Free playExplore without specific objectives or guided instruction.
Real-world experiencePractice in a live, pre-configured sandbox environment.

Description

This lab playground allows you to query a simulated product sales database. The data is stored in Azure Data Lake Storage Gen2 and queried using your language of choice in Azure Databricks notebooks.

The lab playground also prepares you to start the Translating Business Questions to Insights Final Exam. This exam requires the use of the playground to answer the questions in the exam.

Intended Audience

This lab is intended for:

  • Azure administrators
  • Cloud engineers and solutions architects
  • Data engineers
  • Anyone with a need to visualize and analyze data in Azure

Prerequisites

You should be familiar with:

Updates

March 1st, 2024 - Migrated to Azure Data Lake Storage Gen2

December 27th, 2022 - Updated screenshots & instructions to match UI

Nov 3rd, 2021 - Updated instruction to resolve the login issue with Azure Databricks

October 23rd, 2021 - Provide a workaround for an Azure Active Directory issue that initially prevents logging in to Databricks

About the author

Avatar
Logan Rakai, opens in a new tab
Technical Director, Labs
Students
223,162
Labs
223
Courses
9
Learning paths
58

Logan has been involved in software development and research since 2007 and has been in the cloud since 2012. He is an AWS Certified DevOps Engineer - Professional, AWS Certified Solutions Architect - Professional, Microsoft Certified Azure Solutions Architect Expert, MCSE: Cloud Platform and Infrastructure, Google Cloud Certified Associate Cloud Engineer, Certified Kubernetes Security Specialist (CKS), Certified Kubernetes Administrator (CKA), Certified Kubernetes Application Developer (CKAD), and Certified OpenStack Administrator (COA). He earned his Ph.D. studying design automation and enjoys all things tech.

LinkedIn, Twitter, GitHub

Covered topics

Lab steps

Creating the Azure Databricks Workspace
Uploading the Sales Data to Azure Data Lake Store
Importing the Sales Data into Databricks