DesignCafe Data Analyst Interview Questions and Answers for Experienced

Topics to prepare for LivSpace Business Analyst interview:

• SQL
• Projects that you worked on
• Excel
• Guesstimates

Interview preparation tips for other job seekers - One of the Business Analyst Approached me for this post, I have accepted the proposal and I have sent the resume to the person they called after 2 days and scheduled a call on a Friday evening I attended the interview 1st round 7out of 7 questions were answered, next round was SQL assignment which is piece of cake for me, because i have already mastered the SQL, Excel and BI tools from my experience in past and current company, 3rd round was with the immediate manager round which was rescheduled because of bandwidth issue of that manager so it happened in the next day, I was discussing about the current role and daily routines and responsibilities throughout my career she is ok with it and she asked me where are located at and I said my place which is my hometown place where I was working remotely and she said "kya Homelane(current company) mein bhi wfh Chal rah hai kya?". I said yes and she asked me that If I send you the offer letter you should definitely join our company and then i said yes I will join you and after 2 days I got a call from HR stating that there is one more round where you will be having discussion with Head of Analytics I said yes and they scheduled a call, I was explaining about the projects that I have worked and everything he was ok with that and asked me, I can offer you the job but you have to come to office and I told him that I have a family situation where I cannot move from my place to Bengaluru and I also told him that if you have doubt on my productivity you can ask my previous and current company(with blind guts) he told that, it is not the problem and it is the policy which they follow in their company, which totally shocked me, they have 2 different answers(tongues), One of their manager said that she is working from home and this guy was telling me the company policy is working from office, which is not a good sign of a company as if you are candidate and also he asked me what is your current ctc I told him that this is the current CTC and he asked what is your expected CTC, I told him that I am holding an offer from a company as a product data analyst and they are offering certain amount and he asked me that if you are holding a job why are you searching a job I told him that it was a 6 days work job and also its a US shift job, he again said that he wanted me to come to office I politely said no to him, and he just waited for 30 seconds for my reply I didn't say anything so he left the meet......... Now moral of the story is that, I proved him that I am a confident, capable, beneficial and a perfect candidate for his requirement and I am working for his rival company already where I can bring experience which was demonstrated in my past & current role to improve the standards of the company, so from his perspective I want to be his workhorse near him and I will never get compensated as per my standards as well.

Interview preparation tips for other job seekers - Don't lie in interview even if you don't know anything

Interview preparation tips for other job seekers - Total of 3 round is there, just be brutal honest as who are taking interviews are experienced and smart.

Interview preparation tips for other job seekers - 1- Answer with confidence
2- Knowledge about your area architects, builders, fabricators and dealers.
3- positive attitude.

Interview preparation tips for other job seekers - The pricing part of the company products should be done during training, not during the interview.

Tito jospeh asked me to sell a pen first and then he started giving instances where i had to calculate the percentage of discount on the total package given to the customer.

Interview preparation tips for other job seekers - Keep project prepared

Interview preparation tips for other job seekers - But company is not very good their is lot of issue in inter