Syllabus

Data Analyst

Download PDF
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.

Learn more →