Data Analyst Interview Questions | Glassdoor.co.uk

Data Analyst Interview Questions

923

Data analyst interview questions shared by candidates

Top Interview Questions

Sort: RelevancePopular Date

if there are 5 people in a room and each chooses a number from 1 to 10 at random what is the probability that two or more people have the same number

9 Answers

possible cases 10^5 favorable cases: -- exactly 2 people choose the same number: (5 choose 2)*10* (9^3) -- exactly 3 people choose the same number 5 choose 3 * 10 * 9^2 --exaclty 4 people choose the same number 5 choose 4 * 10 * 9 --exactly 5 people choose the same number 5 choose 5 * 10 =10 add them and divide

First work out the probability that none have the same number: In this case imagine each person picks their random number in turn. From person one through five, probabilities of picking unique numbers: For person one: 10/10 (since no other numbers have been picked yet) For person two: 9/10 (since one number has been picked by person one) Person three: 8/10 (Assume that persons one and two have picked unique numbers, since we are looking for the prob. that ALL have picked unique numbers) Person four: 7/10 Person 5: 6/10 Multiply together: get 30,240/100,000 = 30.24% Subtract from 100% to get 59.76% (required answer)

lordash is almost right, except that 100% - 30.24% = 69.76%

One or more comments have been removed.
Please see our Community Guidelines or Terms of Service for more information.

Nothing difficult. Some people found difficult the questions about how to get along with colleagues and how to create a good relationship or break the ice.

4 Answers

What was your opinion of the film "Blair Witch Project"

4 Answers

What is success? Some IT knowledge required for the technical test- what does http stand for; how many bits are in a byte etc.

3 Answers

What skills do you process to be successful in this role?

3 Answers

What makes you stand out from the crowd? What motivates you? Why a career in data? Why Kubrick? What's a recent news story in the commercial world? Name 3 regulation laws in place What do these abbreviations mean?

3 Answers

Interview Questions were average on difficulty level if you put some thought to it. Screening rounds were more of question answers based where they gave you a problem and expected an answer. Python: Find the max no from the given set of elements in an array (without using max function) Find the minimum absolute difference between the set of elements of an array. Python Coding Questions that involved a hashmap. Know your basics well Print Max element of a given list Print median of a given list Print the first nonrecurring element in a list Print the most recurring element in a list HCF/Greatest common Factor of List LCM of list Sql: find the highest salary per department Select employee from departments where max salary of the department is 40k Select employee assigned to projects Select employee which have the max salary in a given department Select employee with second highest salary Table has two data entries every day for # of apples and oranges sold. write a query to get the difference between the apples and oranges sold on a given day Typical questions around Group by, Joins during screening round they used MYSQL so practice solutions with basic SQL as the version i was working on didn't support analytical functions or other advanced features. Face To Face Rounds (Fullstack): To begin I was asked about different metrics which could be reported given the dataset/information or scenario. Then interviewer picked up a metrics and asked to draw on whiteboard what kind of graph/chart will I use to display the information. Then going further asked about the table structures and data model which will be required to support the dashboard. Interviewer then provided the initial data set which is 1 case was a log file and in another some detail level tables, I was asked to write a programming code to read, parse and load data to tables. Then along the way once we have our code tables and dashboard finalized i was asked to write SQL's for different steps in the whole pipeline.

4 Answers

Tell us about about a challenging project that you've done.

2 Answers

There are elements that are not on the balance sheet but affect it, examples? why we are interested in these elements?

2 Answers

1) What did you do in your last job(s) 2) What was the last book you read 3) What do you do during your free time.

2 Answers
110 of 923 Interview Questions