Data Analyst Free Practice Exam

Tuesday, December 14th, 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.

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

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]

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.

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.

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:
ques-5

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))

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.

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

8. To create a set containing top 10 States by profit you need in this case to:
ques-8

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.

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.

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

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

12. What will happen in the given table if you change Compute by option to “Table down”?
ques-12

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

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

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])}

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])

16. What kind of colorscale is in the view?
ques-16

Discrete

Continuous

Discrete based on 3-element category

Continuous with 3 steps

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

18. Which kind of calculation would be suitable to count the number of States in the view:
ques-18

COUNT([State])

RANK([State])

COUNTD([State])

INDEX([State])

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

20. Which option would you choose to set labels as shown in the picture:
ques-20

Min/Max and Table

Min/Max and Pane

Min/Max and Line/Pane

Min/Max and Cell

21. You use a table from an Excel file. What will happen to the table after using Data Interpreter?
ques-21

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

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)

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)

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)

25. The right Mark Type to use when creating a highlight table would be:

Density

Square

Polygon

Area

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)

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 Upper text menu choose Trend Lines/Show Trend Lines

All of above

None of above

a), b), c)

a), c), d)

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?
ques-28

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

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)

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

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

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

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

34. To show Totals as shown below you should:
ques-34

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

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:
ques-35

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

Time is Up!

Time's up

2 thoughts on “Data Analyst Free Practice Exam”

raul jaramillo says:
August 9, 2022 at 10:12 pm
me gustaria tener la guia
Reply
1. Narcis says:
  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

Get Tableau Certified with Training & Practice Tests

Get Tableau Certified with Training & Practice Tests