Original article was published on Artificial Intelligence on Medium
1. SQL Case Studies
If you want to be a data scientist, you have to have strong SQL skills. Mode provides three practical SQL case studies that simulate real-life business problems, as well as an online SQL editor where you can write and run queries.
To open Mode’s SQL editor, go to this link and click on the hyperlink where it says ‘Open another window to Mode’.
If you’re new to SQL, I would first start with Mode’s SQL tutorials where you can learn basic, intermediate, and advanced SQL techniques. Feel free to skip this if you already have a good understanding of SQL.
Case Study 1: Investigating a Drop in User Engagement
The objective of this case is to determine the cause for a drop in user engagement for Yammer’s project. Before diving into the data, you should read the overview of what Yammer does here. There are 4 tables that you should work with.
The link to the case will provide you with much more detail pertaining to the problem, the data, and the questions that should be answered.
Check out how I approached this case study here if you’d like guidance.
Case Study 2: Understanding Search Functionality
This case is more focused on product analytics. Here, you’ll be required to dive into the data and determine whether the user experience is good or bad. What makes this case interesting is that it’s up to you to determine what ‘good’ and ‘bad’ means and how the user experience will be evaluated.
Case Study 3: Validating A/B Test Results
One of the most practical data science applications is performing A/B tests. In this case study, you’ll dive into the results of an A/B test where there was a 50% difference between the control and treatment groups. Your task for this case is to validate or invalidate the results after a thorough analysis.