Tableau Interview Questions & Material
1). WHAT DOES TABLEAU DO?
Ans:Our goal is to help people see and understand data. Our software products put the power of data into the hands of everyday people, allowing a broad population of business users to engage with their data, ask questions, solve problems and create value
2). What is Tableau Public?
Ans: Tableau Public is a free service that lets anyone publish interactive data to the web. Once on the web, anyone can interact with the data, download it, or create their own visualizations of it. No programming skills are required. Be sure to look at the gallery to see some of the things people have been doing with it.
3).What is data modelling?
Ans:Data modelling is the analysis of data objects that are used in a business or other context and the identification of the relationships among these data objects. Data modelling is a first step in doing object-oriented programming
4). What is your daily work process in tableau?
Ans: I think we all work on different projects using Tableau, so the work begins from understanding the requirement getting the required data, story boarding then creating visualizations in tableau and then presenting it to the client for review.
5).what is parameter in Tableau ? And how it works.?
Ans: Parameters are dynamic values that can replace constant values in calculations and can serve as filters
6). How does Tableau perform with huge datasets?
Ans: Tableau Performance is based on Data source performance. If data source takes more time to execute a query then Tableau must wait up to that time
7). How will you publish and schedule workbook in tableau server?
Ans: First create a schedule for particular time and then create extract for the data source and publish the workbook for the server. Before you publish, there is a option called Scheduling and Authentication, click on that and select the schedule from the drop down which is created and publish. Also publish data source and assign the schedule. This schedule will automatically run for the assigned time and the workbook is refreshed.
8). How to rectify SQL Performance for developed Dashboards
Ans: After creation of Dashboards if we get problem from sql side that means Custom Sql ….How to Rectify the sql performance from custom sql
9). Define the names for parameters ,filters etc...
Ans: Parameters are dynamic values that can replace constant values in calculations and can serve as filters.Filters are used to restrict the data based on the condition u have mentioned in the filters shelf.
10). How to view sql which is generated by Tableau Desktop?
Ans: The Tableau Desktop Log files are located in C:\Users\\My Documents\My Tableau Repository. If you have a live connection to the data source, check the log.txt and tabprotosrv.txt files. If you are using an extract, check the tdeserver.txt file. The tabprotosrv.txt file often shows detailed information about queries.
9). What is page shelf?
Ans: page shelf is power full part of tableau That you can use to controle the display of output as well as printed results of output.
10). What are the major differences between tableau version 7.0 and tableau version 8.0?
Ans: • New visualizations are introduced like treemap, bubble chart and box and whisker plot
• We can copy worksheet directly from one workbook to another workbook
•Introduced R script
11). How to create filled maps?
Ans: Step 1: Build a Map View Double-click a geographic fields such as State, Area Code, Zip Code, etc.
Step 2: Select the Fille Map Mark Type The Automatic mark type will show this type of view as circles over a map. On the Marks card, select Filled Map to color the geographic areas.
Step 3: Drag a Field to the Color Shelf Define how the locations are colored by dragging another field to the Color shelf.
12). Is Parameter have it’s dropdown list?
Ans: Yes it may have its own drop down list, the entries which you make in the Parameter while creating it can be viewed as Dropdown list.
Data Pane Questions
13). What type of data sources tableau can connect?
14). Does tableau has capabilities of connecting Big Data sources like Hadoop ?
15). What type of joins can be created between excel sheets ?
16). Can I write custom SQL to create a single connection that union data from two excel sheets ?
17). Does tableau allow creating calculated field from data pane directly ?
18). what’s the use of meta data option in tableau data pane ?
19). How to change data type of a field from data pane ?
20). What the difference between live and extract ?
21). What’s the extract filter ?
22). what’s the need of creating a data extract ?
23). what’s the in memory data analysis ?
24). whats the difference between .tds and .tdsx file ?
25). Can you describe dimensions and measures create in tableau ?
26) . Whats the difference between extract filter and data sources filter ?
27). How does Assume referential integrity work?
28). What’s the use of edit aliases options ?
29). Tell a scenario how to use data source option “publish to server”?
30). Whats the use of saved to data source option ?
Dimensions and Measures Questions
31). Can we use dimension as measure and do data aggregation using aggregation functions ?
32). Whats the use of transform option (Split and Custom Split)?
33).How many type of default properties we can set for a dimension and how default properties are going to work?
34). Whats the use of replace reference option ?
35). Whats the use of descrive property of a dimension?
36). How to convert a measure into dimension ?
37). Describe groups with a suitable scenario and also tell whats the limitation a group is having?
38). Can you tell process of creating a set ? and a suitable scenario to use a set?
39). How to set default color for dimension values ? The purpose is wherever you use dimension it should show same color in all the charts.
40). Can you describe the geographical fields?
41) Describe row and column shelf?
42) Describe filter and page by shelf?
43) Whats use of marks card ?
44) Whats the use of show me card?
45) Worksheet actions how to use it describe it by taking and example?
46). Whats the use of check box options shown on tooltip window “Include Command Buttons”?
47) How to use sheet caption?
48) Whats the use for show summary window shown for a worksheet?
49) How to use describe sheet option ?
50) what’s going to happen if I click a bar chart duplicate as crosstab?
51) Whats the difference between autoupate filters and worksheet?
52) What do you understand by the word dashboard?
53) What is dashboard in tableau?
54) Describe the tabs Dashboard and Layout?
55) What is the use of Device Preview Tab?
56) What are all objects that we can use for designing a dashboard in tableau?
57) What are differences between floating and tiled?
58) What’s is a container ? Please describe horizontal and vertical containers?
59) name all three dashboard actions and tell the functioning of each?