Trend analysis in Tableau - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants to understand how monthly sales have changed over the past year to identify any upward or downward trends.

📊 Data: You have a dataset with monthly sales data for the last 12 months. The data includes columns for Month, Year, and Sales Amount.

🎯 Deliverable: Create a line chart in Tableau showing monthly sales trends over the past year with clear labels and a trend line.

Sample Data

Year	Month	Sales Amount
2023	January	12000
2023	February	15000
2023	March	13000
2023	April	17000
2023	May	16000
2023	June	18000
2023	July	19000
2023	August	21000
2023	September	20000
2023	October	22000
2023	November	23000
2023	December	25000

1

Step 1: Connect your Tableau workbook to the sales data source containing Year, Month, and Sales Amount columns.

No formula needed; just connect the data source.

Expected Result

Data is loaded and visible in Tableau's Data pane.

2

Step 2: Create a calculated field to combine Year and Month into a single date field for proper time series ordering.

DATE(DATEPARSE('yyyy MMMM', STR([Year]) + ' ' + [Month]))

Expected Result

A new date field is created representing the first day of each month.

3

Step 3: Drag the new date field to the Columns shelf to set the timeline.

Use the calculated date field on Columns.

Expected Result

Months appear in order from January to December on the horizontal axis.

4

Step 4: Drag Sales Amount to the Rows shelf to plot sales values.

SUM([Sales Amount]) on Rows.

Expected Result

A line chart starts to form showing sales values over months.

5

Step 5: Change the Marks type to Line to visualize the trend clearly.

Select 'Line' from the Marks dropdown.

Expected Result

A smooth line connects monthly sales points.

6

Step 6: Add a trend line to the chart to highlight the overall sales trend.

Right-click on the chart > Trend Lines > Show Trend Lines.

Expected Result

A trend line appears showing the general direction of sales over the year.

7

Step 7: Add clear axis titles and chart title for accessibility and clarity.

Edit axis titles to 'Month' and 'Sales Amount'; add chart title 'Monthly Sales Trend for 2023'.

Expected Result

Chart is clearly labeled for easy understanding.

Final Result

Monthly Sales Trend for 2023

Month ->
Jan  Feb  Mar  Apr  May  Jun  Jul  Aug  Sep  Oct  Nov  Dec
|
|       *
|      *  *
|     *     *
|    *        *
|   *           *
|  *              *
| *                 *
|*                    *
+----------------------------------------------> Sales Amount

✓Sales generally increased from January to December 2023.

✓There is a steady upward trend with minor dips in March and September.

✓The highest sales occurred in December, indicating strong year-end performance.

Bonus Challenge

Create a dashboard that compares monthly sales trends for 2022 and 2023 side by side.

Show Hint

Use the Year field to filter or separate the data, and create two line charts on the same dashboard for comparison.

Practice

1. What is the main purpose of trend analysis in Tableau?

easy

A. To create pie charts for categories

B. To show how data changes over time

C. To filter data by region

D. To sort data alphabetically

Solution

1. Step 1: Understand trend analysis concept

   Trend analysis focuses on observing data changes over a period of time.

2. Step 2: Identify the correct purpose

   Among the options, only showing data changes over time matches trend analysis.

3. Final Answer:

   To show how data changes over time -> Option B

4. Quick Check:

   Trend analysis = show data changes over time [OK]

Hint: Trend analysis = data changes over time [OK]

Common Mistakes:

• Confusing trend analysis with filtering or sorting
• Thinking trend analysis creates pie charts
• Assuming trend analysis is about categories only

2. Which of the following is the correct way to add a trend line in Tableau?

easy

A. Drag a date field to Columns, measure to Rows, then add trend line from Analytics pane

B. Drag a measure to Filters, then add trend line from Data pane

C. Drag a dimension to Rows, then add trend line from Marks card

D. Drag a date field to Filters, then add trend line from Format pane

Solution

1. Step 1: Understand how to create trend charts

   Trend charts require date on Columns and measure on Rows to show data over time.

2. Step 2: Identify how to add trend lines

   Trend lines are added from the Analytics pane, not Data, Marks, or Format panes.

3. Final Answer:

   Drag a date field to Columns, measure to Rows, then add trend line from Analytics pane -> Option A

4. Quick Check:

   Date on Columns + measure on Rows + Analytics pane = trend line [OK]

Hint: Date on Columns + measure on Rows + Analytics pane [OK]

Common Mistakes:

• Trying to add trend line from wrong pane
• Placing date field in Filters instead of Columns
• Adding trend line without proper chart setup

3. Given a line chart with Sales on Rows and Order Date (year) on Columns, what does adding a linear trend line show?

medium

A. The average sales value across all years

B. The sales distribution by product category

C. The total sales for each year

D. The direction and strength of sales change over years

Solution

1. Step 1: Understand what a linear trend line represents

   A linear trend line shows the overall direction (up/down) and strength of change in data over time.

2. Step 2: Apply this to sales over years

   It does not show averages or totals directly, but the pattern of sales increase or decrease over years.

3. Final Answer:

   The direction and strength of sales change over years -> Option D

4. Quick Check:

   Linear trend line = direction and strength of change [OK]

Hint: Trend line shows direction and strength of change [OK]

Common Mistakes:

• Confusing trend line with average or total values
• Thinking trend line shows category distribution
• Ignoring that trend line summarizes pattern over time

4. You created a trend chart but the trend line does not appear. What is the most likely reason?

medium

A. The trend line option is disabled in Tableau settings

B. The measure is placed on Filters instead of Rows

C. The date field is not continuous (green) on Columns

D. The data source has no date field

Solution

1. Step 1: Check date field type on Columns

   Trend lines require a continuous date field (green pill) on Columns to show smooth trends.

2. Step 2: Understand why trend line might not appear

   If the date is discrete (blue pill), Tableau treats it as categories, so trend line cannot be drawn.

3. Final Answer:

   The date field is not continuous (green) on Columns -> Option C

4. Quick Check:

   Continuous date needed for trend line [OK]

Hint: Use continuous (green) date on Columns for trend lines [OK]

Common Mistakes:

• Placing measure on Filters instead of Rows
• Assuming trend line option is disabled by default
• Ignoring the date field type requirement

5. You want to analyze monthly sales trends for two product categories side by side. Which setup in Tableau best achieves this?

hard

A. Place Order Date (month) on Columns, Sales on Rows, and Category on Color; add trend lines

B. Place Category on Columns, Sales on Rows, and Order Date (month) on Filters; add trend lines

C. Place Sales on Columns, Order Date (month) on Rows, and Category on Filters; add trend lines

D. Place Order Date (month) on Rows, Category on Rows, and Sales on Filters; add trend lines

Solution

1. Step 1: Arrange date and measure for trend analysis

   Order Date (month) should be on Columns (continuous) and Sales on Rows to show trends over time.

2. Step 2: Use Category on Color to compare categories side by side

   Placing Category on Color differentiates lines for each category in the same chart.

3. Step 3: Add trend lines from Analytics pane

   This setup allows clear monthly trends for each category with trend lines visible.

4. Final Answer:

   Place Order Date (month) on Columns, Sales on Rows, and Category on Color; add trend lines -> Option A

5. Quick Check:

   Date on Columns + Sales on Rows + Category on Color = side-by-side trends [OK]

Hint: Date on Columns, Sales on Rows, Category on Color for side-by-side trends [OK]

Common Mistakes:

• Putting Category on Filters hides categories from view
• Placing Sales on Columns breaks trend line logic
• Using Filters for date removes timeline context