lab playground

Azure Databricks Sales Data Query Playground

Beginner
2h 15m
305
3.5/5
Free playExplore without specific objectives or guided instruction.
Real-world experiencePractice in a live, pre-configured sandbox environment.
Lab 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
Lead Content Developer - Labs
Students
213,508
Labs
222
Courses
9
Learning paths
56

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