CRT Data Analytics & Visualization 3 — Questions and Answers
Question 1: Which visualization type is most effective for comparing sales performance across five different cigar product lines for the same time period?
- Stacked area chart
- Grouped bar chart (Correct answer)
- Single-line chart
- Bubble chart
Correct answer: Grouped bar chart
A grouped bar chart places multiple categories side by side, making direct comparison across product lines straightforward.
Question 2: What does a positive correlation between marketing spend and cigar unit sales tell a tobacconist?
- Marketing spend should be reduced immediately
- As marketing investment increases, sales tend to increase as well (Correct answer)
- The two variables are unrelated
- Sales drive marketing budgets, not the other way around
Correct answer: As marketing investment increases, sales tend to increase as well
A positive correlation means both variables move in the same direction, suggesting marketing investment is associated with higher sales.
Question 3: A retail tobacco manager reviews a heat map of hourly store traffic. What primary business decision can this data support?
- Setting vendor payment terms
- Optimizing staff scheduling to match peak traffic hours (Correct answer)
- Selecting new cigar blends to carry
- Determining humidor construction materials
Correct answer: Optimizing staff scheduling to match peak traffic hours
Heat maps of hourly traffic reveal peak periods, directly informing staff scheduling to match customer demand.
Question 4: Which metric best measures how often a customer returns to a tobacco shop after their initial visit?
- Gross margin
- Customer retention rate (Correct answer)
- Inventory turnover
- Cost of goods sold
Correct answer: Customer retention rate
Customer retention rate tracks the percentage of customers who make repeat purchases, reflecting loyalty and satisfaction.
Question 5: A tobacconist uses a funnel chart for their customer journey data. What does a large drop between 'store entry' and 'purchase' stages indicate?
- High customer satisfaction
- Many visitors leave without buying, suggesting a conversion problem (Correct answer)
- Inventory is overstocked
- Staff are too busy to restock shelves
Correct answer: Many visitors leave without buying, suggesting a conversion problem
A large funnel drop-off between entry and purchase signals that a significant number of visitors are not converting to buyers.
Question 6: When presenting tobacco sales data to a non-technical store owner, which practice improves data comprehension?
- Using raw SQL query output with no formatting
- Limiting charts to one key message each with clear labels (Correct answer)
- Including all available data fields in a single table
- Using jargon-heavy titles to appear more authoritative
Correct answer: Limiting charts to one key message each with clear labels
Clear labels and a single focused message per chart reduce cognitive load and help non-technical audiences quickly grasp insights.
Question 7: What is the primary purpose of tracking inventory days-on-hand for a premium cigar collection?
- To calculate employee commissions
- To determine how long current stock will last before needing reorder (Correct answer)
- To set humidity levels in the humidor
- To compare competitor pricing
Correct answer: To determine how long current stock will last before needing reorder
Days-on-hand tells a retailer how many days of sales their current inventory can cover, informing timely reorder decisions.
CRT Data Analytics & Visualization 3
Which visualization type is most effective for comparing sales performance across five different cigar product lines for the same time period?