Course curriculum

  • 1

    Welcome to the course!

    • Introduction

    • What is Product Analytics
  • 2

    Why is Product Analytics Important to at PM?

    • Ideating & Prioritizing

    • Persuading your team

    • Executing on your product
  • 3

    Product Analytics vs Data Analytics

    • Understand the differences in the Product vs Data Analytics
  • 4

    What kind of Data should PMs focus on?

    • Understanding User Data

    • Understanding Product Data

    • What constitutes Qualitative Data

    • and what does 'Quantitative Data' mean
  • 5

    Importance of Product Analytics to PMs

    • Why do PMs need to understand Product Analytics
  • 6

    Choosing Goals, KPIs, Metrics, for your Product

    • Engagement Metrics

    • Retention Metrics

    • Activation Metrics

    • Acquisition Metrics

    • Transaction/ Monetization Metrics
  • 7

    Product Analytics in Action

    • User Segmentation - 1

    • User Segmentation - 2

    • Cohort Analysis - 1

    • Cohort Analysis - 2

    • Retention - 1

    • Funnel Analysis
  • 8

    Product Analytics Platform

    • Analytics Tool Walkthrough
  • 9

    SQL for PMs

    • SQL Introduction

    • Course Outline

    • Introduction to SQL. Why it is important to?

    • Using SELECT statement - Part 1

    • Using SELECT statement - Part 2

    • Subqueries

    • Using JOINS - Part 1

    • Using JOINS - Part 2

    • Writing efficient and effective JOINS

    • Operators in SQL - Arithmetic Operator

    • Comparison Operator

    • Logical Operator

    • Set Operator

    • Using UNION and UNION All

    • Examples of using UNION

    • Wildcard Characters

    • Example - using Wildcard Characters

    • Aggregate Functions

    • Example - Using Aggregate Functions

    • Using GROUP BY Clause

    • Example - GROUP BY clause

    • HAVING Clause

    • Example - Using HAVING clauase

    • Using SQL - Best practices

    • Websites to practice SQL

    • Conclusion