E-Commerce Intelligence Report

Build a weekly sales analytics report for an online store

[STORE_DB] · modules 4-6 · 14 steps

progress: 0/13 steps0%

# scenario

Welcome to ShopSmart! You're the new junior analyst on the BI team. The marketing director wants a weekly sales report that covers customer behavior, product performance, and revenue trends. As you learn JOINs, subqueries, and window functions, you'll build out the report piece by piece.

# build

A sales intelligence report with customer rankings, revenue trends, category performance, and product analytics.

# steps

step 01
Above-Average Orders
step 02[locked]
Multi-Purchase Customers
step 03[locked]
Customer Spend vs Category Average
# from subqueries-ctes/correlated-subqueries
step 04[locked]
Customer Revenue Tiers
step 05[locked]
New Products This Month
step 06[locked]
Price Audit Report
step 07[locked]
Zero-Order Products Audit
step 08[locked]
Order Consistency Check
# from modifying-data/transactions
step 09[locked]
Customer Name Formatting
# from functions/string-functions
step 10[locked]
Monthly Sales Trend
# from functions/date-functions
step 11[locked]
Rounded Price Display
step 12[locked]
Customer Spending Tiers
step 14[locked]
Complete Intelligence Report
# from functions/coalesce-nullif