Data Analyst Free Practice Exam 4 Comments / By LearningTableau / December 14, 2021 Data Analyst Free Practice Exam Just like the official Data Analyst exam, this free practice exam features 30 scored knowledge based questions, plus additional unscored questions. You cannot use outside resources for the knowledge portions of the official exam, but if you need to you can use this Data Analyst resource guide to look things up during this practice exam. Click "Next" to go to the first question. Enter Email to Take Quiz & Subscribe 1. To show top 10 products by Sales and bottom 10 in the same view you need to: Duplicate Top 10 by Sales set and change its settings to Bottom 10 and rename it. Combine Top 10 by Sales set and Top Bottom by Sales set with shared members in both sets. Place combined set on filters shelf. Click on Product Name dimension and create a Top 10 by Sales set. Combine Top 10 by Sales set and Top Bottom by Sales set with all members in both sets. Use a combined set to build a wildcard filter. a, b, d, e b, a, c, e b, a, c, f a, c, d, e None 2. You have a dataset where there is only one field for address. In some cases in includes also an e-mail address, and you need to identify the cases. Fill in the missing parts of the calculation. Full Name Address Ann Doherty 58 Bay Rd. Camel Springs, IL 60122, ann.d235@gmail.com Alice Laskowski 2180 Susan Street East Bloomfield, MI 48583 Peter Applebaum 1986 Birmingham Street Wimbledon, FL 33140 Kent Newman 946 Piper Street Epsom, MD 21921, kentnewman@swr-ltd.com _____A______ (______B_____, “@”) Choose from: STARTSWITH / FIND / CONTAINS / REPLACE Choose from: [Full Name] / [Address] CONTAINS / [Address] REPLACE/ [Full Name] FIND/ [Full Name] STARTSWITH / [Address] None 3. To use a single measure to compare values over time: POSITION 05/2019 06/2019 07/2019 08/2019 09/2019 1.1 SEO 7 283 321 7 228 349 7 560 543 7 399 761 7 579 656 1.2 PPC 340 740 164 724 329 393 343 808 350 749 1.3 Other 4 501 950 4 423 059 5 405 288 5 114 734 5 385 295 1.4 Intercompany 264 489 250 967 277 906 565 973 419 913 Merge columns from 05/2019 to 09/2019 and change the data type to Date. Pivot columns from 05/2019 to 09/2019, rename Pivot Field Name to Date and change its data type to Date. Use a wildcard pivot in Tableau Desktop to rearrange data. Use a custom split with “/“ as separator. None 4. To create a map of Sales in United States you need to drop: State pill on Color shelf, Sales on Columns and change Mark Type to Map State pill on Tooltip shelf, Sales on Color shelf and geographic field Country/ Region in the middle of working space State in the middle of working space and Sales on Color Latitude and Longitude on Detail, Sales on Color and State on Tooltipshelf. None 5. Which calculation you would use to calculate an increase in Sales from one quarter to then next in the case shown in the view: ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1) (ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1)) ZN(SUM([Sales])) - LOOKUP( (SUM([Sales])), 0) (ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Profit])), -1)) / ABS(LOOKUP(ZN(SUM([Profit])), -1)) None 6. To replace a field with another in all calculations in a workbook you need to: Replace references by choosing the option form “Data” in upper text menu Remove the field on Data Source screen and replace it with another one Replace it manually in each calculation Replace references by clicking on the field in Data section of the screen and choosing the “Replace References…” option. None 7. To perform a split without writing a calculation you need to: Go to Data Source screen, right click on fields name to find the option Drag and draw the “Split” from Analytics Pane Use a quick table calculation Go to Analysis section of upper text menu to find the option None 8. To create a set containing top 10 States by profit you need in this case to: Right click selected top 10 States and choose option Create Set… Start from creating a parameter Click a paperclip on the upper toolbar Right click on the State dimension in the data pane to be able to create the set. None 9. You have three tables. Two of them show clients in different regions, third one contains the information on frequent clients discounts. How would you prepare the data for analysis: ID Name Date Region Value DO-136452 Doug O'Kornie 13.06.2012 North 113,58 DO-136452 Doug O'Kornie 14.12.2013 North 374,058 ME-173202 Maria Eczewska 19.08.2012 North 143,88 DL-133302 Denise Leinenbach 18.04.2014 North 459,918 DL-133302 Denise Leinenbach 21.08.2013 North 78,354 DL-133302 Denise Leinenbach 29.04.2013 North 620,055 ID Name Date Value Area GG-146502 Greg Gorski 29.11.2015 1 973,30 South-West GG-146502 Greg Gorski 26.07.2013 169,74 South-West HG-150252 Gunter Schmidt 11.11.2015 349,44 South-West HG-150252 Gunter Schmidt 26.05.2013 167,58 South-West HG-150252 Gunter Schmidt 03.04.2016 97,32 South-West JW-160752 Julia East 11.11.2015 701,622 South-West ID Discount DO-136452 2,00% KD-162702 1,50% ME-173202 0,50% GG-146502 2% HG-150252 1,50% JW-160752 1,50% Join all the tables using ID as join field Use data blending to get the right level of aggregation and connect table 1 and 3, then union with table 2 Union first two tables, merge unmatched fields and then join the third table with ID as join field Union all tables then merge mismatched fields. None 10. You want to replace a data source used in your report. To do that you: Add a new Data Source, from Data menu in upper text stripe choose Replace References option and close the current Data Source Add a new Data Source, from Data menu in upper text stripe choose a current Data Source and then Replace Data Source option Go to Data Source screen, remove a first data source and add another one In the Data Source screen choose Edit Connection option and then click Replace Data Source from the menu None 11. To replace nulls with zero you can: Use either ZN([Field]) or IFNULL([Field],0) calculations You cannot do that as nulls indicate that there is no data in a database Use ISNULL([Field]) or ZN([Field]) calculation None 12. What will happen in the given table if you change Compute by option to “Table down”? Zeros will appear in each First Class row Zeros will appear in last column Zeros will appear for all cells in Central Region Zeros will appear for Central Region and First Class row None 13. To create a Show/Hide Container with filters you: Place all filters in a floating container and hide the container Place all filters in a floating container and edit a Show/Hide Button Create a Show/Hide Button and then link it to the chosen container with all filters in it Create a new floating container, place all filters in it and edit a Navigate button None 14. Which LOD calculation syntax is correct if you plan to calculate entire profit of your store since it has been opened: {TOTAL(MAX([Date])): SUM(PROFIT)} {FIXED: SUM( [Profit])} {[Profit]} {EXCLUDE [Date]: SUM( [Profit])} None 15. Which calculation would you use to get a number of a month in a year DATEPART(‘month’, [Date]) DATETRUNC(‘month’, [Date]) DATENAME(‘month’, [Date]) DATEPARSE( ‘month’, [Date]) None 16. What kind of colorscale is in the view? Discrete Continuous Discrete based on 3-element category Continuous with 3 steps None 17. A measure in your view . You need to create a dimension filter that would filter out all data to regional level. To do that you need to: Create a dimension filterwith[Region], then click on it and choose Add to Context option Create a dimension filter with [Region] and apply it to all sheets using the data source Exclude [Order date] from the FIXED calculation Create the [Region] filter and apply it also to technical filtering view None 18. Which kind of calculation would be suitable to count the number of States in the view: COUNT([State]) RANK([State]) COUNTD([State]) INDEX([State]) None 19. You are able to create a combined set when (choose the most appropriate answer): When sets there are to be combined are based on the same dimension When sets there are to be combined are based on the same measure When sets there are to be combined are share a common condition When sets there are to be combined exist in the same data source None 20. Which option would you choose to set labels as shown in the picture: Min/Max and Table Min/Max and Pane Min/Max and Line/Pane Min/Max and Cell None 21. You use a table from an Excel file. What will happen to the table after using Data Interpreter? The headers will disappear and the number of rows will increase The headers will be as in 2nd row and the number of rows will increase The headers will disappear and the number of rows will decline The headers will be as in 2nd row and the number of rows will decline None 22. The steps that will allow you to swap sheets on dashboard are: Create a parameter Create a navigate button Create a sheet with buttons Create a filter on calculated field containing a parameter Set a parameter action a), b), c), d) b), c), d), e) a), c), d), e) None 23. The steps you should take to allow user to change a measure in the view are: Create a parameter Create a set Create a filter on calculated field containing a parameter Create a calculated field containing parameter in the view Show parameter a), b), c) a), c), d) a), d), e) a), c), e) None 24. You want to create a pie chart. What you need to do is: Place a measure in Angle Shelf Place a dimension in Path Shelf Place a measure in Color Shelf Place a dimension in Color Shelf Change Mark Type to Pie chart a), d), e) a), b), c) b), d), e) c), d), e) None 25. The right Mark Type to use when creating a highlight table would be: Density Square Polygon Area None 26. To create a Gantt Chart with list and duration of tasks in your project you need to: Change Mark Type to Gantt Bar Place [Task Name] dimension in Rows Shelf Place [Start Date] in Size Shelf Place [Duration] measure in Size Shelf Place [Duration] measure Column Shelf Place [Start Date] in Column Shelf a), b), c), d) a), b), c), e) a), b), d), f) a), b), e), f) None 27. To add a trend line to the view you can (choose right answers): Click on a axis and choose Add Trend Line option Go to Analytics Pane to drag and drop to the view a trend line Click on the view and choose from menu Trend Lines/Show Trend Lines From menu choose Analyis, Trend Lines and Show Trend Lines None 28. You want to use a set to dynamically filter top 5 customers by sales in each month. How can you create such a set? Choose Customers in the view, right click and choose Create Set option Choose Customers in the view and choose Create Set icon in the tooltip Click on [Customer Name] dimension in the Data Pane and choose Create Set None of the above None 29. You want [Sales] measure in labels to be shown with one decimal place. What would be the best calculation to achieve the result? ROUND([Sales], 1) CEILING([Sales], 1) INT(([Sales], 1) FLOOR(([Sales], 1) None 30. Which option you need to choose from toolbar to export a dashboard to a Power Point presentation? Worksheet/ Export/ Image Dashboard/ Export Image File/ Export as Packaged Workbook File/ Export As Version None 31. You want to join Table A and B, and then relate them to Table C to avoid duplicating rows with tables that have different aggregation level. What should you do?Tab. A Customer ID Date Sales RP-198552 12.11.2011 551,61 RP-198552 22.03.2011 256,8 RP-198552 24.09.2012 16,74 RP-198552 14.12.2011 522,06 DJ-135102 21.01.2014 169,5 DJ-135102 24.04.2011 54,6 DJ-135102 25.12.2011 526,62 CP-123402 27.11.2011 591,3 FM-142152 08.02.2013 20,13 FM-142152 06.02.2014 132,9 IM-150552 27.11.2013 21,06 Tab. B Segment Customer ID Small Business DJ-135102 Corporate CP-123402 Corporate FM-142152 Small Business RP-198552 Corporate IM-150552 Tab. C Segment Sales Target Small Business 2500 Corporate 3000 Personal 2000 Drag tab. A to canvas, double click to open a physical layer, join the table with tab. B, close physical layer and drag Tab. C to canvas build a relation Drag tab. A to canvas and click on it to open menu to establish any type of connection – union, join or relation Double click on canvas to open a logical layer. Drag there tab. A and tab. B. Close it to add relation with tab. C in physical layer. Drag tab. A to canvas, double click to open a physical layer, relate the table with tab. B, close physical layer and drag Tab. C to canvas build a join None 32. To create a dual axis chat one has to: Place two measures either in Rows Shelf or Columns Shelf Place [Measure Names] in Filter Shelf Click on second measure pill or second axis and choose Dual Axis option Place at least one of the measures in Path Shelf Sort measures in Measure Shelf a), b) a), c) d), e) all of the above None 33. To add forecast to the view you can: Go to Upper text menu, choose Analysis/ Forecast/ Show Forecast Go to Analytics Pane, drag Forecast and drop it to the canvas Go to Analytics Pane and double click Forecast All of the above None 34. To show Totals as shown below you should: From Menu Analysis choose Row Totals to Left option From Menu Analysis choose Show Row Grand Totals and Row Totals to Left options From Menu Analysis choose Show Row Grand Totals From Menu Analysis choose Show All Subtotals None 35. You need to use a table calculation in order to remove years with uncompleted data from the table. What calculation would you use and how would you set up the filter: Calculation first()=0, set up to table across and choose False when placing it on filter shelf Calculation last()=0, set up to table across and choose False when placing it on filter shelf Calculation first()=0, set up to table down and choose False when placing it on filter shelf Calculation last()=0, set up to table down and choose True when placing it on filter shelf None Time's upTime is Up!
Narcis August 23, 2022 at 9:04 am Hello Raul, Puede encontrar la guía de solución aquí – https://learningtableau.com/download/1557/ Gracias, Narcis Reply
Lorenzo May 2, 2024 at 1:14 am This looks like a good guide to get Tableau certified! Just can’t find the dataset Reply
Narcis May 27, 2024 at 1:17 pm Hi Lorenzo, There is no dataset needed for the Free Practice Exam. Are you referring to other exam from this site? Narcis Reply
me gustaria tener la guia
Hello Raul,
Puede encontrar la guía de solución aquí – https://learningtableau.com/download/1557/
Gracias,
Narcis
This looks like a good guide to get Tableau certified! Just can’t find the dataset
Hi Lorenzo,
There is no dataset needed for the Free Practice Exam. Are you referring to other exam from this site?
Narcis