Experience Building Dashboards in Looker or QuickSight

Describe your experience building dashboards and reports in Looker or QuickSight.

Using the provided tables, write a PostgreSQL query that produces a regional Q1 2025 revenue report suitable for a dashboard. Include regions with no completed orders and exclude orders outside the quarter from all metrics.

Output

One row per region.
Columns: region_name, completed_customers, completed_orders, total_revenue, and avg_order_value.
Include completed orders only in the metrics, while preserving regions without completed orders.
Order by total_revenue descending, then region_name ascending.

Schema

regions

Column	Type	Description
region_idPK	INT	Unique region identifier
region_name	VARCHAR(50)	Display name of the region

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer display name
region_id	INT	Region assigned to the customer

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer who placed the order
order_date	DATE	Date the order was placed
amount	NUMERIC(10,2)	Order amount
status	VARCHAR(20)	Order status

Your question is Experience Building Dashboards in Looker or QuickSight. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem