← Previous lessonFree lesson 6 of 9 · lesson 52 of 123Next lesson →

Unlock all 123 lessons of Medical Data Analytics & VisualizationFull course ₹40,000 · paid

Price & syllabus
Free lesson · 29 min · no payment

Tableau Data Pane, Show Me Charts and Marks Card

A free lesson from Skill-Lync's Medical Data Analytics & Visualization course, on Grow by Skill-Lync · Last updated 16 Nov 2026 · Session: “Module 14 Session 1 - Shelves, Cards, and Analytics Pane”

What will you learn in this free Medical Data Analytics & Visualization lesson?

Using the Sample Superstore Orders data, the instructor explains the Data and Analytics tabs and the live and extract icons. The lesson then covers Show Me quick visualizations, the Marks card, and builds a lollipop-style chart by combining a bar and a circle with a synchronized axis.

  • Reading the data pane and source icons
  • Choosing charts with the Show Me tab
  • Marks card size and color properties
  • Building a lollipop chart with synchronized axes

What comes after lesson 52?

The next free lesson is lesson 97, “What Business Intelligence Is and How BI Platforms Compare” (12 min). Later in Skill-Lync's Medical Data Analytics & Visualization course (paid): lesson 53, Module 14 Session 2 Part 1 - Shelves, Cards, and Analytics Pane; lesson 54, Module 14 Session 2 Part 2 - Shelves, Cards, and Analytics Pane; lesson 55, Module 14 Session 3 - Shelves, Cards, and Analytics Pane. The full course has 123 lessons (54 h 21 min of video); see the course overview or its price and syllabus.

Lesson transcript

Machine transcript of the lesson audio (lightly cleaned). Technical terms may contain errors; the video is the reference.

Welcome to the course Data Analysis and Business Intelligence with Tableau Week 2. The table of contents for this week are Introduction to the Data Pane, Quick Visualizations, Marks and its Properties, Pages Shelf, Menu and Toolbar, and Analytics Pane. Let's rewind the last week's topic before moving into this week's session. We discussed about what is Tableau and how to install Tableau Desktop, products available in Tableau and a brief discussion on the roles available, how Tableau works and its functionality when compared to a PPT, data sources and different types of data sources available in Tableau.

We saw how to connect to an Excel data source, what data sources are available to connect to on cloud. We discussed about Live Connections vs. Extract Connections and when to use what. And finally, Saving Your Work. In this week, we will learn about the Data tab, Quick Visualizations available in Tableau, Marks Pane and its Options, Pages Shelf but Time Series Graphs, Menu and Toolbar, Analytics Pane and the Options available in Analytics Pane. So, moving on to the first topic, Introduction to the Data Pane. After connecting the Excel sheet like we did last week, you can see the working sheet when you click on that sheet on your down part of your tab.

You can see two tabs, Data and Analytics in the left side corner, top corner. And under that, you can see a data source, whatever connected data source available over there. In this case, we have connected to an Excel sheet and the sheet name is Orders. So, the data source is coming up as Orders from the Sample Superstore data. If a single cylinder is there, it represents the live connection. And if it is a double cylinder, it is an extracted connection. You can also check on right-clicking on the data source.

If the extract is checked over there, that is an extracted version. If the extract mark is not checked, that is a live connection. If you have saved your work last week by extracting the data, you will be seeing a double cylinder icon over there with a check mark on your extract option. Whenever we connect to multiple data sources or even multiple sheets in an Excel sheet, you will be seeing multiple data sources in here. If you have like two or three more data sources connected for your workbook, all the data sources will be displayed here.

Quick Visualizations. What are Quick Visualizations available in Tableau? It is naturally called Show Me because the tab named is actually Show Me in Tableau. In this Show Me, you will see all the graphs available for Quick Visualizations. If you just hover on the Quick Visualization on any graph, it will prompt to add dimensions and measures suited for that particular WISP. In this particular example, this is hovered over stacked bars and it is asking us to add one more dimension or one more measure. You can toggle between the wizards if you want to look at your data in a different perspective.

