Documentation and naming conventions in Tableau - Real Business Scenario

Scenario Mode

👤 Your Role: You are a Tableau developer at a retail company.

📋 Request: Your manager wants you to create a clear and easy-to-understand sales dashboard. They also want you to follow good documentation and naming rules so others can easily use and update your work.

📊 Data: You have monthly sales data by region and product category. The data includes columns for Date, Region, Product Category, Sales Amount, and Quantity Sold.

🎯 Deliverable: A Tableau dashboard with clear names for sheets, fields, and calculations, plus documentation explaining your naming choices and how to use the dashboard.

Sample Data

Date	Region	Product Category	Sales Amount	Quantity Sold
2024-01-01	North	Electronics	12000	30
2024-01-01	South	Furniture	8000	15
2024-02-01	East	Electronics	15000	40
2024-02-01	West	Furniture	7000	10
2024-03-01	North	Clothing	5000	50
2024-03-01	South	Electronics	11000	25
2024-04-01	East	Clothing	6000	60
2024-04-01	West	Electronics	13000	35

1

Step 1: Rename data fields with clear, descriptive names in Tableau's Data Pane.

Rename 'Sales Amount' to 'Total Sales USD', 'Quantity Sold' to 'Units Sold', 'Product Category' to 'Category', 'Date' to 'Sale Date'.

Expected Result

Fields have clear, consistent names that anyone can understand.

2

Step 2: Create calculated fields with meaningful names and add descriptions.

Create 'Average Sales per Unit' with formula: [Total Sales USD] / [Units Sold]. Add description: 'Average sales value for each unit sold'.

Expected Result

Calculated field named 'Average Sales per Unit' appears with description for easy understanding.

3

Step 3: Name worksheets clearly to reflect their content.

Rename sheets as 'Monthly Sales Trend', 'Sales by Region', and 'Category Performance'.

Expected Result

Worksheet tabs have clear names that describe the visualizations.

4

Step 4: Add dashboard and worksheet captions to explain purpose and usage.

Add caption to 'Monthly Sales Trend' sheet: 'Shows total sales each month across all regions.' Add dashboard caption: 'This dashboard helps track sales performance by time, region, and category.'

Expected Result

Captions appear below sheets and dashboard, guiding users.

5

Step 5: Use consistent naming conventions: capitalize first letters, avoid abbreviations, and separate words with spaces.

Ensure all field and sheet names follow this style, e.g., 'Total Sales USD' not 'totalsalesusd' or 'TSUSD'.

Expected Result

All names are easy to read and consistent throughout the workbook.

6

Step 6: Document your naming conventions and dashboard usage in a separate Tableau Story or a text box on the dashboard.

Create a Story page titled 'Documentation' explaining naming rules and how to use the dashboard filters and views.

Expected Result

Users can read the documentation to understand the dashboard and naming rules.

Final Result

Monthly Sales Trend

↓

Sales by Region

↓

Category Performance

✓Sales vary by month with a peak in February.

✓East region shows strong sales in Electronics.

✓Clothing category has steady sales across regions.

✓Clear naming and documentation make dashboard easy to use and update.

Bonus Challenge

Create a parameter to allow users to switch between viewing sales by 'Region' or by 'Category' in the same chart.

Show Hint

Use a parameter with values 'Region' and 'Category' and a calculated field that returns the selected dimension for the chart.