Why are you fit for this role ?
Senior Data Analyst Interview Questions
2,961 senior data analyst interview questions shared by candidates
Questions related to SQL Queries and Basics of Azure
Tell me more about yourself
basic SQL queries using joins, windows functions etc.
How do you scale LLM models?
Tell us about a time where you had to cross functionally partner to achieve a goal
For these exercises, please use the tables you provided on the Google Form: people (user_id, people_name, user_type, username) group (group_id, group_name) people_group (user_id, group_id) 1.1 Please write a SQL query to get the usernames of all teachers. 1.2 Please write a SQL query to get the username of each teacher who belongs to any group. 1.3 Please write a SQL query to get the number of teachers who don’t belong to any group. 2.1 How about getting every user's percent difference of activity on the report date versus a week before the report date, for every date? Assume we have a daily user_summary table with every user's activity_level (integer) on every day. Don't worry about the exact date syntax. 3.1 If you want to measure whether new user registration rate (# of new users registered/all invitations sent out) for one design is higher than the other, What statistical test you will use?
What is the P-value?
When were you a 10/10 happy?
Explain one project on which you worked which had the highest positive impact on client?
Viewing 1981 - 1990 interview questions