Students also Learn Related Courses
Tableau Interview Questions and Answers
Tableau Interview Questions and Answers
Tableau Interview Questions and Answers for beginners and experts. List of frequently asked Tableau Interview Questions with answers by Besant Technologies. We hope these Tableau interview questions and answers are useful and will help you to get the best job in the networking industry. These Tableau interview questions and answers are prepared by Tableau Professionals based on MNC Companies’ expectations. Stay tuned we will update New Tableau Interview questions with Answers Frequently. If you want to learn Practical Tableau Training then please go through this Tableau Training in Chennai and Tableau Training in Bangalore
Best Tableau Interview Questions and Answers
Besant Technologies supports the students by providing Tableau interview questions and answers for the job placements and job purposes. Tableau is the leading important course in the present situation because more job openings and the high salary pay for this Tableau and more related jobs. These are top Tableau interview questions and answers, prepared by our institute experienced trainers.
Tableau interview questions and answers for the job placements
Here is the list of most frequently asked Tableau Interview Questions and Answers in technical interviews. These questions and answers are suitable for both freshers and experienced professionals at any level. The questions are for intermediate to somewhat advanced Tableau professionals, but even if you are just a beginner or fresher you should be able to understand the answers and explanations here we give.
Q1) What is data visualization and Tableau?
Data visualization is the process or method of visually representing your textual data. Tableau is one of the leading software in this visualization field. It is been the leader in the Gartner magic quadrant. It is so popular for its performance, interactivity, dynamic and user-friendly. It is a drag and drops with minimal coding
Q2) How does Tableau imports data from the database and flat files?
Importing process in Tableau is similar for all database and flat files. The only difference between a database and flat files are: flat files are unprotected and no server or login credentials are required. But to connect to a database, you need to enter the above-mentioned details.
Q3) Is Tableau a better replacement for R, SAS?
Tableau is a data visualization software and its primary function is to visualize your textual data. R and SAS are statistical software. Tableau can replace the visualization feature of this software but Tableau cannot replace statistical feature of R & SAS. Fortunately, we can connect R & Python in Tableau, which improves the statistical feature of Tableau.
Q4) Can we create more charts than the available ones in Show me?
Yes, we can visualize the data in other charts than the predefined ones in showing me the option. The other charts are called as custom charts. We can create them using customization of marks, complex calculations and sometimes with some data manipulation.
Q5) Name a few custom charts which can be created in Tableau?
Sankey chart, waterfall chart, donut chart, radial bar chart, area Pareto chart and other charts like a coxcomb, chord diagram can be created in Tableau. It involves some manual efforts and preprocessing data but it is possible in Tableau. Some of them may not be ideal for automatic data refresh.
Q6) What are the new features available in Tableau?
Tableau adds new features often. Notable features are viz in the tooltip, clustering, Dashboard layout, global workbook formatting, improvements in maps, connecting to pdf files and step chart.
Q7) What is Tableau Prep? Is it an integrated feature in Tableau Desktop?
No, Tableau prep is not an integrated feature in Tableau Desktop. It is a brand new software to help developers with their data preparation process. It helps their time on pre-processing and predefined changes. It was earlier called as Project Maestro and redefined as Tableau Prep. It has 3 coordinated views to help the developers view the data inflow view, no of rows associated with each field and sample data in the preview pane.
Q8) What are the different requirement gatherings used in Tableau and other projects?
There are primarily three styles of project requirement gathering. Clients will give us the list of exact charts to be used and fields for creating dashboards Clients would share us the screenshot of their old or current dashboard created using other reporting or data visualization software. We need to recreate them in Tableau Clients will give us the important fields and allow us to try our ideas on visualization. This involves our knowledge and creativity. In-depth understanding of the dataset will help us a lot on creating dashboards.
Q9) What is the estimated time for a project?
The time depends on the complexity of the data set and Tableau dashboards to be built. Based on the number of dashboards and calculations to be written, the time will vary. The lowest time could be 5 minutes for a perfect data and minimal calculations and the highest time could be few weeks or months with complex calculations, data processing and multiple iterations of changes.
Q10) Can Tableau connect to cubes and cloud databases?
How different are them for traditional databases and flat files?Yes, Tableau can connect to cubes and cloud databases. Connection procedure is very similar to the traditional database connection procedure. Cubes are three-dimensional data but when it enters Tableau, it will be converted to 2-dimensional data i.e. it will rows and columns.
Q11) Can Tableau connect to the heterogeneous database and flat files at the same time?
Yes, Tableau can connect to multiple databases and flat files at the same time. Data blending can connect them to their old version. Cross-database join is a recent feature that can help us on joining heterogeneous database like SQL Server, Teradata, and flat file.
Q12) How do you publish or share the Tableau workbook with your end users?
We could publish the workbook to Tableau server or Tableau online. We need to follow the below procedure to publish a dashboard from Tableau desktop to Tableau server or online. Click on server Tab Click on Publish workbook Enter the server and login credentials (first time) Select the project and enter the workbook title Change other options like user permissions, refresh schedule if required And click on publish We could share the Tableau workbook file over email or shared path too. But the end users should have Tableau Reader or Tableau Desktop to open the file. Tableau Reader can open only packaged workbooks with flat files or TDE or hyper file.
Q13) Tell us about one of the most challenges you faced in your Tableau career.
I built a dashboard for my organization’s top management. They wanted each regional head to view their team’s dashboard only. I used user filter but it needed developer intervention when a head changed. I suggested adding a new column with their windows ID to each row. Concatenated with multiple IDs if required. Used user functions to validate the user. The client can change the entitlement without the developer’s intervention. They have to just update the file and save it on the right path. The database job will pick it and update the entitlement column. This was one of my successful and challenging value additions made.
Q14) What are the ideal ways to visualize time data?
The best chart would be the line chart and area chart. Time data can be represented in Bar chart, pie chart. Especially the hourly data looks great on pie chart with equal slice and colored by the measure.
Q15) What is Tableau tool?
Tableau is a Business Intelligence tool for Visualizing and analyzing the data. Users can create and distribute an interactive and shareable dashboard which depict the trends density and variations of the data in the form of charts and graphs . Tableau can connect to relational Big Data sources and files to acquire and process data. The software allows real-time collaboration and data blending which makes it very unique. It is used by academic researchers businesses and many government organizations for visual data analysis. It is also positioned s a leader Business Intelligence and Analytics Platform in Gartner Magic Quadrant.
Q16) What is Tableau Course objective?
Understand the main Tableau interface (1) Building reports
(2) Building Dashboards
(3) Formatting data for User friendly
(4) Trend Lines over a time
(5) Using maps
(6) Best business analysis
Q17) Why should you learn tableau?
1.Easy learning in short amount of time
2.Free Tableau Public
3.Classifies and stores Big Data
4.Connects to any type of Data Source
5.Works on any Data
6.Easy to Use
7.Growth of an Individual
8.Growth of the Organization
Q18) To whom tableau is suitable Data Scientist
Big Data Developer
Top Level CEO, Managers
Q19) Job opportunities in tableau
Top MNCs like Capgemini, ITC InfoTech, TCS, General Motors, Sony, Bank of America, KPMG, Face book are few of the top companies who are looking for Tableau Talent, in India and their Onshore locations.
Some of the popular titles of tableau professional are Data Analyst, Tableau Consultant, BI Analyst, Business Analyst ,BI Developer, BI Manager, amongst others.
Q20) Would we be able to utilize non – utilized sections (Columns which are not utilized in reports but rather information source has segments) in Tableau Filters?
Ex. In information source I have segment like
- empID, EmpName, EmpDept,EmpDsignation, EmpSalary
- InreportsI am utilizingempnameon segments andempsalryon lines.
- I can utilizeempDesignationon Filters
Q21) What is advantage of Tableau separate document over the live association?
The concentrate can be utilized anyplace with no association and you can construct your own representations without interfacing with Database.
Q22) How to join two exceed expectations documents with same fields yet extraordinary information (diverse years)?
I have 5 distinctive exceed expectations documents (2007.xls, 2008.xls..2011.xls) with same fields (film name, class, move, rating, benefit) yet with information from various year (2007 to 2011). Would someone be able to reveal to me how might I join the film name, kind and gainfulness with the goal that I can see the perception of 2007 to 2011 of every a solitary outline?
Q23) Max no of tables we can participate in Tableau?
We can join max 32 table, it’s unrealistic to consolidate in excess of 32 tables.
Q24) What is the distinction among joining and mixing in Tableau? Participates in Tableau:
For Eg: your customer is in Healthcare space and utilizing SQL Server as their database. In SQL server there might be numerous Tableau like Claims Tables, Rejected Claims Table, Customer Table. Presently, customer needs to know client shrewd cases and client insightful rejected cases table utilizing the joins. Join is an inquiry that consolidates the information shape at least 2 tables by making utilization of Join condition.
We can join max 32 table, it’s impractical to consolidate all the more then 32 tables.
In Tableau the joins can perform in 2 different ways.
- By making utilization of regular segments.
- By making utilization of basic information types.
On the off chance that we make joins on the fields in Tableau all the table names are suffixing with $. While playing out the joins on various tables, dependably run with the les measure of information tables, so we can enhance the execution.
In Tableau the joins are separated into 2 types.
- Equi Join,
- Non EquiJoin
Equi Join: in the join condition in the event that we are utilizing Equality”=”operator, such a sort of join called as Equi join.
Non Equi Join: in the join condition separated from the Equality”=”if we utilize some other administrator like <,>,<=,>= and=! At that point such a sort of joins are called as Non Equi Join
Equi Join is partitioned into 3 types
- Internal Join,
- External Join,
- Self – Join.
1.Inner Join: Inner join will stacks the main coordinating records from the two tables. Internal join condition:
Tableaa.id = Tableb.id
Again the external join partitioned into 3 types.
- Left Outer Join,
- RightOuter Join,
- Full Outer Join.
Left external join: Displays the total information from the left + coordinating records from the correct table.
Right Outer Join: shows the entire information from the privilege + coordinating records from the left.
Full external join: full external join stack the entire information from the left table and right table. Condition: Table A full external join Table B ON tablea.id= tableb.id
3.Self-Join: in the event that we are performing join to a similar table itself such a sort of join called as self-join
Non Equi Join:
In the join condition on the off chance that we are utilizing the administrators separated from the fairness “=” such a sort of joins are called as Non Equi join.
Information Blending in Tableau:
For ex: your customer is same Healthcare Client. They are working their administrations in Asia, Europe, NA, etc and the are keeping up Asia information in SQL, Europe Data in SQL Server and NA information in MY SQL.
Presently, your customer needs to examine their business over the world in a solitary worksheet. So you can’t perform join here.
Presently you have make utilization of Data Blending Concept.
Typically in the Tableau we can play out the examination on the single information server. In the event that we need to play out the examination from the numerous information sources in a solitary sheet then we need to make utilization of another idea called as information mixing.
Information mixing blend the information from the diverse information sources and enable the clients to perform th examination in a solitary sheet. Mixing implies blending. On the off chance that we are blending the information sources, it is called as information mixing.
Standards to play out the information mixing
So as to perform information mixing there are few tenets.
On the off chance that we are playing out the information mixing on 2 information source these 2 information sources ought to have something like 1 normal measurement.
In that regular measurement somewhere around 1 esteem should coordinate.
In Tableau we can play out the information mixing in 2 different ways.
- Programmed way
- Custom way
Programmed way:In the programmed way Tableau consequently characterizes the connection between the 2 information sources dependent on the normal measurements and dependent on the coordinating qualities and the relationship is demonstrated with Orange shading.
Custom or Manual way:In the manual or custom way the client need to characterize the relationship physically.
Information mixing fuctionality.
All the essential information sources and the auxiliary information sources are connected by explicit relationship
While playing out the information mixing each work sheet has an essential association and alternatively it may contains a few auxiliary associations.
All th essential associations are shown in the Blue in the work sheet and all the optional information sources demonstrated with the Orange shading tick stamp.
In the information mixing 1 sheet contains 1 essential information source and 1 sheet can contain end number of auxiliary information sources.
Q25) What are Dimensions and Facts?
Measurements is only the spellbinding content segments and realities are only measures (numerical qualities) dimentionex:productname city..facts:sales, benefit
Q26) Would we be able to put an exceed expectations document in a common area and utilize it to build up a report and revive it in ordinary interims?
Indeed you can do it… however for the better execution utilize separate
Q27) What is the contrast between warmth guide and tree outline?
A warmth delineate an extraordinary method to look at classes utilizing shading and size. In this, you can think about two unique measures. Tree outline an amazing representation, especially to delineate progressive (tree – organized) information and part – to – entire connections.
Q28) What is the distinctive among twb and twbx record expansions. If it’s not too much trouble clarify.
Twb is a live association, it focuses to the information source; the client accepting twb needs authorization to said information source and no information is incorporated. .twbx takes information disconnected, stroes the information as a bundle or compress like record, along these lines killing the requirement for consents from end client, it’s presently a depiction in time of the information as of the time it was Saved as . twbx
Q29) What is double pivot?
To show two measure in one diagram
Q30) What is mixed pivot?
Various Measures are appeared in single hub and furthermore every one of the imprints appeared in single sheet
- Drag a measurement in a section
- Drag the primary measure in section
- Drag second measure in existing pivot
Q31) What makes Tableau programming emerge?
In my view, Tableau emerges for a few reasons:
To start with, the majority of the BI instruments out there are expensive. In any case, Tableau has a free offering (Tableau Public) and in addition an extremely prominent (likewise free) scholarly appropriation. Scene is all around perceived by firms like Forrester research to be a standout amongst the most simple to utilize, and deft items right now accessible. see here: Tableau Ranks #1 in The Forrester Wave: Advanced Data Visualization (ADV) Platforms That makes it simple to get and attempt new things with, which information representation individuals love about it.
Then again, not at all like a portion of the other BI instruments, Tableau is anything but an entire innovation stack, it is most valuable for perception and investigation. – you will require different items notwithstanding scene for heavier venture information ETL, upkeep, and capacity, and so on https://www.tableau.com/about/blog/2012/7/scene positions 1-forrester-wave-propelled information representation adv-stages 1852
Q32) How would we do testing in Tableau?
You can’t test in Tableau supposedly. It is an information perception programming.
Q33) Would you be able to get esteems from two distinct sources as a solitary contribution to parameter?
Scene at present not bolster the multi-esteemed parameters… “Contextual analysis: The “dynamic parameter with a mix” strategy can be utilized to feature a solitary esteem, yet not different qualities as a result of the manner in which it works. As Tableau parameters are not dynamic, we can’t “channel” the rundown of qualities at runtime.”
Q34) What number of ways we utilize parameters in Tableau?
We can utilize parameters with channels, determined fields ,activities, measure-swap, changing perspectives and auto refreshes
Q35) What is the utilization of new Custom SQL Query in scene?
Custom SQL Query composed subsequent to interfacing with information for pulling the information in an organized view, One basic precedent is you have 50 segments in a table, yet we require only 10 segments as it were. So as opposed to taking 50 segments you can compose a sql inquiry. Execution will increment.
Q36) What are the contrasts between Tableau Software and Traditional BI instruments?
Scene gives simple to utilize, best in class, Visual Analytic abilities, however it doesn’t help with the pipes (information establishment). You could, for instance, wed SQL Server with Tableau to get the entire bundle. Scene licenses are generally costly in the event that you are hoping to scale.
Customary BI can deal with it everything except with noteworthy forthright expenses. Higher counseling, equipment and programming costs. Among the super merchants, no one but Microsoft can give a sensible offer. Open source merchants like Pentaho and Jasper Soft don’t have a sufficiently bottomless ability pool, yet.
Q37) What are the similitudes and contrasts between Tableau programming and Palantir?
Palantir and Tableau are altogether different. Palantir has its underlying foundations in expansive information software engineering issues including security, installments, extortion discovery and the preferences. Clients/Investors incorporate Paypal, CIA and others.
Scene is a perception player – with roots in Stanford U investigate. It’s Visual Query Language (VizQL) enables clients to construct representations over standard information distribution centers or spreadsheets.
Q38) How to make falling channels without setting channel?
I have filter1 and filter2.Based on filter1 I have to filter2 information
Ex: Filter1 as Country and Filter 2: States
I have picked nation as INDIA and filter2 should show just INDIA states
Pick alternatives of Filter2 states :
select alternative of “Just important qualities ”
Q39) Is Tableau Software useful for a key obtaining?
Indeed without a doubt! It gives you information understanding to the broaden that others don’t. Enables u to plan and point the abnormalities and ad lib your procedure for advancement.
Q40) How to show top 5 and last 5 deals in same view?
Utilizing channels or determined fields we can ready to show the main 5 and last 5 deals in same view?
Q41) Structure a view to demonstrate district savvy benefit and sales.I did not need line and bar visit ought to be utilized for benefit and deals. How you will plan and please clarify?
Create the Map utilizing urban areas – >then Drag the Profit and deals to the Details– >Add the state as Quick channel
Q42) How to add custom Color to Tableau?
Make Custom Color code in “Preferences.tps”
Route ::: Documents » My Table Repository »Preferences.tps
Include custom shading code
Note: In scene 9.0 form we have shading picker choice..
Q43) How might we consolidate database and level record information in scene work area?
Interface information multiple times, one for database tables and one for level record. The Data->Edit Relationships
Give a join condition on normal segment from db tables to level record
Q44) What is disaggregation and conglomeration of information?
Assume I have information like
Eid Ename Salary Dept
1.abc 2000 java
2.bbc 3000 .net
3.Krishna 2500 java
5.Vamshi 3000 centralized computers
1.abc 1000 testing
2.bbc 3000 scene
4.Madhu 7000 testing
vamshi 9000 scene
1 abc 11000 Mainframes
2 bbc 13000testing
3 krishna15000 java
4 Madhu 17000 .nte
5 vamshi 19000.net
Total: to show total information
Total/avg compensation by every individual worker
drag ename on columna and compensation on lines we will get whole (pay) of each and singular worker
presently change measure type as Avg
Pick compensation choice – pick measure types as “Avg”
Disaggregation: To show every single exchange
When you take a gander at the accumulated information in the perspectives over, each bar speaks to all exchanges for an explicit worker summed up or arrived at the midpoint of into a solitary esteem. Presently say that you need to see the individual pay exchanges for every representative. You can make a view like that by choosing Analysis>Aggregate Measures.
Q45) What Does TABLEAU do?
We will probably enable individuals to see and comprehend information. Our product items put the intensity of information under the control of regular individuals, permitting an expansive populace of business clients to draw in with their information, make inquiries, tackle issues and make esteem.
Q46) What is Tableau Public?
Scene Public is a free administration that gives anybody a chance to distribute intelligent information to the web. Once on the web, anybody can interface with the information, download it, or make their own perceptions of it. No programming abilities are required. Make certain to take a gander at the exhibition to see a portion of the things individuals have been doing with it.
Q47) What is information displaying?
Information demonstrating is the investigation of information protests that are utilized in a business or other setting and the distinguishing proof of the connections among these information objects. Information demonstrating is an initial phase in doing object-situated programming .
Q48) What is your day by day work process in scene?
I think we as a whole work on various tasks utilizing Tableau, so the work starts from understanding the necessity getting the required information, story boarding at that point making perceptions in scene and afterward showing it to the customer for survey.
Q49) What is parameter in Tableau ? What’s more, how it works?
Parameters are dynamic qualities that can supplant steady qualities in computations and can fill in as channels
Q50) How does Tableau perform with colossal datasets?
Scene Performance depends on Data source execution. In the event that information source sets aside greater opportunity to execute an inquiry, Tableau must hold up to that time.
Q51) In what capacity will you distribute and plan exercise manual in scene server?
First make a calendar for specific time and after that make remove for the information source and distribute the exercise manual for the server. Before you distribute, there is a choice called Scheduling and Authentication, tap on that and select the calendar starting from the drop which is made and distribute. Additionally distribute information source and relegate the timetable. This timetable will naturally keep running for the doled out time and the exercise manual is revived.
Q52) Characterize the names for parameters ,channels and so on…
Parameters are dynamic qualities that can supplant consistent qualities in estimations and can fill in as filters.Filters are utilized to limit the information dependent on the condition u have referenced in the channels rack.
Q53) How to see sql which is produced by Tableau Desktop?
The Tableau Desktop Log records are situated in C:UsersMyDocumentsMy Tableau Repository. In the event that you have a live association with the information source, check the log.txt and tabprotosrv.txt documents. In the event that you are utilizing a concentrate, check the tdeserver.txt record. The tabprotosrv.txt document regularly demonstrates point by point data about questions.
Q54) What is page rack?
page rack is control full piece of scene That you can use to controle the presentation of yield and printed aftereffects of yield.
Q55) What are the real contrasts between scene rendition 7.0 and scene variant 8.0?
New representations are presented like treemap, bubble outline and box and hair plot
We can duplicate worksheet straightforwardly starting with one exercise manual then onto the next exercise manual
Presented R content
Q56) How to make filled maps?
Stage 1: Build a Map View Double-click a geographic fields, for example, State, Area Code, Zip Code, and so forth.
Stage 2: Select the Fille Map Mark Type The Automatic check type will demonstrate this kind of view as circles over a guide. On the Marks card, select Filled Map to shading the geographic regions.
Step 3:Drag a Field to the Color Shelf Define how the areas are shaded by hauling another field to the Color rack.
Q57) Is Parameter have it’s dropdown list?
Truly it might have its own drop-down rundown, the sections which you make in the Parameter while making it very well may be seen as a Dropdown list.
Q58) How to amend SQL Performance for created Dashboards?
After the formation of Dashboards on the off chance that we get an issue from the SQL side that implies Custom SQL. How to Rectify the SQL execution from custom SQL.
Q59) Assume my permit terminates today, can clients ready to see the dashboards or exercise manual which I distributed in server before.
On the off chance that your server permit terminates today, your client name on the server will have the job ‘unlicensed’ which implies you can’t get to, however, others can. The Site Admin can ‘Change Ownership’ to someone else, so extricates whenever empowered don’t come up short.
Q60) Imagine that I am utilizing Tableau work area and have a live association with Cloud time Hadoop information. I have to press F5 to revive the representation. Is there in any case to naturally revive the perception each x minutes as opposed to squeezing F5 inevitably?
Here is the case of the invigorating dashboard in like clockwork, Replace apisrc and server URL with yours. The interim underneath is for 3 seconds.
Q61) What Tableau Desktop is?
Scene Desktop depends on a leap forward innovation from Stanford University that gives you a chance to drag and drop to examine information. It is extraordinary information perception apparatus, you can associate with information in a couple of snaps, at that point envision and container intelligent dashboards with a couple of something beyond.
Q62) What are the contrasts between Tableau Software, GoodData and Traditional BI (Business Objects, and so forth.)?
You could talk include – usefulness for a considerable length of time, however at an abnormal state there are four noteworthy contrasts.
Speed: How quick would you be able to get fully operational with the framework, answer questions, plan and offer dashboards and afterward change them? This is Where frameworks like Tableau and GoodData are obviously better than old – school business knowledge like Business Objects or Cognos. Customary frameworks took months or years to insight like Business Objects or Cognos. Conventional frameworks took months or years to execute, with costs racing to millions. The scene has a free trial that introduces in minutes and GoodData is cloud-based, so they are quicker to execute by requests of greatness. They are additionally quicker to results: conventional BI requires IT and designers to roll out any improvements to reports, so business clients are stuck in a line holding up to complete anything. Scene and GoodData give to a greater extent a self – benefit involvement.
Examination layer: This is the place Tableau exceeds expectations. It has amazing and adaptable drag and drops representation motor dependent on some innovation from Stanford. GoodData and customary BI regularly give some canned reports however transforming them requires noteworthy time and cash.
Information layer: This is the place the three choices are generally unique:
GoodData expects you to move your information to its cloud.
Q63) What is BI?
Business intelligence is the strategies & technologies used by enterprises for the data analysis to extract business information from it. Business intelligence technologies usually provide historical, current and predictive views of business operations with respect to the data.
Q64) What are all the different data types in Tableau?
- Geographical values
- Number (Decimal)
- Number (Whole)
Q65) What are Measures in tableau?
Measures are measurable quantities, precisely, Numerical data. It can be data where we can apply mathematical operations. Any aggregations should make sense of the data.
Q66) What are Dimensions in tableau?
Dimensions are descriptive attributes. Precisely, categorical data. Aggregation functions cannot be used for any Dimensions.
Eg: Customer Name, Pin codes.
Q67) What is a Context filter?
Context filters are Independent filters. It works in a way that, all other filters performs filtering option once this context filter is executed. Any other filters that you define are dependent filter because they dependent the data that context filter allowed.
Q68) What are all the different types of filters in Tableau?
- Quick Filter
- Context Filter
- Data source Filter
Q69) What is a Page Shelf in Tableau?
Page Shelf is a distinct and a powerful tool to control the environment. Page Shelf has the view into the line of pages. This minimizes the selection scrolling and makes the view more user-friendly. These pages can be flipped by specific controls.
Q70) Name the products given by tableau?
- Tableau Desktop
- Tableau Prep
- Tableau Server
- Tableau Online
- Tableau reader
- Tableau Public
Q71) Please Explain the difference between .twb and .twbx files?
.twb is an xml document which will have all the selections and layout structure that you made in your Tableau workbook. .twb files will not contain any data you analysed.
.twbx is a ‘zipped’ archive file which contains the selections and layout structure that you made in your Tableau workbook along with the data you processed.
Q72) What is mean by Joins?
Joins is the process of combining different data tables from the source/server. Where in Tableau, we have 2 ideas of joins.
- Equi Join
- Non – Equi Join
Q73) What are the different types of joins in Tableau?
- Left Join
- Right Join
- Inner Join
- Full Outer Join
Q74) What is the maximum number of tables you can join in Tableau?
Maximum of 32 tables can be joined at a time.
Q75) What is Live Data connection?
In Tableau, we can connect to different data sources. Where it do support default connections to receive data automatically. Such data sources will result with specific intervals. So the data refresh happens automatically. Such data source is Live data set in Tableau.
Q76) What is Extract Data connection in Tableau?
Extract data connection will result in static data source. Until updating data source manually, data will not get refreshed. Using Tableau server, we can overcome this problem.
Q77) What is the advantage of using Extract data connection over Live data Connection?
Extract data can be used anywhere without any connection establishment such as connecting to Database.
Q78) What are all the shelves we have in Tableau?
- Pages Shelf
- Filter shelf
- Marks Shelf
- Rows Shelf
- Columns Shelf
Q79) List down the widely used map services in Tableau.
- WMS server
Q80) What is WMS server?
WMS Stands with Web Map Service Server. With WMS server we are able to establish connection with third-party map servers.
Q81) What are all the different type of maps available in Tableau?
Symbol Maps: If we are about to indicate all geographical locations on the map then it’s called as Symbol Maps
Filled Maps: If we are about to indicate all geographical locations with a crammed/filled portion then it’s called as Filled Map.
Q82) What do you mean by Data Blending in Tableau?
Data Blending is the process of combining data sets from 2 different data sources. Where Tableau demands at least of one dimension in common between these two data sources to perform blending.
Tableau automatically identifies the dimension using the column name. It is even possible to explicitly giving the dimension to be selected as the common dimension.
Q83) What is sets in Tableau?
Sets are basically custom fields that has a subset of data based on the given conditions by users.
Eg: a set may contain customers with sales over a certain threshold in a specific month in specific region. In general, sets gets updated as your data change.
Q84) What is groups in Tableau?
Tableau group is basically a combination of dimensions that make higher level of categories in the data.
Q85) What is Parameters in Tableau?
Parameters helps the users to give their own inputs/values dynamically.Tableau supports parameters like
- Data Type
Q86) What is Dual Axis?
Dual Axis helps users view two different scales of two different measures in the same graph/report. Dual axes helps us to compare multiple measures at once, with two independent axes layered on top of one another.
Q87) What is Tableau Data Engine in Tableau?
Tableau Data Engine is basically analytical database designed to do instant query response. It helps a lot in predictive performance. Can be easily integrated into existing data infrastructure. TDE is not limited to load entire data sets into memory.
If you work with a huge dataset, it takes a while to import, create indexes and to sort data. But, after importing everything speeds up. TDE is not actually in-memory technology. Once the data is stored into disk memory after the data load, the RAM is hardly utilized. .
Q88) How to create a calculated field in Tableau?
Right Click on any of the Dimension in the Data pane and select | Create > Calculated Field | to open the calculation editor. .
Q89) Name few Dashboard components in Tableau.
- Image Extract
- Web (URL)
Q90) Is it possible to view to 10 records & last 10 records in single View?
Yes, You can create 2 different sets with top 10 records in set 1 & last 10 records in set 2. Finally, join set 1 & set 2. .
Q91) What is Heatmap & give its advantages?
A heat map is basically a chart which helps to identify better trend in numeric data. Heat map can also be used for comparing categories with colour and size. Heat maps also helps to compare two different measures together.
Q92) What is Tree Map?
Tree maps works the same as Heat map, but it produces the visualization can be interpreted hierarchically and helps to understand the relationship between the variables. .
Q93) What is Blended Axis?
Multiple measures are given in a single axis which represents different measures.
Q94) Will a parameter accept data from 2 different data sources?
No, As of now Tableau do not support data blend for a Parameter.
Q95) What is Custom SQL in Tableau?
Custom SQL has been used to perform your SQL codes within Tableau. Parse your SQL codes with no change, just directly give your SQL commands to get the data from server. Tableau do support the SQL commands as it is.
Q96) Do Tableau support Pin codes?
Yes, Tableau do support Pin codes. It has its own repository. Wherever if you find some pin codes missed in the Tableau repository, Include it in Tableau with its respective Latitude & longitude.
Q97) What is Aggregation in Tableau?
The process involved in viewing numeric values (basically measures) at higher and more summarized levels is termed as aggregation.
When you give a measure to any shelf, Tableau automatically performs aggregation to the data, default is sum.
Q98) What is Disaggregation in Tableau?
In Tableau, Dis-aggregating your data gives you the view of every row of the data source. Which is highly useful when you are analysing measures.
Q99) Is it possible to do performance testing in Tableau?
Yes, it is one of the important feature in Tableau. Performance testing can be done by using Testing Tableau Server with TabJolt. Which is actually a ‘Point & Run’ load generator, which has created to perform QA. TabJolt is not supported by tableau. Hence, we must install using other open-source products.
Q100) What is Web Dashboard component in Tableau?
A web(URL action) is basically a hyperlink that points to a Web page link. A web-based resource outside of Tableau application. we can use URL actions to link to more information about your data that has been hosted outside of your data source.
Q101) Is It possible to combine a flat file with data from a database?
Yes, you can import flat file data initially and create a connection to database for second data source. At last perform a join to combine those 2 datasets.
Q102) What is Data Modelling?
Data modelling is basic analysis of data objects that are used in a business. On the other hand, it uses context and the identification of the relationships among these data objects.
Q103) How to add custom colour in Tableau?
Adding a Custom Colour is a powerful tool in Tableau. Always restart you Tableau once you saved .tps file. In the Measures pane, drag the one you want to add colour. From the colour legend menu, select Edit Colour. A dialog box opens, select the palette drop-down list and customize as per your requirement.
Q104) What is a TDE file?
Tableau desktop file will contain the .tde extension and it refers to the file that contains data extracted from external sources like MS Excel or CSV file.
Q105) Is it possible to automate reports in Tableau?
Yes, it is possible to automate reports in Tableau. All you need to do is to publish reports in the tableau server and you need to schedule time to refresh data.
Q106) What is Story in tableau?
Tableau story is a sheet that contains a many worksheets or many dashboards that work together to extract information from the data. Creating stories is to show how the facts are connected and providing context to demonstrate how decisions are related.
Q107) What is discrete data in Tableau?
Discrete data are the values that are counted as distinct and will be separate. It can only take individual values within a range.
Q108) What is Continuous data in Tableau?
Continuous data basically used to measure continuous data and can take on any value within a finite or infinite interval.
Q109) What is Published Data Sources in Tableau?
Published Data Sources contains the connection information which is independent of any other workbook and can be used by multiple other workbooks.
Q110) What is Embedded Data source in Tableau?
Embedded Data source contains connection information and it is associated within the same workbook.
Q111) What is the maximum number of observations that Tableau can handle?
Tableau doesn’t have a par for number of rows. It can be accessed even for petabytes. It only uses the required data to answer our questions, so no limitations in the number of observations.
Q112) What does the Tableau Prep do?
Tableau prep is a Tableau work-flow application, which helps to create your own data flow. Once created, that can be used it for better automation of data pre-processing.
Q113) What are Pre-requisites to learn Tableau Developer?
Knowledge of Data control like RDMS Database (Basics of SQL) and Data warehousing Concepts.
Q114) What is Data Visualization and why important it is?
Data Visualization is used to improve the business by diagnosing areas that need more attention by analyzing the dashboard.
Q115) What is Tableau? Reasons why Tableau?
Tableau is a powerful business intelligence and data visualization tool that has a very intuitive user interface.
Reasons why Tableau:
- Tableau is primarily used for
- Creating a dashboard, reports
- Data discovery and Visualization
- Self-Service BI
- Simple statistical analytics like trends and forecasting.
Q116) Explain Design Flow of Tableau?
Connecting the data -> Creation of worksheets -> Combine Worksheets in Dashboard -> Create Story ->Publish Dashboard to Tableau Server.
Q117) Explain the difference b/w Tableau desktop and Tableau Server?
- Tableau Desktop is used to createdatavisualization, stories, and workbook.
- Tableau server is used to distribute these interactive workbooks or reports to the right audience
Q118) Explain different types of Joins present in Tableau?
Joining is a technique of merging related data with a common key.
Types: Inner Join, Outer Join, Left Outer Join, Right Outer Join.
Q119) How do Union data in Tableau?
Combine of data by two or more tables by appending value rows.
Q120) What are datatypes supported by Tableau?”
- Tableau Supports
- Text (String) Values, Date Values, Date & Time Values, Numerical Values, Boolean Values,
- Geographical Values (Used with maps) Datatypes.
Q121) John is the Marketing Manager, he need to analyze the business by doing visualization from two tables
Load the tables (“Revenue” and “Business Unit”) into tableau desktop à join the tables in
Data source level based on common column data à Drag and drop required columns in Worksheet level and do dashboard.
Q122) How to organize and customize data folder?
By creating of the folder and by combining of field.
- Creating folder à Product folder à (Product ID, Product Name ) fields
- Combining field à Product ID, Product Name à Product ID & Product Name
Q123) What is the difference between Join and Blending?
- Joining term is used when you are combining data from the same source.
- Blending requires two different data sources.
Q124) What is the difference between Live and Extract?
- Live: Live connection directly to database pulling live data on demand (up-to-date at every moment).
- Extract: Copy of the data from the database at a given time (up-to-date at time of extract).
Q125) What are the File Extensions in Tableau?
.twb, .twbx, .tds, .tdsx, .tde/hyper, .tdm, .tms, .tps.
Q126) What are Dimensions and Measures?
- Dimensions: Dimensions are explain about descriptive information.
- Measures: Measures are about measures and foreignkey.
Q127) What is meant by Discrete and Continuous in Tableau?
- Discrete can be recognized by Blue Color and limited range.
- Continuous can be recognized by Green Color and unlimited range.
Q128) Primary Pre-requisite for Data blending operation in tableau?
Sources should be Different, at least one common data Item/Column.
Q129) What are filters? Name the different filters in Tableau?
Filters control the content of data in tableau workbook, data source, and dashboard level.
Types: Data Source filter, Context filter, Quick filter, Normal filter.
Q130) Explain the difference between Quick filter and Normal filter?
The normal filter is used to control the data from database based on selected dimensions or Measure. But Quick filter are used to give a chance to user for dynamically changing data Member at run time.
Q131) What all aggregated function used in Tableau?
ATTR,AVG,COLLECT,CORR,COUNTD,COVAR,COVARP,MAX,MEDIAN,MIN,PERCENTILE,STDEV,STDEVP,SUM , VAR, VARP
Q132) What is an alternative name that can be assigned to a field or to a dimension member?
Alias is used for field or to a dimension member
Q133) What is the Type of axis in tableau?
Individual, Dual and Blended axis
Q134) Difference between Dual Axis and Blended Axis?
- Dual Axis shows two measures in different Axis.
- Blended Axis shows more than two measures in the same axis with the concept of Measure Values and Measure Names.
Q135) Elaborate your work experience in Tableau?
Remember what you have mentioned in resume and talk about tableau project, Functions you have used (Parameter, Filter, Sets, Calculated filed, Table calculation), Charts, Tableau server, Tableau public.
Q136) Having a data from 01/01/2013 to YTD Time period
(Today’s date), Now want to create a view based on this data but in the view only the latest date data should reflect(i.e. only today’s data)
Create a calculated field using If condition (condition: Sum (IF Max (Date) =Date then Sum (Sales) End).
Q137) How to create a product sales column where the sales for the product are the same irrespective of the sub-product in the view.
Create calculated field product sales using LOD function Fixed (Fix the product)
|Product||Sub product||Product Sales|
Suppose below shown is excel data which is loaded in the tableau platform. How to convert the column heading (Ex: Samsung, Nokia, Apple) into a row.
Using Pivot option in the metadata we can convert the column into rows
|Quarter||Pivot field name||Pivot field values|
Q138)Difference between Excel and Tableau Data Visualization?
- Excel is having a limitation of data, whereas Tableau allows unlimited data.
- Excel cannot connect multiple datasource, whereas Tableau connects multiple datasource.
- Excel cannot make an interactive dashboard, whereas Tableau makes an interactive dashboard.
Q139) How to change the data type of Measure, Dimension?
In Data source level -> Measure Right-click-> Change Datatype.
Q140) What is Aggregation, disaggregation?
- Aggregation is a calculated set of values that return a single numeric value.
- Disaggregation is individual data. It will show data as per raw data.
Q141) When we go for Line chart?
The line chart is a combination of the Date field and Measure. To draw a line chart Date field is mandatory
Q142) When we go for TreeMap Chart?
When we have hierarchical data, we will use a treemap chart.
Q143) How to create Hierarchy?
Select required columns like (Region, State) Right Click -> Create Hierarchy
Q144) If I have identical data values. How to do Rank (Unique) for identical data points in data values?
Rank Unique (1, 2, 3, 4)->By Table Calculation
Q145) User is a part of South region, he needs to see only south data? How to implement?
Create calculated field -> Use function “USERNAME ()”->Filter User filter
Q146) I have a separate column of the year, Month, Day? I need Year_Month_Day format. How to implement?
Q147) Which chart shows “Present year sales” and “Previous year sales” based on region?
Side by Side chart in Show Me Option
Q148) How to Show Pie Chart for Customers as Top 10, Top 11-20 and Others
Step 1: We need to create Set for Top 10 Customers on Customer Name.
Step 2: Create Set for Top 20 Customers on Customer Name.
Step 3: I need to show only Top 11 to 20 Customers on Customer Name. To achieve we need to combine Set and by excluding Top 10 Customers.
Step 4: Create a calculated field by IF Else Statement.
Step 5: Drag Calculated field to Rows and Sum (Sales) to columns.
Step 6: Select Pie Chart. Check results as per expected.
Q149) Explain how to remove subtotals for unwanted columns?
Step 1: Build the Crosstab report as per required columns and rows.
Step 2: Add subtotals from the Analysis tab.
Step 3: Go to the required Columns and right-click remove subtotals.
Q150) Performance tuning of Dashboard?
- Not to use more than 4 worksheets in Dashboard.
- Unhide Columns which are not used in the dashboard.
- Try to use more Action filters
Q151) Explain steps to attach User guide manual in tableau dashboard?
Attach User manual in Share point. From Dashboard level, Dashboard Actions Attach URL to dashboard. When User clicks on URL, the document will get the download.
Q152) What is Extension of Extract?
.Hyper is Extension of tableau from 2018 Version. In the previous version.TDE (Tableau Data Extract) Extension.
Q153) Explain Tableau Report Development process?
- Analyze the requirement.
- Design the data model as per requirement.
- Design charts inWorksheetlevel.
- Drag worksheets to Dashboard.
- Publish dashboard to tableau server.
Q154) Can we save excel data source in tableau?
Yes, we can save excel data as .tdsx and to tableau server. It can be refreshed whenever schedule refresh happens in the server.
Q155) Can we apply worksheet level and global filters in the dashboard?
Yes, we can apply filters. Global filters help in reducing repeated work. Worksheet level filters apply to a particular worksheet.
Q156) How to publish a dashboard to Server?
Publish dashboard to server. It will ask as authentication. Create project folders in server. Enable allow authentication while publishing the dashboard.
Q157) Difference between Excel and Tableau Data Visualization?
- Excel is having a limitation of data, whereas Tableau allows unlimited data.
- Excel cannot connect multiple data sources, whereas Tableau connects multiple data sources.
- Excel cannot make an interactive dashboard, whereas Tableau makes an interactive dashboard.
Q158) Can we change the data type of Measure, Dimension in Tableau?
Yes, we can change in Tableau in the Data source level and Worksheet level. Measure Right-click à Change Datatype.Example: Row ID (Number Data type) -> String Data type
Q159) What is Aggregation, disaggregation?
- Aggregation is a calculated set of values that return a single numeric value.
- Disaggregation is individual data. It will show data as per raw data.
Q160) When we go for Line chart?
The line chart is a combination of Date field and Measure. To draw a line chart Date field is mandatory. When Line chart is selected in Marks, path option will be enabled.
Q161) When we go for TreeMap Chart? How to create Hierarchy?
When we have hierarchical data, we will use a treemap chart. Select required columns like(Region, State) Right Click -> Create Hierarchy
Example: Region level -> State ->City -> District
Q162) If I have identical data values. How to do Rank (Unique) for identical data points in data values? How do I get particular sales without calculation field?
Rank Unique (1, 2, 3, 4) By Table Calculation Using Table Calculation-> Percentage of total -> Table (down) and Table (Across)
Q163) User is a part of South region, he need to see only south data? How to implement?
Create calculated field à Use function “USERNAME ()” Filter a User filter
When User login on tableau server based on User group, he can see only south data.
Q164) Which chart shows “Present year sales” and “Previous year sales” based on region?
- Side by Side chart in Show Me Option
- Another we can show using a calculated field
If datediff (‘year’, [Date], [(calc) Today’s Date]) = 1
Q165) Can you explain me when you will go for LOD's?
There are business scenarios wherein the users would like to view the Data based on some specific dimensions, then you will go for Level of Detail expressions. For example, the Report has Fields, Patient, Age, Gender and Temperature, the business wants a Measure in the same Report to identify the Average Temperature based on Gender, Average Temperature based on Ageand not just at the Patient level.
Q166) What are the different Types of LOD's?
FIXED, EXCLUDE, INCLUDE.
Q167) Based on the above scenario, how do you calculate the Average temperature based on Age?
Q168) In which Scenarios you will use a Context Filter?
- Context Filters help in Performance, wherein the tableau engine populates/filters the data first based on the filters marked as Context.
- Also in scenarios where we use LOD’s, context filters help in setting up your base pool of data for your calculations.
Q169) Can we use hash tables ( temp tables used in sql ) in tableau custom query?
Hash tables is not supported and throws an error. It is up to tableau to fix this in future versions.
Q170) What are your thoughts on Live Connection vs Extracts?
If the Dataset being extracted is small, Live connection is fine, however Extracts are the based for large datasets, as your Dataset is retrieved, computed and stored as an twbx file and can be retrieved faster.
Q171) Can we call SQL Stored Procedures in tableau?
Yes using Custom SQL Server.
Q172) What will be the approach if I would like to combine multiple Data Sources?
We could go for a Data Blend.
Q173) Is Data Blend and JOINS similar?
- No. DataBlend just combines your different Data from sources It does not filter.
- We cannot do a LEFT, INNER, RIGHT JOIN in a Datablend but in fact can combine data sources based on a Relationship field
Q174) How can we combine 2 measures in a graph with same axis?
Check Dual Axis
Q175) Suppose we want to have multiple i.e 2 or more Line Graphs on same Axis in a single visualization. Is that possible?
Yes. You need to put the Measure Names in Color Section and Measure Value in Rows and choose the visual type as Line.
Q176) How can we use Tableau as a Self Service Tool?
While Publishing, we need to publish the Data Source to the tableau Server. Any user with required permission will need to connect to that Published Data SOurce in their Tableau Desktop and then use it as a Self Service tool wherein they could Slice and Dice the Dimensions and Measures.
Q177) Can we create a Plus i.e expandable Dimensions in tableau?
For example Patient Name will be a field and if you expand it, you could view the Patient ID and Hospital Record No.
Yes, you could use Hierarchy. Create a Hierarchy for PatientName Dimension and drag and place Patient ID and Hospital Record No in the hierarchy.
Q178) In which Scenarios you will go for Parameter or a Filter
- The Values in Parameter are Static. Its contents remain unchanged even while the Data Source is refreshed unlike Filters.
- Filters filter your data Dataset while they are placed in the filters section.
- Parameters can be be referenced in calculations.
Q179) Can you give a practical example for usage of Parameter?
If you want the Data to be based on Date Frequency which user wants to choose i.e Yearly/Monthly etc, then we can create a parameter with these values and then use this in calculation. For example IF Datefrequency = ‘Monthly’ THEN DATENAME(MONTH) ……where Datefrequency is ParameterName
Suppose you have Year wise Revenue table grid Data in tableau and you would like to add a new field wherein you want to get the difference of Revenue based on Previous Year. What will be your approach?
You could use LOOKUP Function in your Calculated Field.
Q180) In which scenario you will go for a DataSource Filter?
- Per my understanding this is computed first in Precendence and filters your Data across your Datasources.
- This will apply for both Live and Extract connection.
- For example you could choose the Datasource filter and enter value Gender = ‘Male’. This will filter your entire dataset. Thus your Base Dataset will only have Male Population.
Q181) When you click a Measure Value, you could see 2 options i.e Discreet and Continous. How does this impact a visual.
When you choose Discreet, it will display each value in your Measure corresponding to the dimension. FOr continous, it will display a continuous trend visual for the dimension. For eg, Count of Patients is your Measure and HospitalName is your Dimension. If Count is Discreet, then each values in that measures will be listed in the grid.
Q182) Can we combine Aggregated and Non-Aggregate Measures in a calculated Field?
Q183) Can you give example of Non-Aggregated Measure
Q184) How can we add Custom Images in a tableau Dashboard?
In the common Tableau Repository Folder in your local Machine–> Within SHapes, you could place the .png file–> then drag and drop the Image Option into your Dashboard
–> Select the Image file from the location.
Q185) What are the purpose of Containers in tableau?
You could logically partition your visuals in containers.
Q186) When you will go for Vertical Container?
Once you Drag and Drop the Vertical Container, we can add multiple visuals within that container vertically. Basically you could scale Vertically.
Q187) Suppose there are multiple Filters in your Dashboard and when the user chooses a particular filter, based on the value, the appropriate values should be displayed across the other filters. How will you do this?
You could chose ‘Only Relevant Values’ option in multiple filters.
Q188) What are some of the Visualizations you have created?
Doughnut CHart, Heat Map, Tree Map, Bars, Line, Butterfly CHarts etc. We should ensure the visuals we create makes business sense to the users for analysis. The objective is not to just create complex charts just for show.
Q189) How will I add baseline data for example, user requests to add a baseline of eg Average Roomturnovertime of 30 minutes to be displayed across the visual.
From the analytics section –> you could choose Reference Line or Constant Line etc and set the value.
Q190) Suppose I would like to display Top 5 or Bottom 5 performers in an organization. How could I do that in tableau?
Q191) You have published mistakenly a Dashboard in tableau Public and would like to add Security permissions for this, How do you proceed?
You could not do this in Tableau Public but only in Tableau Server wherein you could assign User Groups, Users and Roles.
Q192) What is. hyper vs Extract in tableau?
Hyper is an optimized In Memory type introduced from tableau 2021.2. It supports more data and has good performance.
Q193) Can we have subscription in tableau similar to SSIS, wherein the user can get mails of a tableau Dashboard in their Inbox.