Data Analyst Interview Questions in San Jose, CA | Glassdoor.co.in

# Data Analyst Interview Questions in San Jose, CA, US

102

Data analyst interview questions shared by candidates

## Top Interview Questions

Sort: RelevancePopular Date

### Data Analyst at Netflix was asked...

25 May 2012
 They asked some very specific engineering related questions. 1 AnswerMy response was that I deal with data and not engineering solutions which was an honest answer.

### Data Analyst at Netflix was asked...

7 Jul 2011
 What technology or item that most people feel will be obsolete in the future do you not agree with ....1 AnswerI said paper money - their is something special about holding a dollar bill in your hand or collecting quarters in a piggy bank.

23 Aug 2010
 How many cans of blue paint were sold in the United States last year?1 AnswerThere are 300 Million people in the US. Say there are 100 Million households, in which 1% needs painting, that's 1 Million. Say there are only 1% wants to paint their houses blue, then there are 10,000 houses, which needs 6 cans, then there are 60,000 cans of blue paint for residential painting. Assume there are another 100,000 commercial buildings that paints blue, and each needs 1,000 cans. Thus the total would be 100 Million + 60,000 cans = 100,060,000 cans.

### Senior Data Analyst at VMware was asked...

3 Oct 2011
 What is your experience as DA1 AnswerI have fiv year's working experience, so I told them what did I do

### Senior Data Analyst at VMware was asked...

3 Oct 2011
 How do you validate your data2 AnswersTo see if it make sense from different source1. Look at the keys (UPC or SSN or Driver's ID, Bank account nbr etc). What are the unique keys, see if there are any NULL values. If there are then those are most likely bogus values. 2. Look at the time columns, see if the times makes sense. If you find something way back say 1900 or 2500 those are most likely placeholder values. Question why they are there? See if you can find other discrepancies. 3. Look at the facts in your data, calculate the mean and median, identify the outliers and check if they are valid or so way off that most likely are transcription or data collection errors. Build graphs to visualize. 4. Sum up all facts and see if they are reasonable. For eg you have a sales by item by day file, sum up sales for a day and check from some other source if that measure makes sense. Say, VMware sells 10 licenses a day on avg., on a given day your file says it has sold 1000 then there something wrong with the data in your file. This is a limited means of validation. It is the toughest aspect of data analysis. There are multiple biases associated with data (e.g measurement bias- too much attention to things which you can measure), and in ambiguous situations, we don't know how much proof is proof enough. Some good books: http://www.amazon.com/Bad-Data-Handbook-Cleaning-Back/dp/1449321887 http://www.amazon.com/Naked-Statistics-Stripping-Dread-Data/dp/0393071952/ref=tmm_hrd_title_0?_encoding=UTF8&sr=&qid= The chapter on biases is really good.

### Data Analyst at Intuit was asked...

28 Jan 2014
 In general, the questions are more related with your passed experience and the working knowledge regarding with the opening.1 AnswerThe question are very wild, combine technical and behavioral questions together. Be prepared with the knowledge and experience related with the job. It will be test deeply.

### Data Analyst at EXL Service was asked...

29 Mar 2019
 25 horse puzzle, 8 coins puzzle1 Answer1 . 7 RACE , 2 3 times we have to weight

### Data Analyst at Apple was asked...

25 Apr 2012
 What makes you different from the other analysts?1 Answerexample of past employer experience