Tuesday, 25 August 2020

Tableau Certification Quiz


Gartner Report

In today's age of incredible growth, market evolution, and increased customer expectations, Tableau has scaled to meet the needs of the data-driven enterprise with insightful innovation and platform expansion. The Gartner report of 2020 recognizes Tableau as a prominent Leader and Visionary in the field of Data Analytics. Tableau offers a powerful, secure, and flexible end-to-end analytics platform. And customers today are deploying Tableau faster and more broadly than ever. With 'Ask Data', use natural language to explore your data in Tableau. Use AI-powered statistical analysis to decipher the “why” behind unexpected values.

Purpose of the Exams

Are you interested in learning Tableau? Are you pursuing a career move? Are you planning to migrate reports in your organization? Are you aspiring for a Tableau Certification? Are you seeking to crack a Tableau Interview? In all the cases, our curated collection of questionnaires by Certified Tableau Professionals is the perfect fit for you.

Let's Begin

Learn more on the Tableau Desktop Specialist Certification to master essential Tableau skills. Challenge yourself with the coveted Tableau Desktop Certified Associate Certification to demonstrate your proficiency in Tableau. Answer the latest Top Tableau Interview Questions as of to refresh yourself. Our questions span from Connecting Data, Analyzing Data, creating Calculations, developing Insightful Dashboards, critical Tableau Concepts, the latest Job Interview Questions, and more. The below test will give you a glimpse of what we have in store for you. Score 70% from 10 questions in 20 minutes to pass the exam. The Datasets for the Exam are available in the Menu above. To fetch a new set of questions, hit the 'Refresh' button and wait a few seconds.


Buy Practice Exam

We provide unlimited opportunity for you to learn and practice Tableau, for free. However, there is a limit to the number of attempts in our free tests. We are glad to present you with flexible plans to access more of our contents. Each attempt brings with it 10 Premium questions, from all Tableau categories like Dashboards, Level of Detail Calculations, Order of Operations, Blends, Joins, Sets, Groups, Chart Types, and more.








   ✍   Every question above have been delicately crafted by our Certified Tableau Professionals to maximize the assessment potential of related concepts. The Datasets for the questions are available in the Menu above.

   ✍   Discover the latest trends in the industry and job market with the included Tableau Interview Questions in each attempt. Experience actual problems and practice hands-on to enhance your skills on key topics.

   ✍   Improve your skills with Unique Set of Questions in each attempt. Challenge yourself with questions chosen randomly from a vast pool of 1000+ Conceptual and Practical problems using our Vision algorithm.

   ✍   Expect these questions in any of the Tableau Certification Exams and Tableau Interviews you are preparing for in . Learn from the freshest insightful questions built on the latest Tableau versions.


Tableau Desktop Specialist Certification

   ✍   The Tableau Desktop Specialist Certification costs $100 and there is no eligibility criterion. This test evaluates essential skills of using Tableau Desktop and your ability to use all the analytical functionalities of the tool. Our recommended hands-on Tableau experience before you attempt this test is 12-16 weeks.

   ✍   You can predict your performance by checking your score in the Tableau Desktop Specialist Practice Exam. You have to score 70% from 30 multiple-choice questions in 60 minutes to get the certificate. The Tableau Desktop Specialist Certificate does not expire. To schedule the exam with Tableau when you are ready, choose 'Schedule Exam' from the References Menu above.

Tableau Desktop Certified Associate Certification

   ✍   The Tableau Desktop Certified Associate Certification costs $250 and there is no eligibility criterion. This test assesses advanced knowledge of using Tableau Desktop using Level of Detail Expressions, Order of Operations, and more. Our recommended hands-on Tableau experience before you attempt this test is 20-24 weeks.

   ✍   To predict your performance in the actual exam take our Tableau Desktop Certified Associate Practice Exam. You have to score 75% from 36 multiple-choice questions in 120 minutes to get the certificate. The Tableau Certified Associate Certification has a validity period of 2 years. Tableau offers 40% discount on renewal of the Certificate, so you will pay $150 instead of $250 for the Tableau Certified Associate Certification renewal. To schedule the exam with Tableau when you are ready, choose 'Schedule Exam' from the References Menu above.


How to Create a Rounded Bar Chart?

Rounded Bar Charts often help design a bar chart in an aesthetic way. To blend in to a smooth view for our customized visualization this technique can be leveraged. Bars continue to be a robust tool to compare values of categorical data, however with the curved endings we might encounter precision issues. We need to be careful of scenarios where the bar curves might extend it's endings below the minimum value, or above the maximum value. The steps below walk us through how to create a Rounded Bar Chart.

How to Create a Lollipop Chart?