While the type of data being presented often describes the type of chart being used, knowing how to create each of these common chart types will give you greater flexibility in what you can create in Tableau. And it can also make you a better visualization expert. Now, we will see the live demo of these visualizations in Tableau. Moving on to our tool, I am just connecting to the Excel sheet again. Tableau will load the data from the Excel sheet into Tableau. I am pulling on all the data from our practice file.

So, it will show all the rows and columns available in our practice file and I am going to the sheet. This is the sheet you will be seeing whenever you connect the Excel sheet and whenever you are moving from the data source to the main page. This is where you build all your visualizations. As we discussed, this is the data pane and this is the analytics pane. These are two tab-like versions and you can see your data source file connected over here. In this case, I am connected to the Excel sheet and I have pulled the full data sheet into our Tableau desktop.

So, you can see the full data coming up over here. This is just the name and you can rename it into whatever the file name you want it to. And I am only seeing a single cylinder icon here. It states that my connection is a live connection. If you just go in here, right click and see these options. The use extract button check mark did not come here. If you have an extracted version, you will be seeing a blue check mark over here saying that the Tableau workbook is actually using the extracted version of the sheet.

Whatever data is present in your Excel sheet will pop up here. All the columns and rows will be coming up here. You will see the column names in here in blue and green. Next, going to the quick visualizations, you can see this show me tab over here in the right corner. And if you hover on each visualization, it will pop up what dimension and what measure you need to keep it over here. And how many measures or how many dimensions the graph actually needs to create a visualization.

Right now it is all grayed out because our view doesn't have any columns or rows present on the sheet. So if I drag, I'm just going with a line chart here. And if I want to create a line chart, I need a dimension and a measure. Double clicking on the dimension will throw that column onto our sheet or else you can simply drag whatever column you need into the rows and columns. Right now we are seeing a bar chart, but I just want to create a line chart from here.

So line drafts help display changes over a period. Use them to view and predict various trends and patterns for your business. So some common values and data points include sales, profits, customer numbers, subscribers and rates. You can plot a single value or several in the same line chart. If we are going with a line chart, it is always best to view it in a date format to predict the changes in a set of time. So now all of the views came up because we have enough dimensions and measures present on our view.

I'm just clicking on the line chart. See, Cablo automatically picked up whatever it needed for a line chart. It threw category into the color because category is not needed on the rows and columns. So it picked up the measures onto the rows and columns, the order date onto the column and the profit onto the row. If you see here, it is displaying the years on here and each category is colored for each line. And if you want to display the labels, you can click on show mark labels, which will display the numbers over there.

So this is a basic line chart what we created. And we can also add some annotations to our visualization to call out a specific mark or a specific point such as location on a map or an area such as cluster of scatter marks. We have like three types of annotations in Tableau. One is mark, the other one is point and the other one is area. To select this option, to select the mark option to add an annotation that is associated with the selected mark. This option is only available if a data point or mark is selected.

Let's see how we are going to add an annotation called mark to our visualization. So just right click on the number, whatever number you wanted to add an annotation on. In this part, I just want to add an annotation on 2015 category office supplies, which is low. It is like 25,100. I want to point out saying that, okay, in this point of time, we are actually low. And I'll just right click on that point, go to annotate and click on mark. So this will appear for us to add a mark onto our visualization.

You can actually edit this box to show your annotation in a particular view. I just want to write in this year, our sales are low as. You can write any point you need to point out that point saying that, okay, here is where you have to concentrate on. And this is how we add a mark onto our visualization. And we have two more options to add into our visualization. Let's say we want to add a point onto our visualization. Point is an annotate to add a specific point onto your view.

I'm just going to add a point on 2016 furniture value. Right click on it. Annotate. Point. So the same text box will appear over here, but the look and feel will be different whenever you write and click on OK. So I'm just saying here in the year we had a profit of this much. OK. So. If you see the difference between this Mark and Point option, you can move them to any point and you can highlight it. Mark will come like a box. I mean, to particularly point, both will look the same and they'll look wise and feel, but point annotations are used to point out the reference lines or a value on an axis.

