Advanced Tableau Charts

---

1. Lollipop Chart

Map visualization

Lollipop ChartLollipop charts are a visually interesting twist on bar charts, adding circles at the ends to highlight specific data points. 

Connect your data:  simple tabular data manually created, using a web search of the top 10 Grossing Billie Eilish songs.

Lollipop charts are a visually interesting twist on bar charts, adding circles at the ends to highlight specific data points.

Connect your data:  Start by connecting your dataset to Tableau.

Lollipop charts are a visually interesting twist on bar charts, adding circles at the ends to highlight specific data points. Here's a breakdown on how to create them in Tableau:

Add Measure: Drag the measure you want to represent on the Y-axis (numerical) to Columns. This could be sales figures, customer count, etc.

Simple Bar Chart: By default, Tableau will create a bar chart. This is the base for your lollipop chart.

Creating the Lollipop Effect:

Duplicate the Measure:  Hold down Ctrl and drag the measure you placed on Columns onto the Columns shelf again. This creates a duplicate.

Dual Axis: Right-click on the second measure (the duplicate) and select "Dual Axis." This creates a separate axis for the duplicated measure.

Synchronize Axes (Optional):  Right-click on the top axis (for the duplicated measure) and choose "Synchronize Axis." This ensures both axes have the same scale for better comparison.

Shaping the Lollipops:

Adjust Bar Size (First Measure):  On the Marks card for the first measure (the original bar chart), change the mark type to "Bar." Reduce the size of the bars using the "Size" option in the Marks card. This creates thin lines, forming the lollipop stems.

Circle for Lollipop Head (Second Measure):  On the Marks card for the second measure (the duplicated one), change the mark type to "Circle." This creates the lollipop heads at the end of the stems. You can adjust the circle size using "Size" in the Marks card.

Customizing the Lollipop Chart:

Coloring:  You can use color to differentiate between data points. Go to the Color option in the Marks card for either the circles or the bars (or both) and choose a color scheme.

Hiding Axis Headers:  Right-click on the axis for the duplicated measure and choose "Hide Header." This removes the duplicate axis, leaving a clean single axis for both the bars and circles.

Formatting:  You can further customize your chart by adding labels, formatting axes, and including a title.

Dashboard: Add an image of a black background and insert images, quotes,awards, and recognition of Billie Eilish and insert the chart along with it.

2. Map Visualisation

• Data is Obtained from IEEE Data port: An OTDR dataset for optical fiber monitoring | IEEE DataPort (ieee-dataport.org)

• Open Access:  data in IEEE DataPort is openly available (https://ieee-dataport.org/). This means you can access and use the data freely for any purpose, including personal projects.

• Given Data Include:

• Latitude (Number)

• Longitude (Number)

• Cable Name (Optional: String) for coloring or labeling (can be adjusted later)

Here's how to create a map visualization in the black and yellow theme of optical cables through the ocean in Tableau with a checkbox filter at the end:

Data Preparation:

• You'll need data containing the geographic locations (latitude and longitude) of the optical cables. Ensure your data includes:

Latitude (Number)

Longitude (Number)

Cable Name (Optional: String) for coloring or labeling (can be adjusted later)

Connecting to Data:

Connect your data source to Tableau.

Building the Map:

Drag the "Latitude" field to Rows and the "Longitude" field to Columns on the Marks card. Tableau will automatically create a geographic map.

Black and Yellow Theme:

Go to the Marks card and click on the "Color" mark.

Choose "Map Background" and set the color to black.

Click on the "Color" mark again and select "Foreground" (or "Lines"). Here, set the color to yellow.

This creates a black base map with yellow lines representing the optical cables.

Cable Paths :

If your data has cable names, drag "Cable Name" to Detail on the Marks card. This will display individual cable paths with labels (depending on data density). You can adjust label placement and other visual elements in the Marks card.

Checkbox Filter:

Drag a dimension field (e.g., "Cable Name") to the Filters shelf.

Change the filter type to "Regular" to display a list of all cable names.

Tableau will automatically convert the filter to a checkbox list by default. You can deselect irrelevant cables to filter the map view.

Aesthetics:

Base Map Options:  Tableau offers different base map options. You can experiment with "Light Gray Canvas" or "World Countries" under the Marks card > Background Maps.

Tooltips:  Add tooltips to display detailed information about the cables when hovering over the lines on the map. Drag the desired fields (e.g., "Cable Name") to Tooltip on the Marks card.

Zooming and Scrolling:  The map visualization will allow zooming and panning to explore specific regions.