In this project, you will work like a real data analyst using Databricks.

You already uploaded the data in the previous homework.

Now your job is to explore the data, turn insights into dashboards, and finally let users talk to the data using AI.

We will move step by step, just like in a real company.

<aside> 💡

Prerequisite

Make sure you have completed the homework and the data is already loaded into Databricks.→ Homework If you have any questions, you can join our discord community → Discord

</aside>

🔍 Phase 1: Data Exploration (SQL Editor)

<aside>

Goal: Understand the dataset and get comfortable using the Databricks SQL Editor.

</aside>

• [ ] Open Databricks → SQL Editor
• [ ] Select the correct catalog and schema
• [ ] Run and save queries for:
  • [ ] List all tables SHOW TABLES;
  • [ ] Inspect table structure DESCRIBE TABLE dim_customers;
  • [ ] List unique customer countries
  • [ ] List product categories, subcategories, and products
  • [ ] Calculate:
  • [ ] Total sales, Total customers, Total products, Total orders
  • [ ] Sales by product, Sales by category, Orders over time

<aside>

Result: You know how to browse the structure of your data in catalog and how to write query inside databricks SQL Editor

</aside>

📊 Phase 2: Turn Queries into Visuals (Databricks Dashboards)

<aside>

Goal: Start visualizing what you discovered using Databricks dashboards.

</aside>

Open saved queries in SQL Editor

• [ ] Open your saved SQL queries, Click on visualization
• [ ] Try different chart types: Line charts, Bar charts, Pie charts