Day 12 — 12 practice questions
Everything from the first eleven days. Write your own answer before opening each box.
How to use this page
Each question shows a working calculation. Read it, write your own first, then run the box. A different calculation that returns the same number is a good sign.
Every calculation on this page runs against the Orders data source below - 48 rows, dimensions in blue, measures in green, exactly as Tableau colours them.
1. Total sales
2. How many orders?
3. Average order value, rounded
4. Sales for one region
5. Two conditions at once
Accessories sold in the West.
6. Profit ratio
7. Profit ratio by category
8. Percent of total by region
9. A row-level band
Label each order Bulk, Medium or Small.
10. A month total
11. The best region, from inside any view
12. A full report row
Where to go next
You now have the calculation half of Tableau - the half that takes longest to learn and the half interviews ask about. The rest is the application: shelves, marks, dashboards, actions, and publishing to Tableau Server or Public.
The Power BI tutorial is worth doing alongside this one. The tools compete, but the thinking is the same, and knowing both makes you far harder to replace.
Try these yourself
- Redo question 5 for Technology in the North.
- Find the total quantity sold in 2025.
- Work out the average price per unit across the whole data source.
- Build a view by Manager showing sales, profit and ratio.
- Find each region gap to the best-performing region.