NerdWallet Data Analyst | May 2020
?
•Anonymous••Upvote
1
Downvote
Company: NerdWallet
Position: Data Analyst
Location: San Francisco Bay Area, CA
Level: nan
Outcome: Onsite Rejected
How was the interview process? What was it like?
Lots of questioning on behavioral aspects. How do you interact with PMs, UI engineers, managers. How do you frame a business question into a data format. What metrics would you consider for understanding flow of sign up page, what A/B would you conduct, when to stop the test and deliver results.
What technical questions were asked?
SQL / Pandas, Business Case and Estimation, Product Metrics and Measurement
What was one of your solutions?
Created a self join to the table, with a filter to limit to max date values 7 days or earlier. If the user has a campaign value- use that. If null, use the value from the self join. If that is also null, then call it organic.
Data Analyst
There's so much more to Interview Query
sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est
quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est