Chime数据相关面试真题

Analyze the provided Excel data, which contains records of users depositing money into their accounts, resembling a log. The data includes various columns with user information such as average monthly deposit frequency, amount, duration of being a customer, etc. Key columns pertain to customer service contact information, such as whether the user has contacted customer service, whether it was an automated response or a live conversation, the duration of the call, whether the call was transferred to other customer service representatives, and how many times it was transferred. One of the columns indicates whether the customer has churned. The question is: Does contacting customer service have an impact on customer churn, and if so, which aspects of the customer service contact are influencing factors?

Given a table with KPIs such as revenue, cost, profit, and LTV for an experimental group and a control group in an advertising context, decide whether to ship this feature or not. Address inconsistencies between metrics, such as a group having higher revenue but lower profit, and justify why you would focus on average per user metrics rather than total metrics for making your decision.

Given a simple schema with a single table and a chart showing weekly active users, identify the reasons for certain weeks' spikes in activity. Develop hypotheses based on observed patterns, such as spikes occurring towards the end of the month or due to specific transaction codes, and then use the data from the table to support your hypotheses. Additionally, write a SQL query to calculate the week-over-week difference using the LAG function.