Year-over-year comparison in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a Year-over-Year (YoY) comparison in Tableau?

Year-over-Year comparison shows how a value (like sales) changes compared to the same period in the previous year. It helps spot growth or decline over time.

intermediate

Which Tableau function helps calculate the previous year's value for YoY comparison?

The LOOKUP() function or DATEADD() function can be used to get the previous year's value for comparison.

beginner

How do you calculate the YoY growth percentage in Tableau?

YoY Growth % = ((Current Year Value - Previous Year Value) / Previous Year Value) * 100

beginner

Why is it important to use the same time period when comparing YoY data?

Using the same time period (like same month or quarter) ensures the comparison is fair and accounts for seasonal effects.

beginner

What type of visualization is best for showing Year-over-Year comparisons?

Line charts or bar charts with side-by-side bars for each year are best. They clearly show trends and differences over time.

Which Tableau function can you use to shift dates by one year for YoY comparison?

A IF()

B DATEADD()

C SUM()

D LOOKUP()

DATEADD() shifts dates by a specified interval, like one year, which is useful for YoY comparisons.

What does a positive YoY growth percentage indicate?

A Decrease compared to last year

B No change compared to last year

C Increase compared to last year

D Data error

A positive YoY growth means the value increased compared to the same period last year.

Why should you compare the same months when doing YoY analysis?

A To avoid seasonal bias

B To increase data volume

C To simplify calculations

D To ignore holidays

Comparing the same months avoids seasonal effects that can distort the comparison.

Which visualization best shows YoY trends clearly?

A Line chart

B Pie chart

C Scatter plot

D Heat map

Line charts show trends over time clearly, making them ideal for YoY comparisons.

What is the formula for YoY growth percentage?

A Previous Year Value / Current Year Value

B Current Year Value - Previous Year Value

C (Current Year Value / Previous Year Value) * 100

D ((Current Year Value - Previous Year Value) / Previous Year Value) * 100

YoY growth % is calculated by dividing the difference by the previous year's value, then multiplying by 100.

Explain how to create a Year-over-Year comparison in Tableau using calculated fields.

Think about shifting dates and calculating differences.

Describe best practices for visualizing Year-over-Year data in a dashboard.

Focus on clarity and easy comparison.