How do you calculate monthly active users, churned users and resurrected users from a user activity log with userID and DateTime
Daten Interview Questions
79,456 daten interview questions shared by candidates
Given a table of friend requests sent and friend requests received, find the user with the most friends.
data question: dialoglog (userid int appid int type char , a flag either "imp" or "click" ds timestamp ) How would you access the quality of app? How to compute click-through rate (in mySQL)?
SQL question: given a table of interaction between users (user_a | user_b | day), find number of users who had more than 5 interactions yesterday (assume there is only one unique interaction between a pair of users per day). Product Question: A user satisfaction survey was conducted for two groups of facebook users (each with 50 k sample size). Group1: who had enabled certain login security features Group 2: who had not enabled these security features. It was found that user satisfaction with group1 was 30% lower than with group 2. Why do you think so? Comment on how the survey was conducted?
Given a table with columns country (with two-letter country abbreviation), count of requests sent, percentage of requests sent failed, condense down to this data grouped by country: country (one row per country), total count of requests sent, total count of requests sent failed.
Mostly situational.. guesstimate and SPSS related questions to mark proficiency in statictics and visualizations.
They check for your attitude, your approach and your anxiety level! I solved both the case studies and I know I rocked the behavioral and Data challenge round, but still didn't ended up not being selected, why?
Given a series of tables; write the SQL code you would need to count subpopulations through joins.
business sense: There are two types of cars A and B. The number of people in US who use A and B are the same. They drive the same distances each month. Now there are two new technologies, X and Y (of equal cost). If apply X, mpg of A would increase from 50 mpg to 75 mpg; If apply Y, mpg of B would increase from 10 mpg to 11 mpg. The goal is to decrease the dependence on foreign oil, or to decrease the consumption of gasoline. Question: which technology would you apply? Follow up question: after applying the technology of your choice, assume there's money available for research on new technology, which car would you choose to conduct research on?
if there are 5 people in a room and each chooses a number from 1 to 10 at random what is the probability that two or more people have the same number
Viewing 31 - 40 interview questions