Using Data Visualization | Dataford Interview Questions

How do you use data visualization to support decision-making?

Answer by analyzing monthly KPI performance and returning the key metrics that would feed a dashboard. Keep the result at one row per month and include only completed months.

Output

One row per month, ordered chronologically
Columns: month, total_orders, total_revenue, avg_order_value
Exclude rows where the month is incomplete or revenue is null

Schema

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
order_date	DATE	Date the order was placed
order_amount	DECIMAL(10,2)	Revenue from the order
channel	VARCHAR(50)	Order channel
region	VARCHAR(50)	Sales region

Your question is Using Data Visualization. Start with the requirements and the one table 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