Course Content
Tableau Fundamentals
Tableau Fundamentals
1. Introduction to Tableau
2. Tools in Tableau
Dimensions and MeasuresChallenge: Comparing Sales and Profit by StateContinuous and Discrete FieldsChallenge: Identifying the Month with Lowest SalesDimension Filters Measure FiltersChallenge: Finding the Most Profitable Customer in ArtCalculated FieldsChallenge: Comparing California and New York to Other StatesInteractive Dashboards with ParametersChallenge: Finding the Sub-Category with the Most SalesWorking with Sets Challenge: Analyzing Bookcase Profit ConcentrationSets Applications
3. Basic Visualizations
Visualizing Data with HeatmapsChallenge: Identifying Top-Selling Sub-Category by RegionScatter PlotsChallenge: Determining the Highest Sales and Profit by StateTreemapsChallenge: Analyzing the Least Profitable Sub-CategoryCombination ChartsChallenge: Comparing Sales and Profit Trends for PhonesSparklines
Challenge: Analyzing Profit Changes Between 2016 and 2017
Your task is to create a bullet graph to compare the Profit from 2016 and 2017 across different categories.
- Drag the "Sub-Category" field to the Rows Shelf.
- Drag the "2017s Profit" field (created in the previous chapter) to the Columns Shelf.
- Drag the "2016s Profit" field to the Marks area and place it under "Detail".
- Add a Reference Line:
- Set the Value to "2016s Profit";
- Set the Aggregation to "Total, Per Cell".
- Customize the Reference Line by adjusting the color and transparency to make it more visible.
- Review the chart to identify categories with negative "2017s Profit" but positive "2016s Profit".
Everything was clear?
Thanks for your feedback!
Section 4. Chapter 2
