Data Analyst

Excel

・

Exel basics

Excel

・

Important functions in excel (vlookup, index match, sumif, countif)

Excel

・

Pivot tables

Excel

・

Data analysis with excel

SQL

・

SQL basics (order of execution; select, from, where)

SQL

・

Joins (inner join, left join, full outer join, right join)

SQL

・

SQL basics + joins

SQL

・

Calculation functions (sum, count, avg, min, max); group by, having

SQL

・

Useful functions (alias, string functions, date and time, like, coalesce, distinct)

SQL

・

Complex queries (with, subqueries, window functions, array)

SQL

・

Putting it all together - data analysis with SQL

Research & Result Analysis

・

Different analyses methods (cohort analysis, funnel analysis, churn analysis)

Research & Result Analysis

・

How to approach a research?

Research & Result Analysis

・

Choosing the right method for your research

Research & Result Analysis

・

Real world examples for deep research

Research & Result Analysis

・

Common errors in deep research

Statistics & AB Testing

・

Intro to statistics and A/B testing

Statistics & AB Testing

・

A/B testing methodologies (Bayesian vs. Frquentist)

Statistics & AB Testing

・

How to plan a test?

Statistics & AB Testing

・

Real world examples of A/B tests

Data Visualization

・

Basic concepts in data visualization

Data Visualization

・

Dashboard as a tool

Data Visualization

・

Build a dashboard in Tableau

Data Visualization

・

How to present Data

Data Visualization

・

Key concepts in presentation skills

Cross-Company Work

・

How to work with a data developer

Cross-Company Work

・

How to work with a product manager

Cross-Company Work

・

How to work with other analysts

Cross-Company Work

・

Intro to Product Management: Discover, Design, Build, and Control

Business Orientation

・

Intro to Tech

Business Orientation

・

Business Model Canvas: Determine the Nine Key Segments of Your Business

Business Orientation

・

Lean Startup: How to Build & Launch a New Product

Business Orientation

・

An Essential Guide to Unit Economics for Startups

Business Orientation

・

SWOT: How to Make Strategic Business Decisions

Business Orientation

・

Behavioural Economics: What Really Drives your Customers?

Business Orientation

・

Marketing Channels: Smart Ways to Get Traction

Business Orientation

・

Intro to Paid Ads

Business Orientation

・

Translating Business Objectives intro KPIs

Business Orientation

・

How To Build A Customer Health Model (Subscription Model)

Business Orientation

・

Pricing Strategies: Which Pricing Strategy is Best for Your Business?

Business Orientation

・

OKRs: How to Set Business Goals that Aim for Success

Career Development

・

How to Build an Impactful LinkedIn Profile

Career Development

・

Mini-Hackathon: Building a CV

Career Development

・

Get Ready for Your Next Job Interview

Career Development

・

Job Interviews: Simulations

Startup Skills

・

Project Management: Initiate, Plan, and Launch a Successful Project

Startup Skills

・

Speak Like a Pro: How to Master Public Speaking

Startup Skills

・

Manage Projects Using Monday.com

Startup Skills

・

Written Communication: Make Your Emails and IMs More Effective

Startup Skills

・

Storytelling Techniques For Business

Startup Skills

・

Automate Everyday Tasks That Take Away Your Time

Startup Skills

・

Presentation design

Intro to Data Analysis

・

Data analyst role

Intro to Data Analysis

・

Intro to Machine Learning

Intro to Data Analysis

・

Panel Data analysts

Intro to Data Analysis

・

Intro to data

No items found.

Check Your Compatibility →

*You must attend at least 80% of the classes to receive your certificate.
*To earn your certificate, you must successfully complete your final project.