"Teach me something"
Analysts Interview Questions
434,246 analysts interview questions shared by candidates
How would you know how many people are wearing red colour shirt in the city?
Write an inner join between two tables.
write a sql on sales fact table and product dimension to report products with highest revenue in each product group.
All questions were competency based, focused around Amazon's Leadership principles. It is recommended to answer in the STAR format to do well. Make sure that you have a lot of detail behind the examples of scenarios you use to answer the competency questions as multiple further questions may be asked; also, statistics on the results (i.e 25% reduction in time taken to perform x) are useful and you may be asked about them.
What is a current market trend that you are following?
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%)
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.
no behavioral questions, just case study
How high does their demand have to stay to keep revenue?
Viewing 841 - 850 interview questions