Master Tableau From Scratch

Learn Tableau fundamentals, data connections, data preparation, filtering, data modeling, calculations, LOD expressions, visualizations, dashboards, and storytelling through structured practical lessons.

COURSE SYLLABUS

Basic Charts in Tableau

Learn how to create essential data visualizations in Tableau, including bar charts, line charts, area charts, pie charts, scatter plots and histograms. Understand how to use Rows, Columns, Marks Card and Show Me to convert raw data into meaningful visual insights.

1. Introduction to Basic Charts in Tableau

Data visualization is the graphical representation of information and data using visual elements such as charts, graphs, maps and tables. Instead of analyzing large amounts of raw data, users can understand patterns, comparisons, relationships and trends through visual representations.

Tableau provides multiple built-in chart types that help users explore data and communicate analytical findings. By dragging dimensions and measures into the worksheet, users can quickly create visualizations without writing complex programming code.

For example, a sales dataset may contain thousands of records. A chart can help answer questions such as which product category generates the highest revenue, how sales change over time and which regions perform better.

Why are charts important?

  • Make large datasets easier to understand.
  • Help identify trends and patterns.
  • Support comparisons between categories.
  • Highlight unusual values and outliers.
  • Help users communicate business insights.
  • Support better data-driven decisions.

2. Understanding the Tableau Worksheet

A Tableau worksheet is the main workspace where users create individual charts and visualizations. It provides different shelves, cards and panels that control how data is displayed.

Important worksheet components

Component Description
Data Pane Displays available dimensions, measures and fields from the connected data source.
Columns Shelf Controls fields displayed along the horizontal direction of the view.
Rows Shelf Controls fields displayed along the vertical direction of the view.
Marks Card Controls mark type, color, size, label, detail and tooltip.
Filters Shelf Restricts the data included in the visualization.
Show Me Suggests chart types based on the selected fields and their data roles.
View Area Displays the actual chart or visualization created in the worksheet.
Tip: Before creating a chart, identify the business question you want to answer. The question helps determine which fields and chart type should be used.

3. Understanding Dimensions and Measures in Charts

Dimensions and measures are important building blocks of Tableau visualizations. Dimensions generally represent descriptive or categorical information, while measures represent numeric values that can be aggregated.

Dimension Measure
Category Sales
Region Profit
Product Name Quantity
Order Date Discount
Customer Name Revenue

For example, when Category is placed on the Columns shelf and Sales is placed on the Rows shelf, Tableau can create a bar chart that compares sales across product categories.

Dimension Category Region Measure Sales Profit Chart Visual
Dimensions describe categories, while measures provide numeric values for visualization.

4. Bar Chart in Tableau

A bar chart is one of the most commonly used visualizations in Tableau. It represents data using rectangular bars whose lengths correspond to numeric values. Bar charts are useful for comparing values across different categories.

Types of Bar Charts

  • Vertical Bar Chart: Displays categories horizontally and values vertically.
  • Horizontal Bar Chart: Displays categories vertically and values horizontally.
  • Stacked Bar Chart: Divides each bar into segments to show category composition.
  • Side-by-Side Bar Chart: Places multiple bars next to each other for comparison.

Example: Sales by Product Category

Consider the following sample dataset:

Category Sales
Technology85,000
Furniture62,000
Office Supplies48,000
Accessories35,000

Steps to Create a Bar Chart

  1. Open Tableau Desktop or Tableau Public.
  2. Connect to a dataset containing Category and Sales fields.
  3. Open a new worksheet.
  4. Drag the Category dimension to the Columns shelf.
  5. Drag the Sales measure to the Rows shelf.
  6. Tableau creates a bar visualization when the field arrangement supports it.
  7. Use the Marks Card or Show Me panel to select the required bar chart style.
  8. Drag Sales to Label if you want to display values on the bars.
  9. Use Color to distinguish categories when it improves readability.
  10. Rename the worksheet to Sales by Category.
