Module 3 · From question to insight Lesson 7 of 15
Turning a vague request into a runnable question
"Sales are down" is not a question. Which period, compared to what, which product lines, and what counts as a sale — a good analyst writes those four decisions down before typing any SQL.
Worked example
"Sales are down" becomes: total amount per month for the last 12 months, split by region, excluding cancelled orders. Now a single query answers it.
Your practice task
Take three vague requests you have heard and write each as a precise set of columns, filters and a time window.
Do this before moving on. Reading a solution teaches the shape of it; typing it teaches you.
Key takeaway
"Sales are down" is not a question. Which period, compared to what, which product lines, and what counts as a sale — a good analyst writes those four decisions down before typing any SQL.
Keep your place in this course
A free account saves which lessons you have finished and unlocks the certificate. The lesson itself stays free to read.
Create free account or sign inCourse complete
You finished every lesson.
Your certificate is ready, and the projects you built are the proof to attach to an application.
Almost there
15 lessons left of 15
Finish every lesson to unlock the certificate. Each one ends in a practice task — do them and the final project brief writes itself.