
Load the New York Airbnb dataset in Databricks, generate SQL from plain English with Genie AI, and build four Power BI visuals guided by Copilot, adding a slicer and title.
Explore Databricks as a browser-based, cloud-based data workspace with notebooks and Genie AI to generate SQL queries from plain English, using a free edition and an Airbnb data set.
Learn to write basic SQL queries in a notebook, using select, from, where, and limit, switch the notebook to SQL, and run serverless compute to fetch and filter data.
Download Power BI Desktop, set up a direct Databricks connection, load live data from the Airbnb NYC dataset, and explore Copilot limitations within Power BI Desktop integration.
Learn to craft precise prompts for Copilot in Power BI Desktop or browser, specifying the tool, visual type, and fields to drive clear dashboard visuals.
Create an area chart in Power BI Desktop using the NYC data set. Set the X-axis to host since week starting and the Y-axis to count distinct host IDs.
Use Copilot to build a donut chart counting NYC dataset records by neighborhood, dragging neighborhood to the legend and using host name as the values to count (not distinct).
Create a horizontal bar chart in Power BI with Copilot to show average price by neighborhood from NYC dataset, and 100% stacked chart of listings by neighborhood and room type.
Are you curious about data analysis but not sure where to start, or whether it's even for you?
This free course is designed to answer that question. In just 60 minutes you will go from a blank screen to a working Power BI dashboard, using real Airbnb data and AI tools.
No SQL experience. No Power BI experience. No coding background required.
What you will build
You will load a real Airbnb dataset into Databricks, use Genie AI to generate SQL queries by asking questions in plain English, connect to Power BI Desktop, and use Copilot to guide you through building a fully formatted interactive dashboard — step by step.
What you will learn
How Databricks works and how data is organised in the cloud
The fundamentals of SQL: what it is, how it works, and how to read it
How to use Databricks Genie AI to write SQL without knowing how to code
How to write effective prompts to get useful answers from AI
How to build four Power BI visuals using Copilot as your guide
How to format and finalise a professional-looking dashboard
Who this course is for
This course is for anyone who is curious about data analysis and wants to see what it actually involves before committing to a longer course. If you have ever wondered whether data is something you could do - this is the place to find out.