Understanding Green and Blue Pills in Tableau

In this video, we delve into the difference between green and blue pills in Tableau. These pills represent categorical variables (dimensions) and numerical variables (measures), respectively. Utilizing the sample Superstore dataset, we explore how to import data into Tableau, distinguish between the two types of pills, and understand cases where a field can act as both. By the end of the video, viewers will gain clarity on how these pills function and their significance in data visualization.

What will you learn

• How to differentiate between green and blue pills in Tableau.
• The types of data represented by each pill.
• How to import data into Tableau and identify fields.
• Practical examples of using dimensions and measures.
• Understanding when and how a field can be both green and blue.

Takeaway notes

• Blue Pills (Dimensions): Represent categorical data that segments the data view, such as categories or names.
• Green Pills (Measures): Reflect numerical data used for aggregation and are often displayed as continuous fields.
• Field List Organization: The data tab in Tableau helps categorize fields into dimensions (top) and measures (bottom).
• Dual Nature Fields: Some fields like dates can serve both as dimensions (categorical) and measures (numerical), dependent on the level of granularity chosen.

Practice questions

1. Describe the difference between a green pill and a blue pill in Tableau.
2. Explain the significance of placing a dimension on the rows or columns shelf.
3. What happens when you drag a measure onto the columns shelf in Tableau? Provide an example.
4. How can a date field act as both a blue pill and a green pill? Demonstrate with an example.
5. List two primary characteristics of dimensions in Tableau.
6. List two primary characteristics of measures in Tableau.
7. In a given dataset, how would you identify if a field is a dimension or a measure?
8. What visualization type is automatically generated when a categorical variable is combined with a numerical variable?
9. Discuss the role and importance of the data tab in Tableau.
10. Why might you want to convert a blue pill to a green pill? Provide a scenario.
11. Give an example of a textual field that can only be used as a dimension.
12. Illustrate how you can change the view granularity of a date field in Tableau.
13. What would be the impact of miscategorizing a measure as a dimension in your visualization?
14. How do green pills behave differently from blue pills when used in filters?
15. Create a simple bar chart in Tableau with one dimension and one measure. Explain the steps.