What's in This Demo's Database

This demo includes the following Olist tables:

• Orders — order status, purchase dates, delivery dates (actual and estimated)

• Customers — location data by city, state, and postcode

• Order Items — product and seller IDs, price, shipping cost, and dispatch deadlines

• Payments — payment type (credit card, etc.), number of instalments, and total amount paid

• Reviews — ratings (1–5), review titles, comments, and submission dates

• Products — category, description length, photo count, weight, and dimensions

• Sellers — seller location by city, state, and postcode

• Geolocation — coordinates mapped to postcodes, cities, and states

• Product Category Translations — category names from Portuguese to English

Start With These Suggested Prompts

These prompts are built into the Database Assistant as one-click suggestions. Select any of them to get started straight away.

Explore the Database Structure

"Show me all available tables in the database and describe their structure, including column names and data types."

Monthly Sales Trend

"Show monthly sales for 2017 and 2018 as a line chart."

Delivery vs. Customer Satisfaction

"Show the relationship between delivery delay and customer rating."

Orders by State

"Show the top 10 Brazilian states by number of orders."

Want to Explore Further?

Try these multi-step analyses to see how the Database Assistant can guide you through a full investigation — one question at a time.

Delivery Performance Deep Dive

Step 1 — Get the overview

"What percentage of orders were delivered later than the estimated delivery date?"

Step 2 — Find the problem areas

"Which Brazilian states have the highest late delivery rates?"

Step 3 — Understand the impact

"In states with the highest late delivery rates, what is the average customer review score compared to states with on-time deliveries?"

Revenue Analysis Deep Dive

Step 1 — Get the overview

"What was the total revenue for 2017 and 2018? Show me the difference between the two years."

Step 2 — Find the best performers

"Which product categories generated the most revenue in 2018?"

Step 3 — Understand seasonality

"For the top 3 revenue-generating categories in 2017, show me monthly sales trends. Are there any seasonal patterns?"

Seller Performance Deep Dive

Step 1 — Get the overview

"Who are the top 10 sellers by total revenue?"

Step 2 — Dig deeper

"For the top 10 sellers, what is their average delivery time and average customer review score?"

Step 3 — Spot the outliers

"Are there any sellers with high revenue but low review scores? Show me sellers with over 100 orders and an average rating below 3."

What to Read Next

• General Assistant Demo

• Internal Knowledge Assistant Demo

• Best Practices for Better Results