1. What is Tableau?
Tableau is a business intelligence software. It allows anyone to connect to the respective data. It visualizes and creates interactive, shareable dashboards.
2. What is data visualization?
Data visualization means the graphical representation of data or information. We can use visual objects like graphs, charts, bars, and a lot more. Data visualization tools provide an accessible way to see and understand the data easily.
3. What are the different Tableau products?
- Tableau Desktop: Used for creating visualizations and dashboards.
- Tableau Server: Used for sharing visualizations and collaborating with others.
- Tableau Online: A cloud-based version of Tableau Server.
- Tableau Public: Allows users to share visualizations publicly.
4. What are dimensions and measures in Tableau?
In Tableau, dimensions and measures are the two types of data that can be used in creating visualizations and analysing data.
Dimensions are categorical or qualitative data such as names, dates, and geographic locations. They are used to group or categorize data, and are often displayed in rows or columns in a visualization.
Measures are numerical or quantitative data such as sales, profit, and quantity. They are used to perform calculations and aggregate data, and are often displayed in the form of numeric values or graphs.
5. What is a mark in Tableau?
In Tableau, a mark is a visual element such as a bar, line, or point that represents a data point in a visualization. Marks are placed on a visualization based on the data that is being analysed, and can be customized with various colors, sizes, shapes, and labels.
For example, in a bar chart showing sales by region, each bar represents a mark that corresponds to a specific region and its corresponding sales value.
6.What is the difference between .twb and .twbx extension?
.twb is an xml document which contains all the selections and layout you have made in your Tableau workbook. It does not contain any data.
.twbx is a ‘zipped’ archive containing a .twb and any external files such as extracts and background images.
Empower Your Analytics with Tableau: Join Now
7. What is the difference between a discrete and a continuous field in Tableau?
- A discrete field contains a finite number of distinct values (e.g., categories or groups).
- A continuous field contains an infinite number of possible values within a range (e.g., time or temperature).
8. What is data blending in Tableau?
Data blending is a technique used when you want to combine data from multiple data sources or tables in Tableau.
9. What is the difference between a Tableau Worksheet and Workbook?
A Tableau Worksheet contains raw data, which can be an extract of the original source or a live connection to the data. It contains rows and columns which have values of measures and dimensions.
A Tableau Workbook is a collection of sheets in Tableau. These sheets may be workbooks, dashboards, or stories.
10. What are the different types of joins in Tableau?
The joins in Tableau are same as SQL joins.
11. How many maximum tables can you join in Tableau?
You can join a maximum of 32 tables in Tableau.
12. Name a few Tableau File Extensions.
- Tableau Workbook (.twb)
- Tableau Data extract (.tde)
- Tableau Datasource (.tds)
- Tableau Packaged Datasource (.tdsx)
- Tableau Bookmark (.tbm)
- Tableau Map Source (.tms)
- Tableau Packaged Workbook (.twbx) – zip file containing .twb and external files.
- Tableau Preferences (.tps).
13. What is the Difference Between Tree maps and Heat Maps?
Heat Maps: A heat map is a qualitative method of data visualization and comparison. Using a heat map, you can compare the quantum measures method across various categories within a table without needing to create a graph or chart. Higher values will generally be shown in darker shades of red, while lower values will tend toward the blue end of the spectrum. However, Tableau does allow you to change colors and shades.
Tree Maps: A treemap allows you to quantitatively analyze data based on the size of the pictorial representation. The basic unit of a treemap is a rectangle. A large rectangle represents the sum of all values of your chosen measures. This rectangle is then divided into smaller rectangles based on the measure’s value in each of the categories of your chosen dimension.
14. What is the difference between Tableau Dashboard and Story?
- A dashboard is a collection of views from multiple worksheets.
- A story contains a sequence of worksheets or dashboards that work together to convey information.
15. What Do You Understand the Blended Axis? What is the Use of Dual-axis?
- Blended Axis is used to blend two measures that share an axis when they have the same scale.
- Dual Axis allows you to compare measures, and this is useful when you want to compare two measures that have different scales.
16. What is the Rank Function in Tableau?
The ranking is assigning something a position usually within a category and based on a measure. Tableau can rank in several ways like:
- rank
- rank_dense
- rank_modified
- rank_unique
17. Column chart: A column chart visualizes data as a set of rectangular columns, their lengths being proportional to the values they represent. The vertical axis shows the values, and the horizontal axis shows the categories they belong to. In multi-series column charts, values are grouped by categories.
Bar chart: A bar chart visualizes data as a set of rectangular bars, their lengths being proportional to the values they represent. The horizontal axis shows the values, and the vertical axis shows the categories they belong to.
Line chart: A Line Chart is the most popular type of data visualization. As a rule, it is used to emphasize trends in data over equal time intervals, such as months, quarters, fiscal years, and so on.
Stacked Bar chart: The Stacked Bar Chart is composed of multiple Bar series stacked horizontally one after another. The length of each series depends on the value in each data point. Stacked Bar Charts make it easier to follow the variation of all the variables presented, side by side, and watch the change in their total.
Scatter Plot & Choropleth Map:
18. What are interactive dashboards?
Dashboards which enable us to interact with various elements like filters, parameters, actions, and slice and dice the data to get better insights or answer complex questions.
19. What is the Show Me feature in Tableau?
Show Me is a useful feature in Tableau which creates a visual based on the fields already used in the view and any fields you’ve selected in the Data pane.
20. What is marks card in Tableau?
A card to the left of the view where you can drag fields to control mark properties such as type, color, size, shape, label, tooltip, and detail.
21. What is a Published data source?
It contains connection information that is independent of any workbook and can be used by multiple workbooks.
22. What is a data source page?
A data source page is where you can set up your data source. The Data Source page generally consists of four main areas: left pane, join area, preview area, and metadata area.
23. What is a formatting pane in Tableau?
A format pane contains formatting settings that control the entire worksheet, as well as individual fields in the view.
24. What is a Page shelf?
Tableau provides a distinct and powerful tool to control the output display known as Page shelf. As the name suggests, the page shelf fragments the view into a series of pages, presenting a different view on each page, making it more user-friendly and minimizing scrolling to analyze and view data and information. You can flip through the pages using the specified controls and compare them at a common axle.
25. How many ways to use parameters in Tableau
We can use parameters with filters, calculated fields, actions, measure-swap, changing views and auto updates.
26. What are groups?
Group simplifies large numbers of dimension members by combining them into higher-level categories. You can create a group to combine related members in a field. For example, if you are working with a view that shows average test scores by major, you might want to group certain majors together to create major categories. English and History might be combined into a group called Liberal Arts Majors, while Biology and Physics might be grouped as Science Majors.
27. What are sets?
Sets are custom fields that define a subset of data based on some conditions. A set can be based on a computed condition, for example, a set may contain customers with sales over a certain threshold. Computed sets update as your data changes. Alternatively, a set can be based on a specific data point in your view.
28. What is a bin?
Sometimes it’s useful to convert a continuous measure (or a numeric dimension) into bins.
Any discrete field in Tableau can be considered as a set of bins. For example, suppose you create a view with Profit on Rows and State on Columns.
29. What is a Secondary Axis?
In addition to blending multiple measures on the same axis, you can add a secondary axis or dual axis to a view to better compare measures of different scales.
30. What type of data limitations does Tableau Public have?
Tableau Public can only connect to a few data sources like Microsoft Excel, Microsoft Access, and multiple text file formats. It has a limit of 1,000,000 rows of data that is allowed in any single file.
31. Difference between Tiled and Floating in Tableau Dashboards
Tiled items are organized in a single layer grid that modifies in a measure, which is based on the total dashboard size and the objects around it. Floating items could be layered on top of other objects and can have a permanent size and position.
Floating Layout While most questions are tiled on this dashboard, the map view and its related color legend are floating. They are layered on top of the bar graph, which utilizes a tiled layout.
32. What is a LOD expression?
LOD Expressions give way to effectively compute aggregations that are not at the level of detail of the visualization. You would then be able to coordinate those values inside visualization in arbitrary ways.
33. What is VizQL?
VizQL is a visual inquiry language that interprets simplified activities into data questions and after that communicates that information visually.
VizQL conveys dramatic gains in individuals’ capacity to see and understand information by abstracting the hidden complexities of question and analysis.
The result is an instinctive user encounter that gives people to answer questions as quickly as they can consider them.
34. Where can you use global filters?
Global filters can be used in sheets, dashboards and in stories.
35. Define Gantt chart
Gantt Chart displays the progress of value over the period. It consists of bars along with the time axis. It is a project management tool. Here, each bar is a measure of a task in the project framework.
36. Define Histogram chart
A histogram chart shows the distribution of continuous information over a certain period of time. This chart helps us to find extreme points, gaps, unusual values, and more concentrated values.
Elevate Your Data Skills: Join our Tableau Training at traininghub.io
