Data Analyst Questions – Explore and Analyze Data

4 Comments / By /

Use the Data Analyst resource guide to find documentation related to this topic. Go here for more data analyst practice questions.

1. You want to create a calculation that will determine the first date that a customer placed an order. Which formula should you use?

2. You have a table with order data and wish to determine the number of unique orders. The same order can appear in multiple rows. What calculation should be used?

Row_ID Order_ID Customer_Name
32298 CA-2012-124891 Rick Hansen
26341 IN-2013-77878 Justin Ritter
25330 IN-2013-71249 Craig Reiter
13524 ES-2013-1579342 Katherine Murray
47221 SG-2013-4320 Rick Hansen
22732 IN-2013-42360 Jim Mitchum
30570 IN-2011-81826 Toby Swindell
31192 IN-2012-86369 Mick Brown

3. Which of the following is a table calculation? [select all that apply]

4. What steps should be taken to add a three month moving average to the line chart?

5. Which of the following will give different results for a given value of a depending on how the data is sorted?

6. The filter shows the top 5 customers by sales, but only two customers are showing. How can the viz be adjusted to show 5 customers?

4 thoughts on “Data Analyst Questions – Explore and Analyze Data”

    1. Narcis

      Hello,

      Sum is not a table calculation. You can check the table calculations by right-clicking the measure from your visual -> Quick Table Calculations

      Hope this helps,
      Narcis

      Reply
  2. Bastiaan te Wierik

    Seems to me that the right answer to question 4 is not listed, since the moving average is standard set to ‘previous 2, next 0’ (using version 2022.2)

    Reply
    1. Narcis

      Hi Bastiaan,

      The moving average set to “previous 2, next 0” means a 3-month moving average. the naming is a little confusing, but you can check the figures and calculate and you will notice that the answer is correc – ex: February 2010 – 130534, March 2010 – 145616, April 2010 – 130543. The 3 month moving average for April 2010 is 135564 : (130534+145616+130543)/3.

      Hope this helps,
      Narcis

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to Top