Как успевать учиться в аналитике
Карьерник — квиз-тренажёр в Telegram с 1500+ вопросами для собесов аналитика. SQL, Python, A/B, метрики. Бесплатно.
Зачем это знать
Field меняется быстро. Новые tools (dbt, polars, LLMs), techniques (CUPED, synthetic control), best practices. Аналитик, кто stopped learning — falls behind за 2-3 года.
Но easy be busy с work, never learn new. Плохой trade-off long-term.
Learning strategy
1. Structured > sporadic
«Next course when have time» → never learn.
«30 min каждое утро» → meaningful progress.
2. Balance deep + wide
Deep: specialize 1-2 areas (e.g., A/B, product analytics).
Wide: general awareness (ML, data engineering, industry).
3. Apply immediately
Learn → apply в job project. Consolidates.
«Learning без application» — fades fast.
Что изучать (приоритеты)
Core foundation
Review regularly:
- SQL mastery
- Python / pandas
- Statistics
- A/B testing
Emerging topics
- dbt / analytics engineering
- LLMs в workflow
- Modern data stack
- Causal inference
Soft skills
- Product thinking
- Communication
- Leadership
- Business strategy
Domain
Для your industry specifically:
- Fintech: credit, fraud
- E-commerce: retention, LTV
- SaaS: MRR, expansion
Resources
Blogs / newsletters
- Reforge — growth / product
- Lenny's Newsletter — product
- Data Elixir — general data
- Analytics Engineering Roundup — modern stack
- Stratechery — business strategy
- Habr data analytics — Russian
- Медуза / RBC tech — bizarre Russian tech
Podcasts
- Analytics Engineering Podcast
- Super Data Science
- Women в Data
Commute / gym time.
Courses
Structured learning:
- Coursera — free audits, university-level
- Udemy — practical
- DataCamp — hands-on
- Reforge — premium product
- Karzpok/ Stepik — Russian
Books
Deep dives:
- «Trustworthy Online Controlled Experiments»
- «Causal Inference in Statistics»
- «Designing Data-Intensive Applications»
- «The Lean Product Playbook»
- «Atomic Habits» (для learning habit)
Twitter / LinkedIn
Follow leaders:
- Cassie Kozyrkov
- DJ Patil
- Maxime Beauchemin
- Hilary Parker
- Russian analysts (find в тех же чатах)
Time management
Morning 30 min
Before work:
- Read article
- Solve 1 SQL problem
- Watch video
Low friction.
Learning Fridays
Friday afternoons — dedicated learning / research.
Companies like Google encourage 20% time.
Weekends
If energy: 2-4 hours deep work.
Don't force если burnt out.
Commute
Podcasts, audiobooks.
Types of learning
Active
- Solve problems
- Write code
- Build projects
Best retention.
Passive
- Reading articles
- Videos
- Podcasts
Breadth fast, but less retention.
Teaching
Explain concept к someone → solidify understanding.
Blog posts, internal talks, Twitter threads.
Learning pyramid
- Foundation layer: basics (SQL, stats). Revisit yearly.
- Core layer: domain expertise (product analytics). Continuously update.
- Edge layer: emerging (LLMs, new tools). Monitor trends.
Time allocation: 30% / 50% / 20%.
Pet projects
Concrete projects
- Public dataset EDA
- Side analytics tool (Streamlit app)
- Blog on medium / hashnode
Benefits
- Force apply learning
- Portfolio
- Learn full-stack (SQL → Python → viz → deploy)
- Networking через public work
Ideas
- Analyze public company data (Yandex / Ozon financial reports)
- Build simple A/B calculator
- Dashboard public city data
Communities
Telegram
- Russian analyst chats
- «Аналитики данных» etc.
- Ask / share
Discord / Slack
- dbt community
- Analytics engineering
- Specific topics (statistics, Python)
Conferences
- Virtually attend
- Notes / tweets
Local meetups
When возможно.
Certifications
Helpful?
- Google Data Analytics: beginner level, brand helps
- AWS / Azure: если cloud-relevant
- Databricks: if Spark environment
Generally — projects > certs.
Russian
- Yandex курсы
- Skillbox / Skypro
Market-valued, но debatable quality varies.
Staying motivated
Set goals
Quarterly: «Master dbt», «Read 2 books on causal».
Track
Log progress. Visible accumulation motivates.
Celebrate milestones
First blog post, first dbt project, first talk — acknowledge.
Buddies
Learning partner. Weekly check-in.
Avoid traps
Shiny objects
Every new tool — distracted. Focus 1-2 per year.
Tutorial hell
«Do course, do another, do another» — never build.
Ratio: 20% learning / 80% applying.
Burnout
Over-push → quit. Sustainable pace.
Comparing yourself
Twitter «Ethan built this amazing thing» — discouraging.
Everyone на разных stages. Focus own progression.
Manager support
Discuss learning goals
1:1 meetings. Share what learning.
Learning budget
Many companies — $1-2k / year. Use.
Conferences
Ask к sponsor.
Internal projects
«Want explore X. Can I invest 10% time?»
Often approved.
Burnout-free
Not every waking hour
Work + life + rest. Learning — piece.
Rest
Sleep, exercise, friends. Fundamental.
Adapt
Busy quarter at work? Reduce learning. Pick up later.
На собесе
«What learning recently?»
Show curiosity:
- Specific book / course
- What applying now
- Next steps
«Not learning» — red flag.
Связанные темы
FAQ
Сколько времени минимум?
30 min daily consistent > 3 hours sporadic.
Формальное обучение?
Mix. Courses for structure, articles для speed.
Когда specialize?
After 2-3 years broad foundation. Deepen one area.
Тренируйтесь — откройте тренажёр с 1500+ вопросами для собесов.