1. What is TABLEAU?
Tableau is the most powerful and fastest visualizing tool that is used in the Business Intelligence(BI) Industry. It simplifies the raw data into an understandable format. Analysis of the data becomes faster with Tableau. The visualizations can be created in the form of dashboards. The visualizations or diagrammatic representation of data can easily be understood by the employees of the organizations who are at different levels.
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. Define TreeMap?
TreeMap is a visualization that organizes data hierarchically and shows them as a set of nested rectangles. The size and colors of rectangles are respective to the values of the data points they project. Parent rectangles will be tiled with their child elements.
4. Define LOD Expression?
LOD Expression stands for Level of Detail Expression, and it is used to run complex queries involving many dimensions at the data sourcing level.
5. Define HeatMap?
A heatmap is a graphical representation of data that uses the color-coding technique to represent different values of data. As the marks heat up due to their higher value, dark colors will be shown on the map.
6. List out Tableau File Extensions.
Below are a few extensions in Tableau:
- 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).
7. What is the difference between a Heat map and Treemap?
TreeMap Heat MapIt represents the data hierarchically and shows them as a set of nested rectangles. It represents the data graphically which uses multiple colors to represent different values. It is used for comparing the categories with colors, and size, and it can also be used for illustrating the hierarchical data and part-to-whole relationships. It is used for comparing the categories based on color and size. And also it is great in spotting patterns based on the density of the information.
The colors and size of rectangles are respective to the values of the data points When their values are higher or the density of records, the data will be represented in dark color.
8. What is a parameter Tableau? And how does it work?
Parameters are dynamic values, we can replace the constant values in calculations.
9. What are the different data types in Tableau?
Tableau supports below data types. Data TypeMeaningExamplesStringCharacter Sequence. Enclosed in ”.Tableau’, ‘World’Number (Whole)Integers Number (decimal)Floating values.123.45BooleanThey are logical values.
10. Give a brief about the tableau dashboard?
Tableau Dashboard is a group of various views that allows you to compare different types of data simultaneously. Datasheets and dashboards are connected if any modification happens to the data that directly reflects in dashboards. It is the most efficient approach to visualize the data and analyze it.
11. Define Page Shelf in Tableau?
Page shelf breaks the views into a series of pages. It displays an alternate view on each page. Due to this feature, you can analyze the effect of each field on the rest of the data in the view.
12. Define the story in Tableau?
The story can be defined as a sheet which is a collection of series of worksheets and dashboards used to convey the insights of data. A story can be used to show the connection between facts and outcomes that impacts the decision-making process. A story can be published on the web or can be presented to the audience.
13. Give an overview of the facts and dimensions of the table?
Facts are numeric measures of data. They are stored in fact tables. Fact tables store the type of data that will be analyzed by dimension tables. Fact tables have foreign keys associated with dimension tables.
Dimensions are descriptive attributes of data. Those will be stored in the dimensions table. For example, customer information like name, number, and email will be stored in the dimension table.
14. State some ways to improve the performance of Tableau
- Use an Extract to make workbooks run faster
- Reduce the scope of data to decrease the volume of data
- Reduce the number of marks on the view to avoid information overload
- Try to use integers or Booleans in calculations as they are much faster than strings
- Hide unused fields
- Use Context filters
- Reduce filter usage and use some alternative way to achieve the same result
- Use indexing in tables and use the same fields for filtering
- Remove unnecessary calculations and sheets
15. What are the different Joins in Tableau?
Tableau works the same as SQL. So, it supports all Joins possible in SQL
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Inner Join.
16. Explain different connection types in Tableau?
There are 2 connection types available in Tableau.
Extract: Extract is a snapshot of data that will be extracted from the data source and put into the Tableau repository. This snapshot can be refreshed periodically fully or incrementally. This can be scheduled in Tableau Server.
Live: It creates a direct connection to the data source and data will be fetched directly from tables. So, data will be up-to-date and consistent. But, this also affects access speed.
17. What is Data Modelling?
Data modeling is the analysis of data objects that are used in a business or other context and also used as identification of the relationships among these data objects. It is the first step of doing object-oriented programming.
18. Define Dual-axis?
Dual-axis is used to show 2 measures in a single graph. It allows you to compare 2 measures at once. Many websites like Indeed use this Dual-axis to show the comparisons and growth rate.
19. What is a Tableau Reader?
Tableau Reader is a free desktop application, where you can read and interact with the Tableau packaged workbooks. It can only open the files but cannot create new connections to the workbook.
20. What is the difference between published data and embedded data sources?
The published data source contains connection information that is independent of workbooks and can be used by multiple workbooks.
The embedded data source contains connection information but it is associated with the workbooks.
