AI/BI Genie + Databricks SQL Serverless + Unity Catalog Demo/Workshop

The aim of this repo is to create a hands-on AI/BI Genie + Databricks SQL Serverless Workshop.

Blog post:
https://caiomsouza.medium.com/ai-bi-genie-databricks-sql-serverless-unity-catalog-demo-workshop-bbfeb39ae0be

AI/BI Genie + Databricks SQL Serverless + Unity Catalog Demo (English Version)

Youtube Video: https://www.youtube.com/watch?v=oSAlOA4mrYo

AI/BI Genie + Databricks SQL Serverless + Unity Catalog Demo (Spanish Version)

Youtube Video: https://www.youtube.com/watch?v=fh4IUqYFVII

AI/BI Genie + Databricks SQL Serverless + Unity Catalog Demo (Portuguese Version)

Youtube Video: https://www.youtube.com/watch?v=7bBcJcHZ0eo

Products used

• Databricks SQL Serverless
• AI/BI Genie
• Notebooks
• Unity Catalog

Code / Labs

Notebook: https://github.com/drcaiomoreno/e2e-ai-bi-genai-db-sql-hands-on-workshop/blob/main/e2e-airbnb-madrid-analytics/notebooks/1_Load_Table_Listing.py

Questions to use

1. Show me the top super hosts by highest number of reviews
2. How many superhosts are there in each neighborhood?
3. I only have 120 euros, where can I stay?
4. Show me the top 10 super hosts by number of reviews
5. Show me all the properties where Fran Y Marta are the super host
6. Give me some ideas of questions that I could ask based in the data?
7. Number of listings per property type.
8. Average review scores by room type.
9. Listings availability trends over the next 30, 60, 90, and 365 days.
10. Distribution of listings based on the number of bedrooms or accommodates.
11. Seasonal trends in pricing or availability.

Introducing AI/BI: Intelligent Analytics for Real-World Data

https://www.databricks.com/blog/introducing-aibi-intelligent-analytics-real-world-data

Databricks AI/BI (Genie)

https://learn.microsoft.com/en-us/azure/databricks/ai-bi/
https://learn.microsoft.com/en-us/azure/databricks/genie/
https://docs.databricks.com/en/ai-bi/index.html

Youtube Video: https://www.youtube.com/watch?v=5ctfW6Ac0Ws

Enable serverless compute public preview

https://docs.databricks.com/en/admin/workspace-settings/serverless.html

How to embed AI/BI Dashboards into your websites and applications

https://www.databricks.com/blog/how-embed-aibi-dashboards-your-websites-and-applications

Dataset

https://www.airbnb.es/

Original data from:
https://insideairbnb.com/get-the-data/
https://creativecommons.org/licenses/by/4.0/

What does a world without Airbnb look like?

https://www.bbc.com/travel/article/20240701-what-does-a-world-without-airbnb-look-like