And Mark annotation is only available when you just point it out to a specific point. And this one, you can actually point out to a reference line as well. And we have one more annotation called Area annotation. In this area annotation, you can actually select a particular set of area and describe the area in this kind of box. To create an area selection, this is also the same process. You just have to right-click on whatever area you want and you can annotate saying it as an area.

If you see here, I just right-clicked on the random space on my view and the Mark card is not applicable in this point because we did not point it out onto a specific data. You can also format this annotation by right-clicking on the box and you can say format. You will be displayed the options available to format this box. You just want to display the box in four-sided and a single edge or you can give a shading to it. You can give the borders. You can just say the corners should be round, square or very rounded like that.

And you can also display the point, the line color and also the way the line looks and what is the ending of the line should look like. Is it an arrow or open arrow? And you can also control the end size of the arrow. If you want to remove any kind of annotations on your views, you just have to right-click on it and click on Remove. It will be gone from your view. So, our next topic is how to create a bar chart. Bar charts are great because they are like totally simple and you can simply compare data with different categories.

If it is vertical or if it is horizontal, you can simply compare the categories. They create an easy to comprehend visual representation of your key data. The size of the bar columns represents the data values. So, to create a bar graph, if you hover on the bar graph, it is asking for a dimension and it is asking for a measure. Let's drag category onto our rows and sales onto our columns. So, this is the basic bar graph we will get when you drag category into the rows or a dimension into your rows or measure into your columns.

This is the horizontal bar graph and you can actually flip into your vertical bar graph by simply clicking on flipping the rows and columns, vice versa. This is how you see vertical bar graph. By simply clicking on the show mark labels, you will see the data and you can easily compare the difference between furniture and office. Next, I will be creating a lollipop chart from this bar chart. Lollipop charts compares categorical data. They use circles, bars, mimicking the appearance of a candy lollipop. These lines work like the columns in a bar chart measuring scale.

Add color to your circles to better demonstrate magnitude or category. So, to create a lollipop chart, we need to talk about the dual axis. What is dual axis? Dual axis is placing two measures in the rows or columns. Let's say I'm placing the sales again onto my rows. For now, I'm just switching off my mark labels. So, now I have two measures saying that my sales is like this. I'm swapping them again to horizontal to create a lollipop chart. So, I have two axis now. One is for sales and one is also for sales.

And the second axis, I will be changing this bar graph to a circle. And to create a dual axis, I need to right click on my column sales and click on the dual axis over here. Right now, the dual axis will merge both my measures into one. Let's say I have sales on both measures as sales. That's why they actually overlapped over here. So, what I will do is I will change one of my sales mark card to a bar. And I will leave the other as a circle because I'm creating a lollipop kind of bar chart to actually adjust it to look like a lollipop.

So, I'm adjusting the size of my bar graph to show them like line. And the other one, I'm just adjusting it according to the line we created right now. And the round circle will look like a lollipop. Click on the entire view. The size has to adjust according to the line graph. So, yeah. You can actually adjust this line to whatever width you want and this circle to whatever width you want to look at more like a candy lollipop. And just for to our visual representation, I'm adding category into the color.

So, all these three lines will come up in different colors. And what we need to do for the last step is we need to synchronize the axis to actually adjust the axis of this sales and this sales. I'm just synchronizing axis by right clicking on my axis over here and click on synchronize axis. What synchronize axis will do is it will actually sync this whatever number we are getting in one axis to the other axis. As previously, it was looking like 900k over here and 850k over here.

It actually synced this axis to this axis because we have two measures over here. This one will create one axis and this one will create axis. What we did right now is we synced this two axis. So, these numbers will not misalign when you do a dual axis over here. Now, you can simply display labels in only one axis because displaying the labels in both the axis, they will overlap and the number will not come up right. See, displaying the axis for one, let's say for the circle one, displayed it over here.