Lollipop Charts offer a visual alternative to side-by-side bar chart, or a Gantt chart. It is basically a bar plot, where the bar is transformed in a line and a dot. A Lollipop Chart shows the relationship between a numeric and a categoric variable. The main advantage of a Lollipop Chart is it is much less cluttered as compared to a standard bar chart. Thus effectively we avoid a Moiré effect, which is a visual perception when viewing a set of lines or dots that is superimposed on another set of lines or dots. The presentation below shows how to create a Lollipop Chart.

How to Create a Barbell Chart?

Barbell Charts or Dumbbell Dot Plots illustrates the change between two or more data points. It is a composite chart with circles and lines, and exceptionally effective in illustrating changes or distance between groups of data points. The Barbell Chart compares categorical data, and uses circles to highlight values, and bars to measure the gap. The Barbell chart is also known as DNA chart, Gap chart, Dumbbell chart, and Connected Dot Plot. Below we can see the steps on how to create a Dumbbell Chart.

How to Create a Bar in Bar Chart?

Bar in Bar Charts stack one bar over another bar. The bars are customized with unique colors, and unique width, so that they are distinguishable from each other. Bar in Bar charts are useful for comparing measures for different periods, or showing progress towards a goal, when both bars have the same starting point. The steps to create a Bar in Bar chart are as below.

How to Create a Stacked Bar Chart?

Stacked Bar Charts allow comparison of components across categories. They are used to show how a larger category is divided into smaller sub-categories, and what the relationship of each part has on the total amount. Stacked Bar Charts help easily identify which series contributes for making one total bigger or smaller than another, compare Sales of USA Regions for a Store. However for bars far away from the axis, it becomes visually complex to compare their sizes.    ✍   A Stacked Bar Chart can be of 2 types, the Simple Stacked Bar Chart displays the full value of the bar with the corresponding Segment Values, whereas a 100% Stacked Bar Chart shows the percentage of every Segment in relation to the whole value. We can find the steps on how to create a Stacked Bar chart of both types below.

   ✍   Another approach to create a Stacked Bar Chart is demonstrated below. It is helpful when we want to display multiple measures contributing to individual members of a dimension. This approach can then be further modified to have a Simple or 100% Stacked Bar Chart like above. The steps to create such a Stacked Bar Chart with few selected measures are walked through below.

How to Create a Radial Bar Chart?

Radial Bar Charts allows us to create attractive visualization designs. The bars are displayed on a Polar coordinate system instead of a Cartesian system. In a Radial Bar Chart, the lengths of the bars cannot be used to compare values, as the bars on the outside will be longer than the bars inside for the same value. Radial Bar Charts can be used in a variety of scenarios to derive insights from data.

How to Create a Radial Column Chart?

Radial Column Charts are a variation of the standard vertical column charts. The bars are projected outwards from the center in this chart type. The heights of the different bars help determine outliers and provides details for comparative study. This chart type is difficult to read if the number of members increases or the data values are close to each other. Radial Column Chart can help create stunning visuals.

How to Create a Doughnut Chart?

Doughnut Charts are an alternate version of Pie Charts with a hole in the center. It helps to measure part to whole relationship. A Doughnut Chart offers improved readability by allowing the user to focus on the length of the arc of a slice, instead of the size of the slice like in a Pie Chart. The space inside the hole is often efficiently used for labelling the data and adding useful metadata. We can even display two or more sets of data by showing two rings instead of one, each ring with its own number of slices.

How to Create a Pareto Chart?

Pareto Charts help identify the vital (20%) inputs producing the maximum (80%) results. It effectively displays the inputs in order of importance. Vilfredo Pareto (1848 - 1923), noticed that 20% of the pea pods in his garden were responsible for 80% of the peas. Pareto expanded this principle to macroeconomics by showing that 80% of the wealth in Italy was owned by 20% of the population. The 80-20 rule, also known as the Pareto principle, was introduced in 1906.
   ✍   Above we saw how the % of Total Sales and % of Product Count are closely following the 80-20 rule. Now we will complete the Pareto Chart by adding the Sales of each Product Sub-Category in descending order to identify the members driving the highest Sales.

How to Create a Gauge Chart?

Gauge Charts are similar to Pie Charts, with the addition of a needle to indicate the data value. Gauge Charts help depict the change of a linear progressive value, or the change of different entities over a common parameter. Gauge Charts are widey used to illustrate Key Performance Indicators across all industry domains. The steps to create a Gauge Chart are detailed as below.

How to Create a Thermometer Chart?

Thermometer Charts help visualize the actual value of a measure as compared to a target value. The amount of completion can be easily deciphered by looking at the chart without even going into the details. A Thermometer Chart is very stylish and has an impactful presence in any dashboard. The chart is commonly expressed as a percentage of the whole, with a darker color representing the progress on a lighter colored space yet to be filled up.

How to Create a Span Chart?

