Курс Product Analyst

Занурюйся в дані продукту, рахуй метрики й перетворюй цифри на рішення, що допомагають продукту рости. Познайомитесь з професією Product Analyst, її роллю в продуктовій команді та сучасними інструментами аналітики. Дізнаєтесь, як аналітики впливають на продуктові рішення та використовують AI у своїй роботі.

Програма курсу

Product Analyst Basics

• Who is a Product Analyst
• The Analyst as a Partner
• Modern Stack and the Role of AI
• Funnel Analysis

Get Started

• How Education Process Works
• How Employment Process Works
• How to Study Effectively

GenAI Essentials

• How GenAI Works
• Limitations of GenAI
• Prompting
• Responsible Use
• GenAI for Learning and Work
• How to Keep Up With AI

Google Sheets

• Spreadsheet - the Basic Tool for Analytics
• Data Importing
• Basic Data Types
• Formulas and Built-In Functions
• Cell Reference Types
• Data Cleaning
• Text Processing
• Working with Ranges
• Table Relationships
• Pivot Tables
• Data Visualization
• Data Exporting and Sharing
• Google Sheets Summary

SQL Basics

• Introduction to SQL
• SELECT Statement
• WHERE Clause
• NULL Value, LIKE, BETWEEN, and IN Operators
• ORDER BY, LIMIT, DISTINCT Clauses
• Aliases
• Aggregate Functions
• GROUP BY Clause
• JOIN Clause
• Functions
• HAVING Clause

SQL for Product Analytics

• Databases and normalization types
• JOIN Types
• Union / Union ALL
• Subqueries and CTEs
• Window Functions, part 1 (ROW_NUMBER, RANK, LAG, LEAD)
• Window Functions, part 2 (SUM OVER, PARTITION BY)
• Product Case: E-Commerce Analysis
• Query Optimization Rules, Indexes
• AI and SQL

Product Metrics & User Behavior

• User Lifecycle
• Cohort Analysis
• DAU/MAU and Engagement Metrics
• North Star Metric
• Aha / Habit Moment
• Case Study: Calculating Retention
• Case Study: Calculating Funnel with SQL and AI
• Case Study: Metric Drop Diagnosis Using AI
• Amplitude Overview

Tableau & Data Visualisation

• Principles of Good Data Visualization
• Tableau Interface
• Calculated Fields and LOD Expressions
• Calculated Fields with AI
• Project: Funnel
• Case Study: Story Mode
• Data Storytelling

Unit Economics & Marketing Analytics

• Monetization Models
• Marketing Channels and Attribution
• LTV, ARPU, Conversion, and Churn
• CAC, ROI, and ROMI
• Case Study: Marketing Channel Performance Evaluation
• Payment Metrics and User Behavior Insights
• Case Study: Unit Economics Model in Sheets for a Website
• Case Study: Unit Economics Model in Sheets for an App

Python Basics

• Introduction
• Main Concepts
• Numbers
• Strings
• Boolean
• Lists
• Conditional Statements
• Loops
• Functions
• Summary

Python for Product Analytics

• Pandas Basics
• Pandas Aggregations and Transformations
• NumPy Essentials
• Data Visualization with Matplotlib and Plotly
• Case Study: Retention and Cohort Analysis in Pandas
• Intro to Predictive Modeling
• Python and AI

Statistics for Product Decisions

• Descriptive Statistics
• Probability Distributions
• Central Limit Theorem
• Hypothesis Testing
• Statistical Tests
• Errors and Statistical Power
• Outliers and Causality: The Whale Model Case

Product Hypotheses

• Hypothesis Formulation
• Metric Selection
• Hypothesis Prioritization
• DIBB Framework
• From Idea to Hypothesis
• Competitor Analysis for Idea and Hypothesis Generation

A/B Testing & Experimentation

• What Is an A/B Test and Why It Matters
• Experiment Design
• Fake Door Testing
• Common A/B Testing Mistakes
• Results Analysis
• When A/B Testing Does Not Apply
• A/B Test Prioritization and Overlap
• A/B Dashboard in Streamlit
• A/B Test Analysis Using AI

Communication and Stress Management

• Introduction to Communication & Stress Management
• Confidence Building and Stress Management
• Diction, Filler Words Reduction, and Body Language
• Public Speaking
• Job Interview
• Written Communication
• Social Media Communication Skills Development

Team Project

• Week 0: Team Project. Intro
• Week 1: Jira Environment
• Week 2: Status Check
• Week 3: Estimates
• Week 4: How to Demo Your Work
• Final Week: Retrospective
• Team Project for Employment

Employment

• Employment Roadmap
• Preparing Your Resume
• Interview Preparation
• Cover Letter Preparation
• Google, LinkedIn, DOU, Djinni
• How to Find and Apply for Vacancies
• Job Search Tips: Talking to Recruiters
• Work details FAQ
• MilTech

Особливості курсу

• Працюєш? Навчайся у власному темпі
• Щотижневі дзвінки з менторами
• Спілкування з одногрупниками
• Практичні навчальні матеріали замість довгих лекцій
• Гарантоване працевлаштування після закінчення курсу