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:    • SQL Mock Interview: Find employees wh...  
Analyze Marketing Channels:    • Data Science SQL Mock Interview - Ana...  
SQL vs. NoSQL Explained (in 4 Minutes):    • SQL vs. NoSQL Explained (in 4 Minutes)  
Complex Datasets with SQL:    • Complex Datasets with SQL (Data Scien...  

👉 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