Span Charts instantly reflect the difference between the values of two data points. The difference is either between the maximum value and minimum value of the same category, or between the values from two distinct categories. The endings of the Span chart are often formatted for appealing chart designs. A Span Chart is also known as Floating Bar Chart, Difference Chart, High-Low Chart, Range Bar Chart, etc. It creates space for adding more useful details by eliminating the bases of the chart.

How to Create a Waterfall Chart?

Waterfall Charts are a form of data visualization that help in understanding the cumulative effect of sequentially introduced positive or negative values. These intermediate values can either be time based or category based, and helps understand the flow how one balance moved to another balance. The Waterfall Chart is also known as Flying Bricks chart or Mario chart. Often in finance, it will be referred to as a Bridge Chart.


We are passionate fans of Tableau, so we are excited to share with you our favorite collection of top tips and tricks in Tableau. Here is a collection of amazing techniques that you will find interesting. If you are just starting to learn Tableau, we recommend you first watch through the excellent videos we curated for you at Where to Learn Tableau?.

The first video below demonstrates a variety of interesting techniques using Tableau to create elegant visualizations. It is presented by Alan Eldridge of Tableau Software. It encourages you to become a Tableau Jedi, i.e. a master of the magical world of Tableau visuals.

This video below is on Tableau Parameters. It is by Andy Kriebel who is a five-time Tableau Zen Master, creator of innumerable contents providing examples of data visualization best practices, methods for improving existing work, and tips and tricks with Tableau. He is also the Head Coach at The Information Lab Data School and writes several weekly series.
This video below is on Tableau Charts. It is also by Andy Kriebel who is a five-time Tableau Zen Master, creator of innumerable contents providing examples of data visualization best practices, methods for improving existing work, and tips and tricks with Tableau. He is also the Head Coach at The Information Lab Data School and writes several weekly series.
This video below has 50 Tableau Tips in 50 minutes. It is by Jeffrey Shaffer who is the VP in an Analytics firm and also a Tableau Zen Master, along with Andy Kriebel who is a five-time Tableau Zen Master, creator of innumerable contents providing examples of data visualization best practices, methods for improving existing work, and tips and tricks with Tableau. As you already know, he is also the Head Coach at The Information Lab Data School and writes several weekly series.
This video below has several Practical Tableau Visualization Tips spanning across various types of visualizations and elegant practices. It is presented by Ryan Sleeper who is a data visualization consultant, a Tableau Zen Master, and author of an amazing detailed book on practical visualizations with Tableau.
This video below has 20 Tableau Tips in 20 Minutes covering various aspects of visualizations. It is authored by Edureka, an online education portal specialized in creating and sharing excellent online courses. You can learn more on Tableau from the best Edureka tutorials selected for you on our article at Where to Learn Tableau?
This video below is a power-packed 2-minute sprints of several fascinating Tableau Tricks. It is presented by Jeffrey A. Shaffer, the COO and VP at an analytics company in Ohio, USA, a Tableau Zen Master, and also author of a splendid book on visualizations and dashboards. Along with Luke Stanke, the founder and partner of an analytics company, a data visualization consultant, and also a Tableau Zen Master.
We keep updating our collection of Tableau Tips and Tricks here, so keep a watch out for new content.


Data as a term is the center of attention when speaking of Tableau since it is known as a great business intelligence and data analysis tool. In order to be able to work with Tableau, first thing we need to learn and understand data and all its underlying features. We need to understand how different data types are used, how it is managed, merged, filtered, extracted or any other action available in Tableau. But first thing, first. In this article we will be elaborating about the different types of Tableau and how we can change them.

What Kind Of Data Types We Have In Tableau?

Data values into its definite type are characterized by the data types. The data type of data values that are only text is string (ex. ‘Region’), since this value contains only characters. Other data values that contain only whole numbers (ex. 45739), their data type will be an integer. If a certain data value is in a form of a date or time ( ex. 2020-10-20 or 07:25:30), then its relevant data type will be date/time. Likewise, every data value has its own data type. Which means that all the data values fall under a specific category of data type, not one is left aside. 

For higher transparency and efficiency, Tableau has created its own set of data types on which it characterizes every data value. Primarily, there are seven main data types used in Tableau. As soon as the data gets uploaded to Tableau, a certain data type is assigned to that field since Tableau is able to detect the data type in the field immediately. Even though a primary data type is assigned to the data field itself, you can afterward modify it. 

The seven main data types are:

  • String values
  • Integer (number) values
  • Date values
  • Date & Time values
  • Boolean values
  • Geographic values
  • Mixed (cluster) values
By looking at the Data pane of Tableau, you can see that each data type has its own distinct icon that stands in front of the field. The distinct icons are shown in the table below. These icons are denoted to every field so we can easily identify the data type of a field and if we want, to change it. In this section of the article, we will make sure that we have clear understanding of the meaning of all data types used in Tableau. 

String values

