Mark types (automatic, bar, line, circle) in Tableau - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a clear visual report showing monthly sales performance and product category trends using different mark types in Tableau.

📊 Data: You have sales data including Date, Product Category, Sales Amount, and Region for the last 6 months.

🎯 Deliverable: Create a Tableau dashboard with three visualizations: a bar chart for total sales by product category, a line chart showing monthly sales trends, and a circle mark chart highlighting sales by region.

Sample Data

Date	Product Category	Sales Amount	Region
2024-01-15	Electronics	12000	North
2024-01-20	Clothing	8000	South
2024-02-10	Electronics	15000	East
2024-02-18	Clothing	7000	West
2024-03-05	Home Goods	9000	North
2024-03-22	Electronics	13000	South
2024-04-12	Clothing	8500	East
2024-04-25	Home Goods	9500	West
2024-05-15	Electronics	14000	North
2024-05-30	Clothing	9000	South
2024-06-10	Home Goods	10000	East
2024-06-20	Electronics	16000	West

1

Step 1: Connect your sales data to Tableau and open a new worksheet.

Load the data source with columns: Date, Product Category, Sales Amount, Region.

Expected Result

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

2

Step 2: Create a bar chart showing total sales by Product Category.

Drag 'Product Category' to Columns, drag 'Sales Amount' to Rows, set mark type to 'Bar'.

Expected Result

Bar chart displays total sales for Electronics, Clothing, and Home Goods.

3

Step 3: Create a line chart showing monthly sales trends.

Drag 'Date' to Columns (set to Month), drag 'Sales Amount' to Rows, set mark type to 'Line'.

Expected Result

Line chart shows sales trend over months from January to June.

4

Step 4: Create a circle mark chart showing sales by Region.

Drag 'Region' to Columns, drag 'Sales Amount' to Rows, set mark type to 'Circle', size circles by 'Sales Amount'.

Expected Result

Circle chart shows sales distribution by region with circle size proportional to sales.

5

Step 5: Combine the three charts into a dashboard for easy comparison.

Create a new dashboard, add the bar chart, line chart, and circle chart worksheets.

Expected Result

Dashboard displays all three visualizations clearly with appropriate titles.

Final Result

Dashboard Layout:

+-------------------+-----------------------+
| Bar Chart: Sales  | Line Chart: Monthly   |
| by Product        | Sales Trend           |
| Category          |                       |
+-------------------+-----------------------+
| Circle Chart: Sales by Region               |
+--------------------------------------------+

✓Electronics consistently have the highest sales among product categories.

✓Sales show an increasing trend from January to June.

✓The North region has the largest sales volume as shown by the biggest circle.

Bonus Challenge

Add color coding to the bar chart to differentiate product categories by region.

Show Hint

Drag 'Region' to the Color mark on the bar chart to show sales by category and region.