And this is called a lollipop chart. And we talked about dual axis and syncing those dual axis for a lollipop chart. Moving on to the other charts. The next chart we are going to talk about is a pie chart, which is basic for most of the percentages, ratios, and proportions. Pie charts are suitable for displaying this type of data when you have a few values. We suggest using them with two or three categories at most in a single chart. You divide the pie chart into slices that represent each value as a part of whole.

That means, your each angle will be represented a division of a hundred. Like, your whole circle will be hundred. If you display a pie chart, each angle will be displayed into a certain percentage. If you don't know what to keep for a pie chart, you just click on whatever columns you want you to see in a pie chart. And if you're not sure what you want to see, just click on the columns, dimensions, and measures. And if you click on pie chart over here, Tableau will automatically make into your pie chart.

Click on the entire view and you can see the whole round into your whole page. And you can even display the labels over here. So, we display the numbers for each angle on category-wise. We have three categories. And for each category, a number is displayed. As we drag the sum of sales into a view, each category is displayed as for sum of sales. And the angle is actually adjusted according to the value. So, the category has only three values. So, the pie chart is looking beautiful.

And it is only displaying three colors. But if you have like too many values in your column, let's say you have a state over here in the color. Because we have too many states, the states will be displayed like this. And the pie chart is not a good looking graph for this requirement. Because state has too many values inside it and all the angles and colors will be overlapped. And whenever you display like this, most of the values will be hiding at the back of each value.

And they won't be displayed it right. So, it is always necessary. For a pie chart, you need to pick up a column which has less values. Let's say category or a subcategory. Category is the best in this part of data set because it has only three values inside it. We already spoke about the dual axis part. So, I am going to describe how we are making a donut chart out of a pie chart. I am creating an axis for the pie chart. So, I am using a minimum value of 1.

So, this will display one card for me. And I am creating one more. Let's say we have got two axes right now. And in one of my axes. When I start, I'll be removing everything over here. So I'll get a blank circle. I'm making this circle white. So the color of the circle will be white. It is not gone away, but if I change the color to white, so it is not displayed over here, but we still have a circle over here. And for my first circle, I'll be increasing my size a bit.

So right now, we have to make it into dual axis. So what happens is the axis will merge and the second circle will be overlapped on the first circle. Right now, my white circle is actually overlapped onto the category circle because for my next marks, I did not have any values over here. This is completely coming as white. And the second one, I have category and sum of sales. So this one will be displayed and you can actually adjust this white circle into whatever size you want to make it look like a donut. I just prefer making the white circle a little bit more so it actually looks like a donut. And you can switch off the labels for the second marks card so that one will be gone in your middle circle and the values will be displayed.

On the outer circle. To actually sync this axis, I'm right clicking on the axis and click on the synchronize axis. As I have the same value over here, one and one, synchronizing axis is not needed, but whenever you're using two different measures from here, it's always better to synchronize axis to align them equally. And this is how we make a donut chart. Let's move on to the other maps. The next graph we will be seeing is a map and maps can be used for two purposes to give users a visual way to see divisions in company structures or regions to display measures like a heat map showing areas of high or low performance.

Tableau comes with several built-in mapping capabilities to let you design simple maps. You need to have this location data in your dataset. For creating a map, you have to create a geographical field onto your view. Let's say I'm creating a map for the state. So say state is actually a data type for the geographical content. By double clicking on the state, what Tableau will do is it will automatically understand that it is a geographical field. And it will automatically created the longitude and latitude for your view and your state details will be gone into the detail mark. So if you just drag your state into the color rather than into the detail, it will actually mark all the states into different colors.

Right now we don't have any measure values. Right now we don't have any measure value. That's why it is not showing us any measures or the lower or higher in sales in any of the region. So we need to add some of the measures into your view. So I will be adding the sales into the color rather than the state and I will be adding the state into the detail. So my graph will be like this. All the sales will be shown into different colors. Tableau will automatically recognize that it is value. So the first value starts from 920 and this color palette will be allocated from the lower range to the higher range. If you want to change the color palette, you can click on this arrow mark and you can edit the colors to whatever color you want.

