PMP Framework used and how to manage
Sr Data Analyst Interview Questions
2,953 sr data analyst interview questions shared by candidates
What's your favorite window function?
Interview gave company’s information. Asked for my Introduction. Technical Questions SQL: What is Self Join What is Cross Join What is Views What is Rank and Dense Rank If there are ‘n’ number of students and they are having different rank get the student who is having median ranking marks. Number of output rows of inner join, left join, right join, cross join, union, union all, outer join following tables with single column. Table 1 Table 2 A B 1 1 1 1 1 1 1 1 There is a column where we have full name of person we want to get mail id of that person in the format of (Ubisoft.comlast_namefirst_name) What output does substring_index, string or integer. There a table of students and marks, we need to categorise them dynamically into poor, average, brilliant where these range is 3rd part of range from min marks and max marks. Eg. if there are 10 students and min marks is 20 and max marks is 80 then person with 20 marks and below is poor, 20-40 is average and above 40 is brilliant. What is ACID and explain it. What is normalisation. Type of normalisation. What is Big Data. What is ETL Dimension table and fact table. Provide use case where fact table is used, dimension table is used and where both the tables are used. What will be result if A left join B and B right join A. Why left join and right join is introduced as different. If a view is created using two table A and B but the person who has access of Table A deleted data from it and you don’t have access to A table what will you do. What are bad joins. What will you do when SQL is not working or not fetching data. Power BI: Row Level Security in Power BI. Optimisation in Power BI. Python: What is Append in python. Get leap year code if year is divisible by 4 not by 100 and divisible by 400. How to fill null values in python. Print data where marks is greater than 40. Logical : There are two containers have 3 and 5 liter capacity calculate 1,2,4 litres from it. King prisoned 100 people in jail and said that who ever will come to and tell me that they have blue eye king will release them. How many days it will take all prisoners to come out. Where prisoners don’t know colour of their own eyes and they can’t talk and use sign language. Business approach: How free games generate revenue. What approach can be used to generate for revenue. What could be the reason behind downtrend in retention rate of players. Managerial Questions: Explain previous project from start to end. How to ensure sustainability. How to deal with client. How you’ll help Jr. Data analyst under you. Agile methodologies. Sprint planning. Given some conditions where they wanted to know what measures can be taken to grow the business. And all questions related to end to end project.
They have asked SQL queries , data cleaning and quality check and few puzzle.
Sponsorshi status, salary expectations and past experience
How do you manage your time?
normally involves a clever application of hashmaps and it is expected that you know how to work with it properly inside and out. While greedy problems are technically possible, DP (dynamic programming
On power day, 2 case study rounds where the interviewer will provide case details and ask series of questions about the problem and data (give accurate answers and reasoning for your answer). In Data challenge round you have to explain the process and idea behind how you solved the challenge, then you will have series of questions based on your approach and explanation (e.g. why PCA ?, difference in weights obtained in manual and PCA?). Last is behavioral round.
There was a bunch of coding interview questions on the panel list.
Tell me about a time that you had to have a difficult conversation with an employee and how it was resolved
Viewing 771 - 780 interview questions