4.4. Validate User Activity for a Feature

Try these first

1. 1.

   What is the purpose of validating user activity?

   Hint

   Think about how user actions inform business decisions.

2. 2.

   What SQL command is used to count logins?

   Hint

   It’s a function that summarizes values.

3. 3.

   What SQL function would you use to count user logins?

   • SUM
   • COUNT
   • AVG

   Hint

   It tallies occurrences of a specified condition.

4. 4.

   True or False: The GROUP BY clause is necessary when you are counting occurrences for unique entries.

   • True
   • False

   Hint

   Consider how aggregation affects your dataset.

5. 5.

   Suppose you have user activity data that reveals a drop in logins post a feature update. Formulate a strategy to investigate this.

   Hint

   Consider qualitative and quantitative data to get a fuller picture.

6. 6.

   You suspect that a specific demographic logs in more after certain marketing campaigns. How would you explore this using SQL?

   Hint

   Think about how to isolate different groups in your analysis.