Sales by Category 85,000 62,000 48,000 35,000 Technology Furniture Office Supplies Accessories
Illustrative bar chart comparing sales across product categories.
Best Practice: Use bar charts when the main objective is to compare values between categories. Sort the bars when ranking is important.

5. Line Chart in Tableau

A line chart displays data points connected by straight lines. It is especially useful for analyzing changes over time, identifying trends and understanding fluctuations in numeric values.

Line charts are commonly used in business reporting for monthly sales, yearly revenue, website traffic, customer growth and financial performance.

Example: Monthly Sales Trend

Month Sales
January20,000
February25,000
March22,000
April32,000
May38,000
June35,000

Steps to Create a Line Chart

  1. Connect Tableau to a dataset containing Order Date and Sales.
  2. Open a new worksheet.
  3. Drag Order Date to the Columns shelf.
  4. Select the required date level, such as Month.
  5. Drag Sales to the Rows shelf.
  6. Open the Marks Card and select Line if necessary.
  7. Use Color to distinguish multiple lines if comparing categories.
  8. Use Tooltip to display detailed values when hovering over points.
  9. Add an appropriate chart title.
Monthly Sales Trend Jan Feb Mar Apr May Jun
Illustrative line chart showing how monthly sales change over time.
Best Practice: Use a line chart when the sequence of values matters, especially when analyzing time-based data.

6. Area Chart in Tableau

An area chart is similar to a line chart, but the area between the line and the axis is filled with color. It helps communicate changes in values over time and can also show how different components contribute to a total.

Types of Area Charts

  • Area Chart: Shows the trend of a measure with the area underneath filled.
  • Stacked Area Chart: Shows the contribution of multiple categories to a combined total.
  • Percentage Area Chart: Shows the relative percentage contribution of categories over time.

Steps to Create an Area Chart

  1. Open a worksheet with a date field and a numeric measure.
  2. Drag the date field to Columns.
  3. Drag the measure, such as Sales, to Rows.
  4. Open the Marks Card.
  5. Select Area as the mark type, or use Show Me where available.
  6. To create a stacked area chart, add a category dimension to Color.
  7. Review the chart to ensure that the filled areas are easy to interpret.
Area Chart Example Jan Feb Mar Apr May Jun
Illustrative area chart showing a filled trend over time.
Important: Stacked area charts can make it difficult to compare individual categories because most categories do not share the same baseline. Consider using a line chart when precise category comparisons are required.

7. Pie Chart in Tableau

A pie chart represents the contribution of different categories to a whole. The complete circle represents 100 percent, while each slice represents the proportion of a category.

Pie charts are useful when the dataset contains a small number of categories and the purpose is to show how each category contributes to the total.

Example: Sales Contribution by Category

Category Sales
Technology50,000
Furniture30,000
Office Supplies20,000

Steps to Create a Pie Chart

  1. Open a new Tableau worksheet.
  2. Select the Pie mark type from the Marks Card.
  3. Drag Category to Color.
  4. Drag Sales to Angle to control the size of each slice.
  5. Drag Sales to Label if values should be displayed.
  6. Optionally use Quick Table Calculation to display Percent of Total.
  7. Adjust the size using the Size option in the Marks Card.
  8. Review the labels and legend to ensure the chart is understandable.
Sales Contribution Technology - 50% Furniture - 30% Office Supplies - 20%
Illustrative pie chart showing the percentage contribution of each category.
Best Practice: Avoid using too many slices. When there are many categories or values are very similar, a sorted bar chart is generally easier to compare.

8. Scatter Plot in Tableau

A scatter plot displays individual data points using two numerical measures. One measure is placed on the horizontal axis and the other measure is placed on the vertical axis.

Scatter plots help identify relationships, clusters, patterns and unusual observations between two numerical variables.

Example: Sales and Profit Relationship

Suppose a company wants to understand whether higher sales are associated with higher profit. A scatter plot can display sales on the X-axis and profit on the Y-axis.

