In case you’re searching for Tableau Interview Questions and Answers for Experienced or Freshers, you are at the correct place. GangBoard offers Advanced Tableau Interview Questions and Answers that assist you in splitting your Tableau interview and procure dream vocation as Tableau Developer.
Q1) What is Tableau?
Answer: Scene is an information representation apparatus that enables the client to build up an intuitive and able perception as dashboards, worksheets for the improvement of the business.
Q2) Characterize diverse parameters in Tableau and their working?
Answer: The Tableau parameters are dynamic factors or dynamic qualities that supplant the steady qualities in information assessment and channels.
The client can make an assessed field esteem that profits genuine when the score standards the 80, and generally false.
Q3) Recognize parameters and channels in Tableau?
Answer: The extreme contrast really lies in the application.
The parameters enable clients to embed the qualities, which can be whole numbers, drift, date, string that can be utilized in estimations.
The channels just get values clients channel ‘by’ the rundown, which can’t be utilized to ascertain.
The clients can powerfully change the measurements and measures in parameter however channels don’t favor the component.
Q4) Clarify the reality table and the measurement table?
They are the quantifiable amounts or the numeric measurements of the information which can be investigated by measurement table. Actualities are put away in the reality table contain remote keys that interestingly alludes to the related measurement tables. The reality table is good to store the information at the nuclear dimension and in this way, it enables an extensive number of records to be embedded on the double.
For example, a business classification actuality table can have an item key, client key, advancement key alluding to an explicit occasion.
They are the engaging trait esteems for different elements of each quality which characterize various attributes.
A measurement table alluding an item key from the reality table can comprise of an item name, item type, shading, size, and depiction.
Q5) What are the confinements of parameters of Tableau?
Answer: The parameters of Tableau can be spoken to just in four different ways on a dashboard. The parameters don’t permit any further various choices in a channel.
Q6) Clarify the accumulation and disaggregation of information in Tableau?
Answer: Accumulation and disaggregation of information in Tableau are the approaches to build up a scatterplot to gauge and look at the information esteems.
It is determined the type of a lot of esteems that arrival a solitary numeric esteem. A default total can be set for any measure which isn’t client characterized.
The disaggregation of information alludes to see every datum source push amid breaking down of information both conditionally and freely.
Q7) What are setting channels and express the restrictions of setting channel?
Scene helps in making the sifting procedure clear and simple.
It does as such by making a chain of importance of sifting, where the various residual channels that are available allude to the setting channel for all their resulting tasks.
Along these lines, the rest of the channels will currently process the information, that is as of now gone through the setting channel. Improvement of at least one setting channels helps in enhancing the execution, as the clients don’t need to make additional channels on the substantial information source, which really diminishes the inquiry execution time.
Impediments of setting channel:
For the most part, Tableau sets aside a brief period for setting a channel in setting.
On the off chance that the channel is set as a setting one then the product builds up a brief table for that explicit setting channel.
This table reloads each time and comprises of the considerable number of factors and qualities that are not sifted by setting or custom SQL channel.
Q8) Notice some document augmentation in Tableau?
Answer: There are many document types and augmentations in Tableau.
A portion of the document expansions in Tableau are:
Scene Workbook (.twb).
Scene Packaged Workbook (.twbx).
Scene Datasource (.tds).
Scene Packaged Datasource (.tdsx).
Scene Data extricate (.tde).
Scene Bookmark (.tdm).
Scene Map Source (.tms).
Scene Preferences (.tps)
Q9) What are the concentrates and plans for Tableau server?
First duplicates or subdivisions of the real information from the first information source are called information remove.
The exercise manuals which utilize the information separates as opposed to utilizing live DB associations are quicker and the removed information is foreign made into Tableau motor.
Later after the extraction of information the clients can distribute the exercise manuals which distribute the concentrates in Tableau server.
What’s more, the planned boosts are the booking errands which are as of now set for information remove invigorate so they get revived consequently while an exercise manual is distributed with information extraction.
Q10) Notice and clarify a few parts on the dashboard?
Answer: A portion of the dashboard parts are:
Level segment: In the dashboard the flat part’s holders enable the creator to consolidate the worksheets and dashboards segments from left to appropriate over the client’s page and the tallness of the components are altered without a moment’s delay.
Vertical part: In the dashboard Vertical segment’s compartments enables the client to join the worksheets and dashboard parts from left to appropriate over the client’s page and the width of the components are altered without a moment’s delay.
Content: It is an in sequential order arrange.
Picture Extract: A Tableau is in XML organize. In the event of extricating pictures, the Tableau applies the codes to separate a picture can be put away in XML.
Web [URL ACTION]: A Web URL activity is a particular kind of hyperlink that coordinates to a page dependably or to some other online asset that is dwelling outside of Tableau. The client can consequently utilize the URL activities for connecting up of more data about the client’s information, which may be facilitated outside of the client’s information source. All together make the connection pertinent to the client information, the client can substitute field estimations of a choice into the URL as parameters.
Q11) How might you characterize a dashboard?
Answer: A dashboard is a data the board gadget that outwardly tracks, investigates and demonstrates key execution markers (KPI), estimations and central matters which center around the screen to screen the soundness of a business, division or specific process. They are versatile to meet the specific needs of an office and friends. A dashboard is the most capable way to deal with track various information sources since it gives a focal region to associations to screen and look at execution.
Q12) What is a Column Chart?
Answer: A Column diagram is a practical graphical portrayal of information. Section diagrams indicate vertical bars going over the outline on a flat plane, pivot having values are shown on the left-hand side of the chart. Segment diagrams and a different number of various sorts of charts are regularly made in spreadsheet programs, for example, Microsoft Excel or Open Office Calc. Segment outlines can be used to demonstrate a broad scope of data, for instance, deals designs, stock esteem changes, and precipitation sums by year.
Q13) What is Page Shelf?
Answer: Scene gives an unquestionable and useful asset to control down the yield show, which is known as Page rack. As the name suggests, the page rack parts the view into a progression of pages, showing a substitute view on each page, making it simpler to comprehend and limiting looking to break down and see data and information.
Q14) What is a canister?
Answer: Canister is a client characterized assembling of measures in the data source. It is possible to make canisters concerning estimation, or numeric receptacles. You could consider the State field as different arrangements of canisters each benefit esteem is orchestrated into a container contrasting with the state from which the esteem was recorded. Be that as it may, at that point likewise, on the off chance that you need to watch out qualities revenue driven doled out to canisters without reference to estimation, you can make a numeric container, with each individual receptacle identifying with the extent of qualities.
Q15) What are the Filter Actions?
Answer: Filler exercises send information in the middle of worksheets. Ordinarily, filler activities transmit information from a chose stamp to another sheet demonstrating related information. Out of sight, filler exercises send data esteems from the appropriate source fields as channels to the objective sheet.
Q16) What are the Aggregation and Disaggregation?
Answer: Collection and Disaggregation in Tableau are the ways to deal with develop a dissipate plot to take a gander at and measure information esteems.
When you put a measure on a rack, Tableau thusly adds up to the data, by and large by summing it. You can without much of a stretch choose the accumulation connected to a field in light of the fact that the limit reliably shows up before the field’s name when it is put on a rack.
Disaggregating your data empowers you to see each line of the data source, which can be useful when you are separating measures that you may need to use both uninhibitedly and restrictively in the view.
Q17) What is Assume referential uprightness?
Answer: In Database terms, each line in the assurance table will contain a blend roe in estimation table. Using this procedure, we fabricate Primary and Foreign Keys for joining two tables. By picking Assume Referential Integrity, you uncover to Tableau that the joined tables have referential respectability. In another word, you are affirming that the reality table will reliably have an organizing line in the Dimension table.
Q18) Where would you be able to utilize worldwide channels?
Answer: Worldwide channels can be used as a piece of sheets, dashboards and in stories.
Q19) What is the Context Filter?
Answer: Setting channel is a to a great degree gainful channel from the majority of the channels in Tableau. It upgrades the execution in Tableau by making a Sub-Set of data for the channel determination.
Setting Filters fill two main needs
Enhances execution: If you set a ton of channels or have a far reaching data source, the request can be moderate. You can set somewhere around one setting channels to improve the execution.
Creates top N channel you could set a setting channel to fuse only the information of intrigue, and after that set a numerical or a best N channel.
Q20) What are the Limitations of setting channels?
Answer: Here are a portion of the impediments of setting channels:
The customer doesn’t routinely change the setting channel – if the channel is changed the database must re-process and modify the short lived table, abating execution.
When you set estimation to setting, Tableau makes a transient table that will require a reload each time the view is begun.
Q21) What is information representation?
Answer: Information representation is a show if the data in a pictorial or graphical frame. It engages leaders to have look examination displayed outwardly, so they can understand testing thoughts or make new examples. With canny perception, you can make the thought a walk further by using innovation to draw them into outlines and diagrams for more detail.
Q22) For what reason did you pick information representation?
Answer: Information perception is a quick, easy to pass on thoughts all around and you can investigate diverse situations by making slight modifications. As a person forms information by using diagrams or outlines to examine complex data is stopped less demanding instead of watching out them on spreadsheets or reports.
Q23) Clarify about Actions in Tableau?
Answer: Scene empowers you to add setting and instinct to your data using activities. There are three kinds of activities in Tableau: Filter, Highlight, and URL exercises
Channel activities empower you to use the data in a single view to channel information in another as you make guided orderly stories.
Feature activities empower you to call attention to outer assets.
URL activities empower you to point to outside assets, for instance, a site page, archive, or another Tableau worksheet.
Q24) Depict the Tableau Architecture?
Answer: Scene has especially versatile, and it has a n-level client server-based plan that serves the portable clients, web clients, and work area introduced programming. Scene work area is endorsing, and distributing instruments used to make an offer the perspectives on scene server.
Q25) What is Authentication on Server?
Answer: A confirmation server is an application that empowers validation of a component that attempts to get to a system. Such a substance may be a human customer or another server. A verification server can abide in a devoted PC, an Ethernet switch, a passageway or a framework which is gotten to by the server.
Q26) For what reason do you distribute an information source and exercise manuals?
Answer: Information sources and exercise manuals are distributed when you have to augment the gathering of people for your information investigation inside your affiliation. By distributing you can begin to do the accompanying:
Team up and offer with others
Concentrate data and database driver organization
Q27) What makes up a distributed information source?
Answer: The information association data that delineates what data you have to secure to Tableau for investigation. When you connect with the information in Tableau Desktop, you can make joins, including joins between tables from different information types. You can rename fields on the Data Source page to be progressively expressive for the general population who work with your conveyed information source.
Q28) What is Hyper?
Answer: Hyper is a to a great degree superior in-memory data motor development that empowers customers to dissect expansive or complex instructive sets speedier, by capably evaluating logically questions explicitly in the esteem based database. A center Tableau arrange advancement, Hyper uses prohibitive interesting code age and bleeding edge parallelism methods to achieve fast execution for the different creation and question execution.
Q29) What is VizQL?
Answer: VizQL is a visual request dialect that deciphers rearranged exercises into information questions and after that imparts that data outwardly.
VizQL passes on emotional gains in people’s ability to see and comprehend data by abstracting the shrouded complexities of inquiry and examination.
The outcome is an instinctual client experience that offers individuals to answer inquiries as fast as they can think about them.
Q30) What is a LOD articulation?
Answer: LOD Expressions offer approach to viably register accumulations that are not at the dimension of detail of the representation. You would then have the capacity to organize those qualities inside perception in subjective ways.
Q31) What is a Gantt graph?
Answer: A Gantt diagram is an important graphical gadget, which exhibits assignments or exercises performed against time. It is additionally called the visual introduction of an assignment where the exercises are isolated and appeared on a diagram, which makes it is direct and translate.
Q32) What is a Histogram diagram?
Answer: A histogram is a plot that allows you to discover, and appear, the essential recurrence (shape) of a plan of persistent data. This permits the examination of the data for its shrouded conveyance, oddities, smoothness, etc.
Q33) What are the sets?
Answer: Sets are custom fields that portray a subset of data dependent on few conditions. A set can be established on a handled condition, for example, a set may contain customers with deals over an explicit edge. Processed sets refresh as your data changes. On the other hand, a set can be established on specific data point in your view.
Q34) What are gatherings?
Answer: A gathering is a mix of estimation individuals that make higher sum classes. For example, in the event that you are working with a view that demonstrates typical test scores by significant, you may need to aggregate certain majors to make genuine classifications.
Q35) At the point when do we use Join versus mix?
Answer: On the off chance that data situates in a solitary source, it is always attractive to use Joins. Right when your data isn’t in one place mixing is the most attainable approach to make a left join like the relationship between your essential and assistant information sources.
Q36) What is a Stacked Bar outline?
Answer: A stacked bar graph is an outline that uses bars to show relationships between’s classes of data, anyway with the ability to separate and take a gander at parts of a whole. Each bar in the diagram addresses a whole, and sections in the bar address different parts or classes of that entirety.
Q37) What is a Scatter Plot?
Answer: The dissipate plot graphs are sets of numerical data, with one variable on each hub, to look for a connection between them. On the off chance that the components relate, the focuses will fall along a line or twist. The better the association, the more firmly the focuses will join to the line.
Q38) What is a Waterfall diagram?
Answer: A normal cascade outline is used to demonstrate how an underlying quality is extended and decreased by a progression of transitional qualities, inciting a last esteem. A cascade diagram is a kind of data discernment that helps in understanding the aggregate effect of successively displayed positive or negative qualities. These qualities can either be time-ward or classification based. The cascade diagram is known by another name, which is known as a flying blocks chart or Mario plot in light of the conspicuous suspension of areas (blocks) in mid-air.
Q39) What is a TreeMap?
Answer: A treemap is a visual procedure for indicating different leveled data that usages settled square shapes to address the parts of a tree outline. Each square shape has a domain relating to the measure of data it talks. A treemap is produced using a tiling figuring planned to give each square shape a perspective proportion of one and make a sentiment of request in the showcase of the information.
Q40) What are intelligent dashboards?
Answer: Dashboards which enable us to associate with various segments like channels, parameters, exercises and slice up the data to hint at enhancement encounters or answer complex inquiries.
Q41) What are diverse site jobs we can dole out to a customer?
Answer: Site jobs are endorsement sets that are allocated to a customer, for instance, System Administrator, Publisher, or Viewer. The site jobs portray aggregations of limits that can be surrendered to customers or gatherings on Tableau Server.General site jobs, which we can relegate to a customer are as per the following :
Server Administrator: This job has full access to all servers and usefulness of the site, all substance on the server, and all customers.
Site Administrator: By doling out this job one can oversee gatherings, exercises, undertakings, exercise manuals and data hotspots for the site.
Distributer: Publishers can sign in, speak with distributed perspectives and distribute dashboards to Tableau server from the work area.
Q42) What are Table Calculations?
Answer: It is a change you apply to the estimations of a solitary measure in your view, in light of estimations in the dimension of detail.
Q43) What is a Published information source?
Answer: Distributed information sources are not too easy to use. Different thing imperfections or plan oversights could have baffled the allocation of server-based information sources.
Distributing information sources to the server empower us to Unify data sources Offer them with all the approved customers
Increment exercise manual transferring/distributing speed
Timetable data refresh with portrayed recurrence
Q44) What is a Hierarchy?
Answer: Chain of importance in Tableau gives penetrate down movement to the Tableau report. With the help of little + and – images, we can investigate from a bigger dimension to settled dimension or lower level. When you interface with a data source, Tableau therefore isolates date fields into orders so you can without a lot of a stretch separate the viz. You can likewise make your specific progressions.
Q45) What is a check card in Tableau?
Answer: The Marks card is a key part for visual examination in Tableau. As you drag fields to various properties in the Marks card, you add setting and detail to the imprints in the view. You use the Marks card to set the stamp compose and to encode your data with size, shading, content, shape, and detail.
Q46) What is a Tableau information sheet?
Answer: After you interface with your data and set up the data source with Tableau, the information source affiliations and fields appear on the left 50% of the exercise manual in the Datasheet.
Q47) What is a Bullet diagram?
Answer: A projectile chart is an assortment of a visual diagram made by Stephen Few. Moved by the customary thermometer outlines and advance bars found in various dashboards, the shot diagram fills in as a substitution for dashboard checks and meters. Shot chart was created to conquer the foremost issues of checks and meters they typically indicate too little information, require over the top space, and are scattered with pointless and diverting enhancement.
Q48) What is a Choropleth Map?
Answer: Choropleth Maps demonstrate detached land districts or regions, which are hued, shaded or planned regarding data variable. This gives a way to deal with imagine esteems over a topographical locale, which can demonstrate assortment or examples over the showed region.
Q49) How might you enhance dashboard execution?
Answer: Here are a portion of the approaches to enhance dashboard execution:
Use a concentrate Extracts are a simple way and quickest way to deal with make most exercise manuals run snappier.
Lessen the extension whether you’re making a view, dashboard, or story, it’s luring to pack a significant proportion of information into your perception since it’s so normal to add more fields and counts to the view and more sheets to the exercise manual. Thus, along these lines, the outcome can be that the perception ends up being slower and slower to render.
Use Context channel making something like one setting channels upgrades execution as customers don’t have to make extra channels on a broad information source, decreasing the inquiry execution time.
Q50) Contrast among Tiled and Floating in Tableau Dashboards
Answer: Tiled things are sorted out in a solitary layer network that alters in a measure, which depends on the aggregate dashboard estimate and the items around it. Coasting things could be layered over different items and can have a perpetual size and position.
Drifting Layout While most inquiries are tiled on this dashboard, the guide view and its related shading legend are skimming. They are layered over the reference diagram, which uses a tiled design.
Q51) What is Data Visualization?
Answer: Data Visualization – Representing the information and data in the graphical manner like charts, graphs, maps, pictures, diagrams etc. Using data visualization, we can understand and see the trends, patterns, and outliers in data.
Q52) What are the different types of visualizations available?
Answer: Right visualization must be paired with the right data or information.General Types of visualization: Charts, Tables, Maps, Graphs, Infographics, and Dashboards.Example of methods to visualize data:
Heat Map, Bar Chart, Bubble Cloud, Cartogram, Gantt chart, Histogram, Area Chart, Scatter Plot, Tree Map, Streamgraph etc.
Q53) Name some of Business Intelligence/Visualization tools?
Answer: Tableau, Microsoft Power BI, Oracle BI, Qlikview, IBM Cognos, Google Analytics etc.
Q54) What are the file types available in Tableau?
Answer: Tableau Workbook (.twb), Tableau Packaged Workbook (.twbx), Tableau Data Source (.tds), Tableau Packaged Data Source (.tdsx), Tableau Bookmark (.tbm), Tableau Data Extract Files (.tde).
Q55) What is Data Source tab in Tableau?
Answer: Data Source tab is used to connect to different data sources such as Files (Microsoft Excel, Text Files, PDF, and Statistical Files etc.), Servers (MS SQL Server, My SQL, Oracle, Teradata, IBM DB2, and PostgreSQL etc.).
Q56) What are the Dimensions and Measures in Table sheets?
Answer: Tableau divides the data in 2 parts.
Dimensions: Dimensions are the fields which cannot be aggregated.
Measures: As name suggests, Measures are the fields which can be aggregated (Like calculation).
Q57) What are the Tableau versions/Products available?
Tableau Desktop: All development such as creating reports, charts, and dashboards will be done in Tableau Desktop. And is used to Analyze and Visualize data. We can save the work done locally and can publish on Tableau Server.
Tableau Prep: is designed to make preparing the data for analysis. We can use the Tableau Prep to combine, shape, and clean the data for analysis.
Tableau Online: Tableau Online is your analytics platform fully hosted in the cloud. Publish dashboards and share your discoveries with anyone.
Tableau Server: Can publish the dashboards on Tableau Server which we creates on Tableau Desktop.
Q58) What are the types of filters available in Tableau?
Answer: Extract Filters, Quick Filters, Context Filters, Data Source Filters, and Measure Filters.
Q59) How many tables can we join in Tableau?
Answer: We can join maximum 32 Tables and Max 250 columns can be there in a Table.
Q60) What are the types of Joins available in Tableau?
Answer: There are four types of joins are available. They are inner join, left join, right join, full outer. These joins are same as SQL joins.
Q61) What are the connections that you can make with your Data?
We can make 2 types connections with the Data set.
- Live: Using Live connection, Tableau consumes data from the Databases/Servers.
- Extract: We can Extract the Data from the Database to Tableau, so the data will be saved in your local system.
Q62) How many ways can we use parameters in Tableau?
Answer: We can use parameters – Calculated Field, Actions, Changing views, Filters, Auto Updates, and Measure swap.
Q63) What is the difference between Embedded Data source and Published Data sources?
Answer: Published Data Sources contains connection information and that is independent of any workbook.
Embedded Data Source contains connection information and is dependent (associated) with a workbook.
Q64) What is VizQL in Tableau?
Answer: VizQL stands for Visual Query Language. It’s evolved at Stanford from the Polaris system, which combined analysis, query, and visualization into a single framework.
Q65) What is Hyper technology in Tableau?
Answer: Hyper – is a high performance in-memory data engine technology that helps clients to analyze large data sets faster by efficiently evaluating analytical queries directly in the transactional database.
Q66) How does Tableau works?
Based on 3 simple steps, Tableau work
Connect: Connect Tableau to any File or Database/Server.
Analyze: Analyzing the data – which means filtering, sorting, summarizing, calculations, etc.
Visualize: Visualizing the data in terms of charts, graphs, maps etc.
Share: We can share Tableau workbooks with other Tableau users.
Q67) Difference between Joining and Blending?
Answer: When we are combing the data from the same source, we use joins. Whereas Blending requires two completely defined data sources.
Q68) What are LOD Expressions in Tableau?
Answer: Level Of Detail (LOD) expressions provide a way to easily compute aggregations which are not at the level of the visualization.
Q69) Components of a Dashboard in Tableau?
Answer: Horizontal, Vertical, Text, Image Extract
Q70) What is dual axis in Tableau?
Answer: Dual Axis – helps users view two scales of two measures in the same graph. Dual axes let user to compare multiple measures at once, having two independent axes layered on top of one another.
Q71) What is the Forecasting in Tableau?
Answer: Forecasting – is the predicting the future values. Tableau uses exponential smoothing model.
Q72) Aggregation and Disaggregation of data in Tableau?
Answer: To compare the data values in Tableau we use 2 ways. Those are Aggregation and Disaggregation.
Q73) What are the Sets in Tableau?
Answer: Sets are custom fields that are created in Tableau which define a subset of data based on some conditions.
Q74) What are dimension table and fact table?
Fact Table: Fact tables are the measurable quantities of the data which can be analyzed by the dimension table. It’s a primary table in a dimensional model.
Dimension Table: A dimension table referring a product key from the fact table. It contains dimensions of a fact.
Q75) Difference between Tree map and Heat map?
Answer: To illustrate hierarchical data and part to whole relationships, we use tree maps whereas Heat map is used to compare categories using color and size.
Q76) What is Workbook, Worksheets, Story and Dashboard in Tableau?
Answer: Tableau uses Workbook and Worksheet file structure like as Microsoft Excel. A Worksheet contains a single view along with legends, shelves and the Data pane. A Dashboard is a collection of views of multiple worksheets. A Story is to convey the information.
Q77) How does the integration of Python works in Tableau?
Answer: Python is used for statistical analysis. Tableau Desktop can connect to Python with Tabpy. Tabpy is a new API that enables evaluation of Python code from within a Tableau workbook.
Q78) What is Tableau Server?
Answer: Tableau server is a mobile and browser based application that anyone can use. We can publish the dashboards using Tableau Desktop and can share throughout the organization.
Q79) What are Global filters in Tableau?
Answer: Global Filter helps to share the same filter using the same source data across multiple worksheets within a workbook. We can apply global filter for all the work sheets using the same data.
Q80) In View, how will you change the Null Value as N/A?
Answer: We can eliminate the Null values using Filter. And, We can also use Calculated field to convert Null values as Zeros using ISNULL function.
Q81) What could be the possible reasons for the slower performance of Table?
Answer: More filters, Extracts, and depends on the data source.
Q82) Difference between continuous and discrete in Tableau?
Answer: Fields can be either discrete or continuous in Tableau. The values are continuous by default, when we drag the fields from the Measure are to Columns or Rows.
Continuous: These data roles are used to measure the continuous data and can take on any value.
Discrete: Data can take only on integer values.
Q83) If Extract – refresh fails, can we get any notification?
Answer: Yes, when a schedule refresh fails we can get an email alert. Tableau server 10 included email notification feature. When a failure occurs it alerts all affected areas, and it will suggest a fix for the failure.
Q84) What are embed views?
Answer: We can embed interactive tableau dashboards and views into web pages, web applications, and blogs etc. When workbooks are updated on Tableau server or Tableau online, embedded views will be updated
Q85) What are the levels of security in tableau?
Answer: Tableau server levels of security has 4 main parts. Permissions, Site roles, Row-level security, and Database security.
Q86) How do you take a backup from the Tableau Server?
Answer: Taking regular Tableau Server backup is an important step. We can use the command tsm maintenance restore to restore the backups which created using tabadmin backup and tsm maintenance backup.
Q87) Explain server process status in Tableau?
Answer: Tableau server process status will show Active, Busy when Tableau server is functioning properly. Below are the some status:
Down: Message: Node Degraded/Data Extracts unavailable
Busy: Message: Synchronizing/Decommissioning
Q88) How will you handle time out error?
Answer: The Timeout error occurs when publishing or Viewing a workbook on Tableau server. There are 2 main Tableau server timeout settings are gateway.Timeout and vizqlserver.querylimit
Q89) What are the Tableau Server supported platforms?
Answer: Tableau Server can be installed on Windows Server 2016, Windows Server 2012, Windows Server 2008 R2, Windows 7, Windows 8. We can install Tableau Server on a combination of Windows and Linux computers.
Q90) What is the custom geocoding in Tableau?
Answer: Tableau can’t map if you have locations, such as street address, we can use custom geocode those locations. We can assign latitude and longitude to our locations so Tableau can plot them accurately.
Q91) How will you join two different data sources in Tableau?
Answer: Using Cross-Database join, we can combine tables from different data so
Q92) What are the Green and Blue pills highlighted in the Tableau Measures and Dimensions?
Answer: Tableau characterizes data differently in the view depending on whether the field is discrete, or continuous. Green measures and dimensions are continuous. Blue measures and continuous are discrete.
Q93) Name some the functions available in Tableau?
Answer: Number Functions, String Functions, Date Functions, Logical Functions, Type Functions, Aggregate Functions, and Pass-through functions.
Q94) How would you change a field from discrete to continuous?
Answer: On the Data pane, Right click the field and select Convert to Continuous. The field turns green.
Q95) Which map service Tableau uses?
Answer: We can connect to map servers using the Web Map Service (WMS) protocol. It’s a standard protocol for receiving and requesting geographically referenced images.
Q96) What is the error in Tableau “Cannot mix aggregate and non-aggregate together”?
Answer: The error occurs in Tableau desktop environment. All fields should be either aggregate or non-aggregate. Use a LOD (Level of Detail) expression to make an aggregation, non-aggregation. All LOD expression returns non aggregated values.
Q97) What are the Pill types in Tableau?
Answer: Four Pill types are available in Tableau. Those are Discrete Dimension, Continuous Dimension, Discrete Measure, and Continuous measure.
Q98) What is Data Blending in Tableau?
Answer: Data Blending: is a powerful feature in Tableau. Data Blending is combining multiple data sources into the same view where there is a related data.
Q99) What is tableau and what are the Tableau products ?
Answer: Tableau is a data visualization tool. And tableau has below mentioned products
Q100) What are the role in Tableau ?
Answer:Tableau has Tableau developer ,Tableau Admin, Tableau Support and Tableau End user roles.
Q101) How you define granularity or grain?
Answer:The lowest level at which data is maintained in data warehouse is called grain. Like Complete, Integrated, static, summarized.
Q102) How you define Tableau desktop ?
Answer:It is a desktop application.(Needs Installation).It is a developer tool. By using this we create Sheets, dashboards and story.
Q103) How you define Sheet ,Dashboards and Story in tableau?
Answer: Views in Tableau are called Dashboards can contain one or more Sheets. Story can contain one or more Dashboards.
Q104) What are the pages you come across in Tableau ?
Answer:While Working in Tableau Desktop you will use Connect, Data source page, Sheet, Dashboard, Story.
Q105) How you define Live and Extract connection in Tableau ?
Answer:There are two types of connections in Tableau.1.Live 2.Extract
In live connection, If anything changes in connected databases (used objects) ,it will reflect in tableau. You do not need to refresh it explicitly.
But in Extract it creates a snapshot of your used object at that exact time for you to use. And to get recent data you have to explicitly refresh the object (table /view).
But most of the times we use Extract connection to develop the reports so that the data wont change in between the development.
Q106) What are the filter you get in Data source page?
Answer: Data source and Extract filter you get in Data source page.
Q107) What are data types you get in Data source filter?
Answer: Character, Number, Dates are the data types you get in Data source filter.
Q108) How you define joins and join calculations in Tableau?
Answer:Joins are used to extract data from more than one table .Todefine join you need to have a column.
Name might be different but nature of data should be same.
If you extract data from tables without join is called Cartesian join /Cartesian data. Tableau does not support Cartesian join/Cartesian data.
By default tableau joins on same named field with a inner join type.
If the common column format is not same that can be achieved by using join calculation.
Q109) How you define Aliases in Tableau ?
Answer:The alternative names to dimension members is called aliases. It supports data like String, Date, Geo, Number, etc.
Once you define Aliases it will show only alias names in report until and unless you remove aliases.
Q110) How you define Split in Tableau?
Answer:Split is used to divide the fields in to two or more using delimiters. We can apply split only on the strings.
Q111) How you define Pivot in Tableau ?
Answer:Pivot is used to convert cross tab template data to column based/stored table. If you want to do pivot you need to select more than one field in data set.
Q112) How you define Dimensions and Measures ?
Answer: All numbers continuous fields will be referred as Measures.(#Green Color)
All discrete fields (Except Number Continuous) will be referred as Dimensions.(Abc Blue Color)
Q113) What are the default fields in Tableau ?
Answer: Measure Names, Measure Values, Number of Rows ,Latitude and Longitude are the default fields in tableau.
Q114) How you define Hierarchy in tableau ?
Answer: Hierarchy is used to drill down the report. Tableau date fields are by default holding hierarchy. We can define hierarchy only on dimension field.
Q115) What are the different shelves present in sheet page of Tableau?
Answer: Data , Analytics, Pages, Filters, Marks ,Columns, Rows, Show Me are different shelves in Tableau.
Q116) How you define Show Me in Tableau?
Answer: Show Me got 24 charts and helps you perform a chart just by clicking the right dimensions, measures and chart type.
Q117) What are components of Data shelves in Tableau?
Answer: Dimension, Measure, Sets, Parameters are different components in Tableau.
Q118) What are the different Marks present in tableau ?
Answer: Color , Size, Text, Detail, Tooltip are the different marks present in tableau.
Q119) How you define Hierarchy in Tableau?
Answer: Hierarchy is mentioned or done as per business Implication. It is actually parent-child relationship.
If I say about Sample Super Store >> Category(Parent) >>Sub-Category(Child) By default, Tableau gives hierarchy in dates . Year>>QTR>> Month
Q120) What is path in tableau?
Answer: Path is one of the types of Mark. It will enable only for line chart.
The path forms based on date fields . If you want to define the path based on measure that can be done by calling measures into the path.
Q121) How you define groups in tableau?
Answer: Group helps to group data in higher level and lower granularity. Like, Different states you group to make region (East/South).
Q122) How to create groups in tableau?
Answer: Select the required field in data panel. Right click and select >> Create Group. Then we will be getting a window to create required group. You can not group the measures. But you can Bin them.
Q123) Can groups be used in calculated field?
Q124) How you define and create calculated field in tableau?
Answer: Calculated field helps you define the calculation based on measure and salary.
Like If you have Salary measure and bonus measures and asked to find out new salary you Can define calculated field
New Salary= [salary]+[salary]*[bonus%]
You can create calculated field by right over dimension or measure or Data shelf.
Q125) How you define Sets in Tableau?
Answer: Sets are used to categorize your data into In or Out based on condition.
Q126) What is the basic difference between Sets and groups ?
Answer: Unlike group set will let you define a condition. Unlike group it can be done on measures.
Q127) Syntax of creating sets using calculated field?
Answer: If sum[sales] > $1,50,00 Then ‘IN’
Q128) How you define Bins in Tableau?
Answer: Bins are used to convert continuous measure into discrete dimension. Bins are used on Histogram Chart.Once you define a bin a new dimension field will be created.
Q129) For Which data types you can not create a Bin?
Answer: For Cube or multi dimensional data source you can not create a bin.It can be only defined for relational data bases.
Q130) How you define sorts in tableau?
Answer: Sort is used to order the data in sheet. In Tableau the sheet data will be ordered based on Dimension(Ascending) which we use in sheet.
Q131) How you define Custom SQL in Tableau?
Answer: In Tableau you can directly paste SQL query using Feature Custom SQL. Drag New Custom SQL and paste your query and It will give you SQL DB result.
Q132) How you define union in Tableau ?
Answer: Union is used to combine two or more tables by appending Data. You need to follow below rules while doing union.
1.No of columns should be same.
2.Data type should be same.
Q133) How you define data blending in tableau?
Answer: Data blending is a powerful feature in tableau. It allows you to use the data from multiple data sources in the same view. Often these data sources are of different types (Like SQL & Excel)
Q134) Difference between joining and data blending?
Answer: Joins are accomplished in a single query and results are matched row by row.
Data blending occurs by issuing two separate queries and blend together the aggregated result.
There can be one primary source but there can be as many secondary source as you desire.
Q135) How you define Annotations in Tableau?
Answer: Annotations can be used to display values of data/Text and give explanation to your view.
Q136) How you define Reference lines in Tableau?
Answer: Reference lines are often used in highlighting a desired portion of visual chart. A reference line is a line that is drawn across the numeric axis of a chart. It denotes a value like sum, average.
Q137) How you define trend line in Tableau?
Answer: Trend line defines a trend considering underlying marks in a visual chart. To have a trend line in your view both Column and row shelves should contain a numeric value.
Q138) How you define parameters in Tableau?
Answer: There are situations where you want to take user’s input and dynamically want the view to behave as per user’s input. There you need a parameter and pass the value through parameter.And parameter need to be passed through filter/calculated field, then only it will work.
Q139) How define Worksheet Actions?
Answer: Worksheet actions are dashboard actions. It can be Filter, Highlight or URL.
Q140) Give me some Example of calculated field function?
Q141) What are all LOD functions available and What is LOD?
Answer: LOD is level of Detail. You can achieve a certain level of aggregation without changing the map. Include ,Exclude and Fixed are LOD functions.
Q142) Gantt chart needs how many measures and dimensions?
Answer: 1 or more Dimension , 0 or 2 Measure
Q143) How you define cross tab in Tableau?
Answer: Text table chart is called cross tab in Tableau.