Why time analysis reveals trends in Tableau - Business Case Study

Scenario Mode

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

📋 Request: Your manager wants to understand how sales have changed over the past six months to identify any trends.

📊 Data: You have monthly sales data including Date, Region, Product Category, and Sales Amount.

🎯 Deliverable: Create a time series line chart in Tableau showing total sales per month for the last six months, highlighting any upward or downward trends.

Sample Data

Date	Region	Product Category	Sales Amount
2023-11-01	North	Electronics	12000
2023-11-01	South	Furniture	8000
2023-12-01	North	Electronics	15000
2023-12-01	South	Furniture	9000
2024-01-01	North	Electronics	14000
2024-01-01	South	Furniture	8500
2024-02-01	North	Electronics	16000
2024-02-01	South	Furniture	9500
2024-03-01	North	Electronics	17000
2024-03-01	South	Furniture	10000
2024-04-01	North	Electronics	18000
2024-04-01	South	Furniture	11000

1

Step 1: Connect Tableau to the sales data source containing Date, Region, Product Category, and Sales Amount.

Use 'Connect to Data' and select the data file or database with the sales data.

Expected Result

Tableau loads the sales data with all columns available.

2

Step 2: Create a new worksheet and drag the 'Date' field to the Columns shelf.

Right-click 'Date' field, select 'Month' as the date part to group data by month.

Expected Result

Columns show months from November 2023 to April 2024.

3

Step 3: Drag the 'Sales Amount' field to the Rows shelf and set aggregation to SUM.

SUM([Sales Amount])

Expected Result

Rows show total sales amount for each month.

4

Step 4: Add a filter to include only the last six months of data.

Filter 'Date' field to show data from 2023-11-01 to 2024-04-01.

Expected Result

Chart displays sales data only for the last six months.

5

Step 5: Format the line chart for clarity: add axis titles, adjust colors, and enable tooltips.

Set X-axis title to 'Month', Y-axis title to 'Total Sales', use a distinct color for the line.

Expected Result

Clear, readable line chart showing monthly sales trends.

6

Step 6: Interpret the chart to identify trends: look for upward or downward movement over time.

Observe the line slope and monthly sales values.

Expected Result

You see sales increasing steadily from November 2023 to April 2024.

Final Result

Month  | Nov  | Dec  | Jan  | Feb  | Mar  | Apr  
-------|-------|-------|-------|-------|-------|-------
Sales  | 20000 | 24000 | 22500 | 25500 | 27000 | 29000 

(Line chart with a rising line from left to right showing increasing sales)

✓Sales have steadily increased over the last six months.

✓The upward trend suggests growing customer demand or successful sales strategies.

✓Time analysis helps reveal these trends by showing changes month by month.

Bonus Challenge

Create a dashboard that compares monthly sales trends by Region side by side.

Show Hint

Use 'Region' as a filter or create separate line charts for each region and place them in a dashboard.