Steps to Create a Scatter Plot

  1. Open a worksheet with at least two numeric measures.
  2. Drag Sales to the Columns shelf.
  3. Drag Profit to the Rows shelf.
  4. Drag a record-level dimension, such as Customer Name or Order ID, to Detail if individual marks are required.
  5. Choose Circle from the Marks Card or use Show Me when the selected fields support a scatter plot.
  6. Use Color to distinguish groups, such as Region or Category.
  7. Use Size to represent an additional measure if appropriate.
  8. Optionally add a trend line from the Analytics pane.
Sales vs Profit Sales Profit
Illustrative scatter plot with an upward trend line.
Tip: A trend line can help summarize a relationship, but correlation does not automatically mean that one variable causes the other.

9. Histogram in Tableau

A histogram displays the distribution of numerical data by grouping values into intervals called bins. The height of each bar represents the number of records that fall within the corresponding interval.

Histograms are useful for understanding the distribution of values, such as customer ages, delivery times, product prices, examination scores and transaction amounts.

Important Histogram Concepts

  • Bins: Groups of numeric values within defined intervals.
  • Frequency: Number of records inside a bin.
  • Distribution: How values are spread across intervals.
  • Outliers: Values that are unusually far from the main distribution.

Steps to Create a Histogram

  1. Connect to a dataset containing a numerical field such as Customer Age.
  2. In the Data Pane, right-click the numerical measure.
  3. Select Create and then Bins.
  4. Set an appropriate bin size based on the data range and analysis requirement.
  5. Drag the generated bin field to Columns.
  6. Drag Number of Records or an appropriate record count measure to Rows.
  7. Use the Bar mark type if necessary.
  8. Review the bin size to ensure that the distribution is meaningful.
Customer Age Distribution 18-25 26-33 34-41 42-49 50-57 58-65 66-73 Age Groups (Bins)
Illustrative histogram showing the frequency of customers in age intervals.
Important: A histogram is different from a regular bar chart. A bar chart compares categories, while a histogram groups continuous numerical values into intervals.

10. Using Show Me to Create Charts

Show Me is a Tableau feature that provides chart recommendations based on the fields selected by the user. It helps users quickly identify possible visualizations without manually trying every mark type.

The available chart options depend on the selected fields and their data types. For example, a bar chart requires a suitable categorical field and a measure, while a scatter plot generally requires two numerical measures.

Steps to Use Show Me

  1. Open a Tableau worksheet.
  2. Locate the Data Pane.
  3. Select the fields required for the visualization.
  4. Open the Show Me panel in the worksheet.
  5. Review the available chart recommendations.
  6. Select a suitable chart type.
  7. Tableau creates the visualization if the selected fields meet its requirements.
  8. Customize the result using the Marks Card and shelves.

Common Show Me chart options

  • Text Tables
  • Bar Charts
  • Line Charts
  • Area Charts
  • Pie Charts
  • Scatter Plots
  • Histograms
  • Maps
  • Highlight Tables
Remember: Show Me is a recommendation tool. It does not replace the need to understand the purpose of a chart or the fields required to create it.

11. Understanding the Marks Card

The Marks Card controls the appearance and level of detail of marks in a Tableau visualization. A mark can represent a bar, line, circle, square, text label or another graphical element depending on the chart type.

Important Marks Card Options

Option Purpose Example
Color Changes the color of marks or separates categories visually. Different colors for product categories.
Size Controls the size of marks. Larger circles for higher sales.
Label Displays text or values directly on marks. Sales values on bars.
Detail Adds additional data-level detail without necessarily changing the visual encoding. Customer ID on a scatter plot.
Tooltip Controls the information displayed when hovering over a mark. Category, Sales and Profit.
Shape Changes the shape of marks where the mark type supports it. Different shapes for customer segments.
Marks Card Color Size Label Detail Tooltip
Marks Card options used to customize the appearance and information of chart marks.

12. Choosing the Right Chart Type

Selecting the correct chart type is important because different visualizations communicate different kinds of information. A chart should match the analytical question and the structure of the data.

