This page was exported from Free valid test braindumps [ http://free.validbraindumps.com ] Export date:Sun Apr 13 1:12:00 2025 / +0000 GMT ___________________________________________________ Title: [Q73-Q95] Updated Desktop-Specialist Dumps PDF - Desktop-Specialist Real Valid Brain Dumps With 150 Questions! --------------------------------------------------- Updated Desktop-Specialist Dumps PDF - Desktop-Specialist Real Valid Brain Dumps With 150 Questions! 100% Free Desktop-Specialist Exam Dumps Use Real Tableau Desktop Specialist Dumps Tableau Desktop Specialist Exam is a certification program that is designed for individuals who want to prove their expertise in Tableau Desktop. Desktop-Specialist exam is designed to validate the skills of individuals who have experience working with Tableau Desktop and are familiar with its features and capabilities. Desktop-Specialist exam is designed to test the knowledge of candidates in areas such as data analysis, visualization, and dashboard creation. It is an industry-recognized certification that can help individuals stand out in the competitive job market.   QUESTION 73The row and column shelves contain ___________________  Pills  Grand Totals  Filters  Parameters ExplanationWe can drag fields from the Data pane to create the structure for your visualizations.The Columns shelf creates the columns of a table, while the Rows shelf creates the rows of a table. You can place any number of fields on these shelves.These FIELDS are also referred to as PILLS. See below:QUESTION 74Data blending simulates a traditional _________________ Join  Inner  Right  Full Outer  Left ExplanationData blending simulates a traditional left join. The main difference between the two is when the aggregation is performed. A join combines the data and then aggregates. A blend aggregates and then combines the data.From the official website:QUESTION 75A Tableau Support case can be opened in which of the following valid ways?  Using the Developer Community Forum  Contacting Salesforce using their website  Using the support option on the Tableau website  Using the Tableau learn website ExplanationIt is possible to open a Tableau support case by visiting the following link :https://www.tableau.com/support/caseQUESTION 76True or False: To concatenate fields, they must be of same data type  True  False ExplanationYes! To concatenate fields, they must be of same data type. However, there is a workaround which we can use– Type casting. See below:Here, State and City are Strings, but Postal Code? Nope. It’s an Integer. So we can simply use the STR() function to convert it into a String, and hence the entire equation becomes valid!QUESTION 77Question 30: SkippedUsing the CoffeeChain table, create a scatter plot of Profit (x-axis) vs Sales (y-axis) broken down by State.Add a Linear trend line to the view. What is its R-squared value?  0.783262  0.739284  0.759329  0.748472 ExplanationTrend lines have become popular questions in recent Tableau examinations. Follow along:1) First drag Sales to the Rows shelf and Profit to the Columns shelf:cYou will only see a single mark since the view is aggregated.2) Now, break down this view by state. Drag State into Detail on the Marks shelf ( or directly to the view):3) Finally, move to the Analytics pane, and drag Trend line to the view. When you drag it, select the Linear option!:4) The following is our view. Hover over the trend line to see the R-squared value:QUESTION 78How does Tableau know at which level to aggregate values?  Values are always aggregated at the level of granularity of the worksheet.  Tableau doesn’t aggregate values, we do!  Values are always aggregated at the level of the Date Part  Aggregation is always done by using Tableau special formulas ExplanationIn Tableau, you can aggregate measures or dimensions, though it is more common to aggregate measures.Whenever you add a measure to your view, an aggregation is applied to that measure by default. The type of aggregation applied varies depending on the context of the view.When you add a measure to the view, Tableau automatically aggregates its values. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau.The current aggregation appears as part of the measure’s name in the view. For example, Sales becomes SUM(Sales). Every measure has a default aggregation which is set by Tableau when you connect to a data source. You can view or change the default aggregation for a measure-see Set the Default Aggregation for a Measure.You can change the aggregation for a measure in the view from its context menu:QUESTION 79You can use the __________________ in Tableau to clean / organise your data.  Data cleaner  Data manager  Data interpreter  Data organiser ExplanationWhen you track data in Excel spreadsheets, you create them with the human interface in mind. To make your spreadsheets easy to read, you might include things like titles, stacked headers, notes, maybe empty rows and columns to add white space, and you probably have multiple tabs of data too.When you want to analyze this data in Tableau, these aesthetically pleasing attributes make it very difficult for Tableau to interpret your data. That’s where Data Interpreter can help.QUESTION 80Using the atheletes table:i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1) ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark.(Sheet 2)Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?(Ignore any nulls / unknowns)  76.25  65.67  68.77  4.87 ExplanationPretty common question on the Tableau Desktop Specialist exam.1) First, lets create Sheet 1. For this, drag sport to the Row shelf, and Weight to the Text mark in the Marks shelf. Change its aggregation to Average:2) Now, for sheet 2 – Drag nationality to the view, and gold to the size mark in the Marks shelf.NOTE: Depending on your version of Tableau , you may need to assign a Geographical role to the nationality column first as follows:3) Now, let’s create a dashboard, and use both these sheets in it:4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows:QUESTION 81True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.  True  False ExplanationJoins combine tables by adding more columns of data across similar row structures. This can cause data loss or duplication if tables are at different levels of detail, and joined data sources must be fixed before analysis can begin.Inner joinLeft JoinBlends, unlike relationships or joins, never truly combine the data. Instead, blends query each data source independently, the results are aggregated to the appropriate level, then the results are presented visually together in the view.QUESTION 82When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.  Remote Field Name, Field Name  Local Name, Actual Name  Column Name, Actual Name  Local Field, Global Field ExplanationUsing the Sample superstore as a reference, click on the manage metadata icon as follows:We can rename a particular column name to make it easier to remember and use in Tableau. Let’s change Order ID to oID as shown:Now, we’ll see oID when using this data source in Tableau. This WILL NOT affect the original data source.The remote field name let’s us see what the name of the column is in the ORIGINAL Data source.QUESTION 83Is SUM a table calculation?  Yes  No ExplanationSUM is an aggregate function, not a table calculation!A table calculation is a transformation you apply to the values in a visualization. Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the visualization and do not consider any measures or dimensions that are filtered out of the visualization.The most common Table calculations are:Running TotalPercent DifferenceDifferencePercent of TotalRankPercentileThese can be calculated using : Table(across), Cell, or Specific dimensions!QUESTION 84Which of the following is the correct way to calculate Profit Ratio in Tableau?  Profit / Sales  Sales / Profit  SUM(Profit) / SUM(Sales)  SUM(Sales)/SUM(Profit) ExplanationTHIS IS A VERY IMPORTANT QUESTIONAggregation is an important concept to consider when creating calculated fields. A calculated field for SUM([Profit]) / SUM([Sales]) will give you a very different answer than [Profit] / [Sales], even though both formulas are valid.If you do not provide the aggregation within the calculated field, Tableau will calculate the equation for every record ( row ) in your analysis, then aggregate the answers for all of the rows together when the calculated field is added to the view.In simple terms, if specify the aggregation such as SUM, what Tableau will do is that it will first calculate the sum of the Profit column ( say x ), then calculate the sum of the Sales column ( say y ), and then simply apply x/y —> This is what we expect! Perfect!BUT, if you don’t specify the aggregation, it will go to every single ROW, perform Profit / Sales, and then aggregate the answers calculated for each row. This is simply NOT what we wan’t!An example:QUESTION 85Given a map, which of the following fields can be placed in Size,Shape,Detail,Color  Profit, State, Number of Records, Sales  Region, Country, Profit, State  Longitude, Country, State, Sales  Sales, State, Country, Profit ExplanationSince Sales is a measure, it can easily be depicted via size.To drill down and change the level of detail, Country is the correct choice since it will contain STATE. We can then depict the various states by different shapes such as circle, square etc.Finally, the Profit can be depicted via a color! Eg – Red for poor and green for excellent profits!QUESTION 86The calculation [Ship Date] – [Order Date] will return _______________  Number of orders placed in that duration  Number of days between these dates  Number of unique orders placed between these dates  Number of orders shipped between these dates ExplanationAs the names suggest, if we subtract the order date from the shipping date, we simply get the number of days between these 2 dates.We can these use this calculated field in our charts, and can use COUNT, SUM, AVG etc with them according to our need.QUESTION 87How would you calculate GDP per capita in Tableau?  SUM([GDP]/[POPULATION])  SUM([Population]/[GDP]])  SUM([GDP]*[POPULATION])  SUM([GDP]) / SUM([Population]) ExplanationGDP / Population = GDP Per CapitaHere Sum is a function, / and + are operators. On the bottom there are comments.QUESTION 88Which of the following calculations DO NOT need a quick table calculation?  Variance  Rank  Moving Average  Standard Deviation ExplanationFor Standard Deviation and Variance, we don’t need to use quick table calculations, since they are available by default. See below:However, as seen in the types of quick table calculations available in Tableau, Rank and Moving Average belong to only this category.QUESTION 89Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?  To support additional functionality such as count distinct  Fast to create  Help improve performance  To have access to the freshest possible data at all times ExplanationFrom the official documentation, the following are the major advantages of using Tableau Data Extracts:From Tableau 2020.2 onwards, .hyper is the recommended way since it is faster than .tde!QUESTION 90You can create _______________ for members in a dimension so that their labels appear differently in the view.  parameters  duplicates  copies  aliases ExplanationYou can create aliases (alternate names) for members in a dimension so that their labels appear differently in the view.Aliases can be created for the members of discrete dimensions only. They cannot be created for continuous dimensions, dates, or measures.To create an alias:1) In the Data pane, right-click a dimension and select Aliases.2) In the Edit Aliases dialog box, under Value (Alias), select a member and enter a new name.* To submit your changes: In Tableau Desktop, click OK.On Tableau Server or Tableau Online, click the X icon in the top-right corner of the dialog box.When you add the field to the view, the alias names appear as labels in the view. For example:QUESTION 91True or False : Bins can be created on dimensions  False  rue ExplanationBin are a user-defined grouping of numerical data in the data source.According to the official Tableau documentation: It’s sometimes useful to convert a continuous measure (or a numeric dimension) into bins.Have a look at the following image. When we right click a measure, we get the following options:However, for a dimension (this is because the of this dimension is a string:But what if we have a dimension of type NUMBER (NUMERIC DIMENSION)? See below:We can clearly create bins from dimensions too – they just have to be numeric :)For more information, please refer to: https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htmQUESTION 92Which of the following can you use to create a Histogram?  2 measures  1 measure  2 dimensions  1 dimension ExplanationA histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.The basic building blocks for a histogram are as follows:Demo :QUESTION 93________________ is hosted by Tableau to share our visualisations publically with the world.  Tableau Reader  Tableau Desktop  Tableau Server  Tableau Public ExplanationTableau Public is a free service that lets anyone publish interactive data visualizations to the web.Visualizations that have been published to Tableau Public (“vizzes”) can be embedded into web pages and blogs, they can be shared via social media or email, and they can be made available for download to other users.Check it out : https://public.tableau.com/en-us/s/QUESTION 94Which of the following charts types always includes bars sorted in descending order?  Pareto Chart  Pie Chart  Gantt Chart  Stacked Bar Chart ExplanationA Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the ascending cumulative total is represented by the line.On the primary axis, bars are used to show the raw quantities for each dimension member, sorted in descending order.On the secondary axis, a line graph is used to show the cumulative total in percent format.QUESTION 95Are animations enabled by default in Tableau?  No  Yes ExplanationNo, by default, animations are not enabled in Tableau.We can animate visualizations to better highlight changing patterns in your data, reveal spikes and outliers, and see how data points cluster and separate.Animations visually transition between filter, sort, and zoom settings, different pages, and changes to filter, parameter, and set actions. As visualizations animate in response to these changes, viewers can more clearly see how data differs, helping them make better informed decisions.When you author animations, you can choose between two different styles: simultaneous or sequential. Here are examples of each type.1) Simultaneous animationsThe default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.2) Sequential animationsSequential animations take more time but make complex changes clearer by presenting them step-by-step.To Animate visualizations in a workbook:1) Choose Format > Animations.2) If you want to animate every sheet, under Workbook Default, click On. Then do the following:For Duration, choose a preset, or specify a custom duration of up to 10 seconds.For Style, choose Simultaneous to play all animations at once or Sequential to fade out marks, move and sort them, and then fade them in.3) To override workbook defaults for a particular sheet, change the settings under Selected Sheet. Loading … Tableau Desktop Specialist Certification Exam is a comprehensive exam that covers a wide range of topics related to Tableau Desktop. Desktop-Specialist exam is designed to provide candidates with a thorough understanding of Tableau Desktop's functionality, including data preparation, visualization creation, and dashboard building. Candidates who pass the exam will have the skills and knowledge necessary to use Tableau Desktop effectively in their professional roles.   Pass Your Desktop-Specialist Exam Easily With 100% Exam Passing Guarantee: https://www.validbraindumps.com/Desktop-Specialist-exam-prep.html --------------------------------------------------- Images: https://free.validbraindumps.com/wp-content/plugins/watu/loading.gif https://free.validbraindumps.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2023-11-12 09:49:24 Post date GMT: 2023-11-12 09:49:24 Post modified date: 2023-11-12 09:49:24 Post modified date GMT: 2023-11-12 09:49:24