basic SQL queries using joins, windows functions etc.
Sr Data Analyst Interview Questions
3,099 sr data analyst interview questions shared by candidates
A project about AB test
explain you experience in tableau and its use case
Qu'est-ce qu'un data analyst Senior comparé à un data analyst junior?
Student retention over consecutive months. The idea was to compute each student's longest uninterrupted streak of monthly activity (i.e., attending at least one class per month), and then group the student count by length of these streaks. It clearly required advanced use of window functions like row_number, lead/lag, and cumulative logic.
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?
What are challenges faced in government organization?
Viewing 2071 - 2080 interview questions