Chart Type Best Used For Example
Bar Chart Comparing categories. Sales by Region.
Line Chart Showing trends over time. Monthly Revenue.
Area Chart Showing magnitude and changes over time. Sales Contribution Over Time.
Pie Chart Showing parts of a whole with a small number of categories. Market Share.
Scatter Plot Exploring relationships between two numeric measures. Sales vs Profit.
Histogram Understanding numerical distributions. Customer Age Distribution.
Highlight Table Comparing values using color intensity. Sales by Region and Category.
Text Table Displaying exact values in rows and columns. Category-wise Sales Summary.
Chart Selection Tip: Ask whether you need to compare categories, track changes over time, understand a distribution, explore relationships or show a percentage contribution. This makes chart selection easier.

13. Practical Example: Create a Sales Analysis Worksheet

In this practical exercise, we will use a sample sales dataset to create multiple charts in Tableau. The dataset should contain fields such as Order Date, Category, Region, Sales, Profit and Quantity.

Step 1: Connect to the Dataset

  1. Open Tableau Desktop or Tableau Public.
  2. Choose the appropriate data connector.
  3. Load the sales dataset.
  4. Review the fields in the Data Pane.
  5. Confirm that date, category and numeric fields have appropriate data types.

Step 2: Create Sales by Category

  1. Create a new worksheet.
  2. Drag Category to Columns.
  3. Drag Sales to Rows.
  4. Choose a bar chart.
  5. Add Sales to Label.
  6. Rename the worksheet to Sales by Category.

Step 3: Create Monthly Sales Trend

  1. Create another worksheet.
  2. Drag Order Date to Columns.
  3. Choose Month as the date level.
  4. Drag Sales to Rows.
  5. Choose a line chart.
  6. Rename the worksheet to Monthly Sales Trend.

Step 4: Create Sales and Profit Analysis

  1. Create a new worksheet.
  2. Drag Sales to Columns.
  3. Drag Profit to Rows.
  4. Add a suitable record-level dimension to Detail.
  5. Choose a scatter plot.
  6. Use Color to distinguish regions if needed.
  7. Rename the worksheet to Sales vs Profit.

Step 5: Review the Worksheets

After creating the charts, review titles, labels, legends, axes and tooltips. Ensure that each visualization answers a clear business question and does not contain unnecessary visual elements.

14. Common Mistakes While Creating Charts

Mistake Why It Is a Problem Recommended Practice
Using too many colors Makes the visualization difficult to understand. Use a consistent and meaningful color palette.
Choosing an unsuitable chart Can hide important patterns or comparisons. Select a chart based on the analytical question.
Adding too many labels Creates clutter and reduces readability. Display only important labels.
Ignoring date levels Can produce an incorrect or confusing time view. Choose the correct year, quarter, month or day level.
Using a pie chart for many categories Small slices are difficult to compare. Use a sorted bar chart when there are many categories.
Ignoring aggregation May lead to incorrect interpretation of totals or averages. Verify SUM, AVG, COUNT or other aggregations.
Using misleading axis scales Can exaggerate or hide differences. Review axis ranges and formatting.

15. Best Practices for Tableau Charts

  • Start with a clear analytical question.
  • Choose a chart that communicates the required information correctly.
  • Use meaningful worksheet names and descriptive titles.
  • Keep chart formatting consistent across worksheets.
  • Use colors to communicate useful information rather than decoration.
  • Format numbers, dates and percentages correctly.
  • Use tooltips to provide additional details without overcrowding the chart.
  • Check filters and aggregations before interpreting results.
  • Use appropriate labels and legends.
  • Review the visualization with the intended audience in mind.

Summary

Basic charts in Tableau help users transform raw data into meaningful visualizations that support analysis and decision-making. Bar charts are useful for comparing categories, line charts show trends over time, area charts communicate changes in magnitude, pie charts represent parts of a whole, scatter plots help explore relationships between numeric measures and histograms display numerical distributions. Tableau's Rows shelf, Columns shelf, Marks Card and Show Me panel make it easier to create and customize these visualizations. Selecting the correct chart, using appropriate dimensions and measures, and following visualization best practices helps create clear and effective analytical reports.