So the whole map will change into whatever color you selected and you can display the labels. Right now it is only displaying the sales labels. We can also display the state labels by dragging the state into our labels and also sales into the labels. So we will be seeing for each state what are our sales and is it in green or is it in yellow or is it in light yellow based upon the differentiation of the color. However, you can easily differentiate which state is performing well. So this is how you will be building a map view onto the Tableau.

Moving on to the other charts we have in Tableau. We have a text chart and we have a heat map and we have a highlight table. These three maps are totally related to the text content. Whenever you wanted to display it in the form of tables, you can actually select it as a text or a heat map or highlight table map. So through tables aren't technically charts. They remain popular. That's likely because of the user's familiarity with our Excel sheets. We suggest that each time you create a visual, you start with a table before converting it into a chart. This will help you ensure that your numbers and calculating calculations are feeding through accurately. If you want to create a table chart, just select a category and sales by just double clicking on it. Tableau will automatically arrange it in the format of a table. And if you want to change it to other tables, it is a heat map.

If you show the labels, the labels will be on over here and this is how your heat map will look like. How to adjust the labels to come up in the middle so that the heat map will be adjusting according to our values. Heat map is actually preferred when you have so many values. And if you want to highlight a table according to the color, that means which category is actually performing well, that will be categorized according to the color. For this tables, it is always best to use so many dimensions into your data because it will be displaying each dimension separately based upon the color.

If you see in the technology, the consumer is performing well. In the office supplies, the consumer is performing as well. In the furniture as well. In this case, if you want to look at other column which has too much of data, you can just click on it and you can see which one is actually performing well. See the product name, we have so many product names in the data. And if you want to look at what product is actually performing high, you can see this color coding easily. Light blue is for the medium range. If you see Apple iPhone 5 is actually performing well. And if you see Canon image product is bringing up so much of sales, you can easily pick up it based upon the color content.

We also have some other graphs and we have a circle view side by side circle view. And we have scatter plots. Scatter plots are good at comparing data points across two variables. Additional color or size can be added to each point to help identify different patterns. Scatter plots are mostly used as four segments to categorize good, bad, very good or the best like that. It will divide your visualization into four segments and all the four segments are categorized differently. We will talk about tree maps. We will talk about tree maps a bit. Tree maps are a great way to visualize the relative importance of category within a whole. For this reason, they can be useful as interactive slicers, but are less good at comparing values between categories.

Let's say if you want to categorize the product name based upon sales. Like we saw in this table, a heat map is best for this view because it will pick up the highest sales product into the first part. That means it is also coming in a color coded version, but you can see the highest sold product into the start. If you put the same visualization into a heat map. Heat map. Heat map will be like this. Giving a color code for each value and you can pick up based upon the size of the content and also the color coding.

We do have different other charts in Tableau. We will be discussing about all the charts in the coming topics, but this is all about our quick visualization tab. And if you are in confusion to select what type of graph you want and what are the dimensions and measures you need to select for that graph, you can simply click or double click on each column over here and you can toggle between the graphs available for that dimension and measure. It will display whatever is needed more for that particular kind of visualization if you hover on that graph. This is all about quick visualization.

As you can see, the graph is not as easy as six or nine or 10 times as it is. Here we are looking at this graph, we have a certain number of graph. There is a graph test. You can go to the graph test.

Want the rest of Medical Data Analytics & Visualization?

Get the full course syllabus and fees.

The full course is paid (₹40,000). We'll send the syllabus and call you back within one working day.

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.

Full course · paid

Unlock the full Medical Data Analytics & Visualization course

The remaining 114 lessons, mentor-reviewed projects and a certificate come with the paid course (₹40,000). Leave your details: we'll send the syllabus and fees and call you back.

Get the syllabus and fees

A counsellor calls you back within one working day.

By submitting you agree to our Terms and Privacy Policy.

Grow by Skill-Lync · free lesson

Start watching

Free, no payment. Leave your details once and every free lesson on Grow plays straight away. A Skill-Lync counsellor may call you about the full Medical Data Analytics & Visualization course.

By submitting you agree to our Terms and Privacy Policy.

Talk to a career counsellor

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.