Analist Interview Questions

157,161 analist interview questions shared by candidates

Example of the SQL exercise: For accounts that are reported exactly n times in 2012 (n = 1, 2, …), what is the average amount spent by these accounts for different payment types in different months in 2012? What percent of the monetized accounts gets reported before they monetize? Example of the brain teaser questions: sum of 1-99 sum of a 10x10 matrix, 1st row and 1st column are 1,2,...10. where the first row is: 1,2,..,10, the first column is: 2,4,..,20. and the last row is: 10,20,...,100. sum of a 3 dimension with rows and columns from 1-10 just like the previous question. pets doubling everyday. at day 25, it reaches to the capacity. how many days it will fit in half of the capacity. clock, degree between 3 and 3:25 clock, degree when hour head and minute head overlap at 3-4 oclock.
avatar

Business Analyst

Interviewed at Riot Games

3.9
Dec 3, 2013

Example of the SQL exercise: For accounts that are reported exactly n times in 2012 (n = 1, 2, …), what is the average amount spent by these accounts for different payment types in different months in 2012? What percent of the monetized accounts gets reported before they monetize? Example of the brain teaser questions: sum of 1-99 sum of a 10x10 matrix, 1st row and 1st column are 1,2,...10. where the first row is: 1,2,..,10, the first column is: 2,4,..,20. and the last row is: 10,20,...,100. sum of a 3 dimension with rows and columns from 1-10 just like the previous question. pets doubling everyday. at day 25, it reaches to the capacity. how many days it will fit in half of the capacity. clock, degree between 3 and 3:25 clock, degree when hour head and minute head overlap at 3-4 oclock.

There was a 30 minute case interview which was very easy if you are an analytical type. The case goes, you are a franchise owner of a Subway shop. Your shop is offered to either join the 5 dollar foot long promotion or remain as usual. You are then asked to decide whether to join the promotion or decline.
avatar

Business Analyst

Interviewed at Capital One

3
Jan 20, 2011

There was a 30 minute case interview which was very easy if you are an analytical type. The case goes, you are a franchise owner of a Subway shop. Your shop is offered to either join the 5 dollar foot long promotion or remain as usual. You are then asked to decide whether to join the promotion or decline.

case study: credit card insurance profit per customer cost of mailing $0.5, response rate 1%, average balance per month $1000, insurance charges 1% of average balance monthly, customer claim rate 5% (once insured customer files a claim, the balance will be wiped and C1 lose $1000). Question: profit per customer, graph claim rate vs response rate, graph profit vs response rate and find the response rate for maximum profit (r=1%)
avatar

Senior Data Analyst

Interviewed at Capital One

3
Apr 28, 2011

case study: credit card insurance profit per customer cost of mailing $0.5, response rate 1%, average balance per month $1000, insurance charges 1% of average balance monthly, customer claim rate 5% (once insured customer files a claim, the balance will be wiped and C1 lose $1000). Question: profit per customer, graph claim rate vs response rate, graph profit vs response rate and find the response rate for maximum profit (r=1%)

Viewing 191 - 200 interview questions

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