Data Analyst track
Syllabus
Each sprint lasts two weeks and represents approximately 7 months
40 hours of study.
Onboarding
1-2 hours
0
What to expect as a TripleTen student. How sprints are
structured, who’s on our guidance team, how to use Slack,
where to find information, and more.
1 Basic Python
Intro Course
Discover what data analysis is and do your first research
3 weeks,
as an analyst. Learn the basics of Python, a key tool
40 hours
in the profession. This course will help you decide if you have
the time and motivation to complete the full program.
Chapter 1. Variables, Printing, Data Types, and Arithmetic
Operations
•
Chapter 2. Strings
•
Chapter 3. Lists
•
Chapter 4. for Loops
•
Chapter 5. Nested Lists
•
Chapter 6. Conditions and Loops
•
Chapter 7. Creating Functions
•
Chapter 8. Dictionaries
•
Chapter 9. pandas for Data Analysis
•
Chapter 10. Data Preprocessing
•
Chapter 11. Analyzing Data and Presenting Results
• Chapter 12. A Quick Overview of the Jupyter Notebook
2 Data Preprocessing
+1 project for
Compensating for less-than-perfect data. Handling missing your portfolio
and duplicate values. Changing data types. Systems thinking 3 weeks, 40 hours
for analysts.
•
Chapter 1. Introduction to Data Preprocessing
•
Chapter 2. Working with Missing Values
•
Chapter 3. Changing Data Types
•
Chapter 5. Categorizing Data
•
Chapter 6. Systems and Critical Thinking for Analysts
Exploratory Data Analysis (EDA)
3 Performing initial scans to detect patterns in data. Building +1 project for
basic graphs and generating your first hypotheses.
your portfolio
3 weeks, 40 hours
Chapter 1. First Graphs and Conclusions
•
Chapter 2. Studying Data Slices
•
Chapter 3. Working with Several Data Sources
•
Chapter 4. Joint Distribution
•
Chapter 5. Validating Results
Statistical Data Analysis
4 Probability theory, the most common distributions, and +1 project for
statistical methods in Python. Sampling and statistical your portfolio
significance. Identifying and handling anomalies.
3 weeks, 40 hours
Chapter 1. Descriptive Statistics
•
Chapter 2. Probability Theory
•
Chapter 3. Testing Hypotheses
Integrated Project 1
5 Identify patterns to help you determine whether
+1 project for
a given video game will succeed or not. your portfolio
1 week, 20 hours
1-week break
6 Data Collection and Storage (SQL)
+1 project for
your portfolio
How databases are structured and how to pull data
2 weeks, 40 hours
from them using SQL queries. Finding data online.
•
Chapter 1. Retrieving Data from Online Resources
•
Chapter 2. SQL as a Tool for Working with Data
•
Chapter 3. Advanced SQL Features for Analysis
•
Chapter 4. Relationships Between Tables
•
Chapter 5. Soft Skills
Bonus Chapter: PySpark
7 Business Analytics
+1 project for
your portfolio
Applying data analysis in business. Business metrics and
2 weeks, 40 hours
KPIs. User data analysis. Marketing analytics and related
tools. The sales funnel.
•
Chapter 1. Metrics and Funnels
•
Chapter 2. Cohort Analysis
•
Chapter 3. Unit Economics
•
Chapter 4. User Metrics
• Chapter 5. Soft Skills
Bonus Lesson: Optimizing Data in pandas
8 Making Business Decisions Based on Data
+1 project for
Methods and tools for testing hypotheses. Experimental your portfolio
design. Seasonality. Cohort analysis. A/B testing.
2 weeks, 40 hours
•
Chapter 1. The Basics of Testing Hypotheses in Business
•
Chapter 2. Choosing an Experimental Method
•
Chapter 3. Prioritizing Hypotheses
•
Chapter 4. Preparing for an A/B Test
•
Chapter 5. Analyzing the Results of A/B Test
• Chapter 6. Soft Skills
9 How to Tell a Story Using Data
+1 project for
Presenting your research. Data visualization
your portfolio
methods. Creating reports to explain findings.
2 weeks, 40 hours
The seaborn library.
•
Chapter 1. Preparing Presentations
•
Chapter 2. The seaborn Library
• Chapter 3. The plotly Library
10 Integrated Project 2
+1 project for
your portfolio
Bring together everything you’ve learned so far to analyze
1 week, 20 hours
the results of a food app’s A/A/B test.
1-week break
11 Automation
+1 project for
Automating data analysis processes and scripting routine tasks. your portfolio
Data visualization methods. Presenting results.
2 weeks, 40 hours
•
Chapter 1. Data Pipelines and Why to Use Them
•
Chapter 2. Designing and Developing Dashboards with Dash
•
Chapter 3. Tableau
Forecasts and Predictions
12 Basic machine learning methods and applications. +1 project for
Classification, forecasting, clustering. Regression.
your portfolio
Decision trees.
2 weeks, 40 hours
Chapter 1. Business Tasks Involving Machine Learning
•
Chapter 2. Machine Learning Algorithms
•
Chapter 3. Solving Tasks Related to Machine Learning
Final Project
13 Apply everything you've learned in a two-week bootcamp that +1 project for
recreates the experience of working as a junior analyst. your portfolio
2 weeks, 40 hours
Career Success Program
C areer Success Program improves TripleTen graduates’ employability.
In other words, it helps students transfer from learner to earner
1 Alumni community No time limit
Space for peer to peer support and productive professional
networking.
•
Constant communication with other graduates
Online events — webinars from industry professionals,
networking sessions
• Job and freelance opportunities from graduates and tutors
4 weeks
2 Career Prep Course
This additional free-of-charge course prepares graduates for
job search. It consists of lessons, assignments and feedback
by HR-specialists.
Career prep course structure:
•
Personal job search strategy
•
Job market in IT and digital
•
Interview - theory and practice
•
Networking skills
•
Resume/CV
•
Motivation letter
•
Portfolio
• Online presence — LinkedIn, etc.
6 months or until
3 Career Accelerator you land a job
This is a community-based activity, where graduates:
•
Actively look for a job and constantly improve through
feedback loop arranged by our HR-specialists
•
Practice technical and HR interviews (mock-interviews)
•
Actively network (with our help and on their own)
• Get access to TripleTen partners and their job opportunities
