Analist Interview Questions

157,103 analist interview questions shared by candidates

Given three tables, user_dimension (user_id and account_id), account_dimension (account_id and paying_customer), and download_facts (date, user_id, and downloads), find the average number of downloads for free vs paying customers broken out by day.
avatar

Data Analyst

Interviewed at Uber

3.7
Jun 2, 2017

Given three tables, user_dimension (user_id and account_id), account_dimension (account_id and paying_customer), and download_facts (date, user_id, and downloads), find the average number of downloads for free vs paying customers broken out by day.

Many personality questions and situation based question (i.e. What would you do if you are in XYZ situation, how would you respond?) Tell me a time when you were in a difficult situation at work, how did you rectify the issue?
avatar

Data Analyst In Washington, DC

Interviewed at FSA

3.7
Dec 20, 2014

Many personality questions and situation based question (i.e. What would you do if you are in XYZ situation, how would you respond?) Tell me a time when you were in a difficult situation at work, how did you rectify the issue?

There are 25 horses, and you want to rank the fastest 3 horses out of those 25. In each race, only 5 horses can run at the same time because there are only 5 tracks. What is the minimum number of races required to find the 3 fastest horses without using a stopwatch?
avatar

Data Analyst

Interviewed at Wix

4.1
Jan 14, 2016

There are 25 horses, and you want to rank the fastest 3 horses out of those 25. In each race, only 5 horses can run at the same time because there are only 5 tracks. What is the minimum number of races required to find the 3 fastest horses without using a stopwatch?

4. Ali and Sophie are budding musicians who have been playing Thursday night shows at a local live music venue. The venue told them that over the course of the last four weeks, they’ve had 900 tickets sold for their shows. They are curious to see how many people are repeat fans, coming to more than one show. The venue’s recent customer survey says that 60% of fans have come once, 30% have come twice, 6% have come three times, and 4% have come four times. How many unique people have seen an Ali and Sophie show during this time period?
avatar

Business Analyst

Interviewed at Capital One

3
Mar 15, 2022

4. Ali and Sophie are budding musicians who have been playing Thursday night shows at a local live music venue. The venue told them that over the course of the last four weeks, they’ve had 900 tickets sold for their shows. They are curious to see how many people are repeat fans, coming to more than one show. The venue’s recent customer survey says that 60% of fans have come once, 30% have come twice, 6% have come three times, and 4% have come four times. How many unique people have seen an Ali and Sophie show during this time period?

Viewing 31 - 40 interview questions

Glassdoor has 157,103 interview questions and reports from Analist interviews. Prepare for your interview. Get hired. Love your job.