Analyze a User's Posts - Data Analyst SQL Mock Interview

Don't leave your SQL interviews to chance. Sign up for Exponent's SQL interview course today: https://bit.ly/3Tfhs4f In this SQL mock interview, we sit down with a Data Analyst who analyzes user post data for a growth hacky startup. The startup wants to know about how users are talking about them and how well their message is spreading. Chapters (Powered by ChapterMe) - 00:00 - Intro 01:01 - PostgreSQL: The User Data table 03:09 - Post Success Rate 08:44 - How to Segment the 'Super Users' 10:10 - Post-Success Rate in the Aggregate Table 12:05 - Coding 15:26 - Case and Condition on Aggregated Metrics 24:50 - Facebook Ad Metrics Seamatching 31:39 - Discrepancy Analysis 39:09 - Post-Sequencing and the Failed Post 45:38 - Interview Analysis 49:26 - Avoid Hard Coding Dates Want more SQL content? - Find employees who earn more than their managers: https://youtu.be/wgU1uyjjZW0 - Analyze Marketing Channels: https://youtu.be/lnhuCj0EfPI - SQL vs. NoSQL Explained (in 4 Minutes): https://youtu.be/_Ss42Vb1SU4 - Complex Datasets with SQL: https://youtu.be/LuU9fm20JPU 👉 Subscribe to our channel: http://bit.ly/exponentyt 🕊️ Follow us on Twitter: http://bit.ly/exptweet 💙 Like us on Facebook for special discounts: http://bit.ly/exponentfb 📷 Check us out on Instagram: http://bit.ly/exponentig 📹 Watch us on TikTok: https://bit.ly/exponenttiktok ABOUT US: Did you enjoy this interview question and answer? Want to land your dream career? Exponent is an online community, course, and coaching platform to help you ace your upcoming interview. Exponent has helped people land their dream careers at companies like Google, Microsoft, Amazon, and high-growth startups. Exponent is currently licensed by Stanford, Yale, UW, and others. Our courses include interview lessons, questions, and complete answers with video walkthroughs. Access hours of real interview videos, where we analyze what went right or wrong, and our 1000+ community of expert coaches and industry professionals, to help you get your dream job and more! #sql #sqlinterview #datascience #businessanalyst