Introduction
Welcome to your fifth lesson in mastering Tableau. In our last session, you learned the crucial difference between dimensions (which slice and group your data) and measures (which provide the aggregated numbers). This distinction is the "why" behind building visualizations.
Today, we move to the "how." This lesson focuses on the learning outcome: Create a basic worksheet by dragging fields onto shelves. This is the fundamental hands-on skill you'll use every time you build a chart, table, or map in Tableau. We will cover:
- The key components of the Tableau worksheet: the Rows shelf, Columns shelf, and the Marks card.
- How to drag dimensions and measures from the Data pane onto these shelves to create a basic visualization.
- How adding fields to different areas changes the structure and detail of your view.
By the end of this lesson, you will have built your first chart from scratch, transforming raw data into a meaningful visual.
The Anatomy of a Worksheet
When you open a new worksheet in Tableau, you are presented with a blank canvas. The magic happens when you start populating three key areas:
- Columns Shelf: Fields placed here create columns in a table or the horizontal x-axis of a chart.
- Rows Shelf: Fields placed here create rows in a table or the vertical y-axis of a chart.
- Marks Card: This powerful area controls the visual properties of your data points (or "marks"). You can change the chart type (e.g., bar, line, square), or add fields to control the Color, Size, Label, Detail, and Tooltip of the marks.
The Rows and Columns shelves work together to form the structure of your visualization. A great way to understand their distinct roles is to see how they orient your data.
Tableau Rows and Columns - understanding these concepts are key to mastering Tableau | sqlbelle
This short video from sqlbelle provides an excellent explanation of how the Rows and Columns shelves function. Pay attention to the icons next to each shelf—they are visual cues for how your data will be displayed.
Watch the video from the beginning to 02:51. Notice how: Dragging a discrete (blue) field to Columns arranges the labels horizontally. Dragging the same field to Rows arranges the labels vertically. Dragging a continuous (green) field to Columns creates a horizontal axis (x-axis). Dragging the same field to Rows creates a vertical axis (y-axis).
This concept is simple but foundational: Columns go across, Rows go down.
Building Your First Visualization: A Step-by-Step Guide
Now, let's apply these concepts. We will build a simple line chart to see how profit has changed over the years, using the Sample - Superstore dataset that comes with Tableau.
The following reading from Tableau's official help documentation will guide us through the process. We will tackle it section by section.
Build a Basic View to Explore Your Data
First, let's get oriented. This first part of the article explains how to connect to the sample data and provides a quick recap of the Data pane, which you'll remember from our last lesson.
Read the sections 'Connect to your data' and 'About the Data pane'. You don't need to perform the connection steps if you already have Tableau open with the Superstore data, but it's good to know where it comes from. The main goal here is to refresh your memory on where to find dimensions and measures.
With the data ready, we can start building. The core action is dragging fields. You're simply telling Tableau what you want to see (Profit) and how you want to see it broken down (by Year).
Build a Basic View to Explore Your Data
Now for the main event. This section provides the exact steps for creating the chart. Follow along in your own Tableau application.
Follow the two steps in the section 'Build a view from scratch'. Drag the Order Date dimension to the Columns shelf. Drag the Profit measure to the Rows shelf. Notice how Tableau automatically creates a line chart because you've combined a date dimension with a measure—it intelligently assumes you want to see a trend over time.
You have now successfully created a basic worksheet! It shows total profit for each year.
Enhancing Your View with the Marks Card
Your line chart is informative, but it could be better. What if you wanted to see the profit trend for each customer segment? Or add labels to see the exact profit values? This is where the Marks card comes in.
By dragging fields to the properties on the Marks card, you can add more layers of detail and context to your visualization.
How to Install Tableau and Create First Visualization | Tableau Tutorials for Beginners
This video from Alex The Analyst clearly demonstrates how to use the Marks card to enhance a view. We'll focus on adding color and labels.
Watch from 08:11 to 10:25. The video uses a different example, but the principle is identical. Observe how: Dragging a dimension ('Genre') to Color (at 09:12) splits the single line into multiple colored lines, one for each category. A legend is automatically created. Dragging a measure ('Global Sales') to Label (at 10:04) adds the numerical values directly onto the chart.
Hands-On Practice
Now, apply what you just saw to the profit line chart you built.
- In your Tableau worksheet, locate the Segment dimension in the Data pane.
- Drag Segment and drop it directly onto the Color property on the Marks card.
- Observe: Your single blue line should now be three separate lines, each with a different color representing a customer segment (Consumer, Corporate, Home Office).
- Next, locate the Profit measure in the Data pane again.
- Drag Profit and drop it onto the Label property on the Marks card.
- Observe: The profit values now appear as labels on the data points of your lines.
By dragging just four fields—Order Date, Profit, Segment, and Profit again—you've created a rich, detailed visualization that answers a much more complex question than where you started.
Conclusion
In this lesson, you've made the leap from theory to practice. You now have the fundamental mechanical skill required to build any visualization in Tableau.
Key Takeaways:
- Visualizations are built by dragging dimensions and measures from the Data pane onto shelves and cards.
- The Columns and Rows shelves create the fundamental structure of your view (the horizontal and vertical layout).
- Placing a dimension on a shelf slices the view into categories; placing a measure creates an axis for quantitative values.
- The Marks card allows you to control the appearance of your data points, adding detail through Color, Size, Label, and more.
Preview of the Next Lesson:
Now that you can create a view, the next logical step is to save your work. In the next lesson, we will cover how to save and open a Tableau workbook. You'll learn the important difference between a .twb file and a .twbx file, which is critical for sharing your analysis with others.