Integer (number) values

Date values

Date & Time values

Boolean values

Geographic values

Mixed values


Data Types in Tableau

Let's dive into each Tableau data type in detail.

String Data Type

The string data type consists of only characters, one or more. This is a text data type. When the specific characters of a value are enclosed in a single or double inverted commas (more known as single or double quotes, a value is considered a string. For example, a string data value is “Region”.

Further, the string data type is split into two main categories. Char and Varchar. 

  • Char string type - All the values which are defined with this data type have a fixed length. The memory regarding the fixed length is assigned to char string values in tableau. That being said, if you try to enter a string value whose length is more than the fixed length, Tableau will show an error. Usually, the alphanumeric data values are the ones stored for this data type.
  • Varchar string type - As a contrast, the length of the varchar string type is variable, with no predefined length of the characters that can be entered. Since there are no memory allocation restrictions, you can able to enter as many characters as you want. Alphanumeric data values can also be found in this string type.

Numeric data type

The numeric data type stands for values that consist of numbers. These values can be either, an integer type or a floating type. The integer type is a more common numeric data type since float values can create difficulties for the users in the process of accumulating the decimals after a certain limit. However, by using the Round function you can round up the float values to  corresponding integers and then, they can be easily used in calculations. 

Date and Time Data Types

Tableau accepts many formats of date and time. For example, dd-mm-yy, dd-mm-yyyy, dd-mm-yyyy hh-mm, mm-dd-yyyy etc. Some fields contain only date value (ex. dd-mm-yyyy) while others can have a time along the date like a timestamp ( ex. dd-mm-yyyy hh-mm). The date and time values can be expandable from decade, year, quarter, month, day, hour, minutes, seconds etc. There is also a workaround in order to transform the date value in the form of string characters. By adding a # sign before the date ( for example, #22/10/2020), Tableau registers this field as a string. Under this category, there are two data types - Date type and Date & Time type. 

Boolean Data Type

The Boolean data type are actually values that are the result of some relational calculations. That being said, the Boolean values, True and False, are also known as logical values. If otherwise, the result of that specific relational calculation is unknown, the value for it will be shown as Null. 

Geographic Data Type

As obvious from its name, the geographic data values are all values that can be used in a map. To clarify, these values are country, state, city, region, postal codes etc. 

Mixed or Cluster Data Type

Even though it is more rare, sometimes a field can not be characterized under a specific data type because it doesn’t consist of a single data type. These values have a mixture of data types. These values are known as mixed data values. In this situation, you have two choices. You can either manually handle these fields by separating them into different data types or just let Tableau take care of it.


Changing Data Types in Tableau

As an ideal situation, Tableau is able to detect the data of every field and assign the accurate data type to all existing fields in the data source once you upload it. However, even Tableau sometimes is not able to properly read the data in the field or just, you want the field with another data type so you can use it differently. Don’t worry. Tableau offers many ways at many stages while working, to change the data type of a field. Three are shown below.

In Data Source page

If you are in that stage when you are just creating your Data Source and cleaning it up so you can use it more efficiently later, you should consider changing the data type of a field here. To change the data type in the Data Source page, you should click on the data type icon. Then, a drop down menu will appear with all data types. You should select the new data type and it will automatically allocate it to the values of that field.

From Data Pane

Once you have created your data source and uploaded in Tableau, all the data fields from it are shown in the Data Pane of a certain Tableau worksheet. Very similarly to the previous one, you should click on the data type icon that stands ahead of the field. Then, select a new data type from the dropdown list that will appear.

In the View itself

Another way how you can change the data type which is assigned to a field by default is from the View. Here, you should right click on the field itself. From the drop-down list, select Change Data Type. As a result, a list of data types will appear where you can choose your new data type.

 

Additional Notes Regarding the Mixed Data from Files in Tableau

When we import data from files like MS Excel, Access, CSV or some other type of file, it is common for the columns to have mixed data types. That means that data values with mixed data can have numbers and text together. Or dates and numbers. When new data is uploaded, usually Tableau detect the appropriate data type for the values and each column. And then, assign that data type to the column itself. This is very simple when the values in the column are only single data type. In this case, a date or text column will be mapped as a dimension field. Or a numeric column, will be mapped as a measure field.

But the tricky thing is when a column has more than one data type in its value. Then, there are some mapping rules for each file type.

For Excel, the data type is decided due to the data type of the first 10,000 rows.

When it comes to CSV file, the data type is decided based on the data from the first 1024 rows.

Summary

In this article, we gained knowledge about different data types available in Tableau. We learnt that there are seven main data types in Tableau. String, Numeric, Boolean, Date, Date & time, Geographic and Mixed. Tableau is able to detect the data type of newly uploaded values and assign it to the relevant fields.  Also, we learnt how we can change the data type on three different ways depending on the stage of the work process we are in.