Capital One Sr. Data Analyst interview questions

First I had a phone round in order to know more about my background details like education and college. Then comes the coding round which is easy to crack with some sense of mind and intelligence. Next follows the Data Challenge. You will be given some time to solve the challenge with a data set and instructions on what to do. This will have a lot of expectations which they don't mention. Lastly the face to face interview

There were many rounds. 1. Telephonic casual interview by recruiter 2. Coding challenge (Basic SQL, and coding using any language) 3. Data Challenge ( given a data you have to do your analysis) - this took a long time and effort 4. Onsite interview- There were 4 interviews here a. Behavioral - General Tell me a situation question b. Case- Mobile App checq deposit case. You have to basically find break even. It was hard to understand what the interviewer was telling. c. Data challenge interview- The interviewer will ask about the Data challenge. Be ready to answer any question d. Case Interview- Credit card case. Where one group is divided into test other into control. You have to find the profit . The hardest for me was case interview. Despite a lot of prep. I would suggest the biggest factor here is to comprehend what the interviewer is asking and putting it in a equation. Once you figure the equation you can easily crack the case as it is simple Math. I believe there are not many openings here and the interview just keeps happening. I invested more than a month on this process and did not get a job. More than Data analysis they look at how well you understand the Banking domain which is not appropriate for I am from a Technical background. Advise to all : do not put all your eggs in this process. This is a little shady considering that they value only a crappy case interview so heavily.