Как быть продуктивным аналитиком
Карьерник — квиз-тренажёр в Telegram с 1500+ вопросами для собесов аналитика. SQL, Python, A/B, метрики. Бесплатно.
Зачем это знать
Ad-hoc requests, dashboards, analyses, meetings — аналитик overwhelmed. Two аналитика с same skill, один shipит в 2x больше. Разница — продуктивность.
Principles
1. Say no
Cannot do everything. Priorities force.
«Not sure I can get to this этой неделе. Can you help prioritize between A и B?».
2. Batch similar tasks
Ad-hoc queries все сразу. Meetings cluster. Writing deep work.
Context switching — expensive.
3. Automate
Any task > 3 times → automate.
- Recurring reports → scheduled dashboard
- Data pulls → cached query
- Formulas → reusable functions
4. Templates
SQL templates, analysis templates, presentation templates.
Не start from scratch каждый раз.
5. Focus time
Block 2-3 hour focus times. No meetings.
Deep work — где analyst creates value.
Prioritization
Impact × effort
Chart:
- High impact, low effort — do first
- High, high — plan
- Low, low — skip
- Low, high — never
RICE
Reach × Impact × Confidence / Effort.
Business priorities
OKRs / top initiatives — top priority.
Random PM asks — lower, unless supports OKR.
Ad-hoc management
Intake
Channel: Slack, email, ticket. Consistent.
Structure:
- What decision supporting?
- Timeline?
- Fidelity needed (quick vs thorough)?
SLA
«< 1 hour: quick query». «< 1 day: simple analysis». «< 1 week: deep analysis».
Manages expectations.
Say no / defer
Not every request urgent. Often ok to wait.
Self-serve
Build dashboards → users answer own questions.
Tools
SQL
Modern IDE: DataGrip / DBeaver / VS Code.
Bookmarks frequent queries. History search.
Python
Jupyter / VS Code. Virtual env.
Cookiecutter для project templates.
Git
Version control everything: queries, notebooks, dashboards.
Documentation
Notion / Confluence / Google Docs для analyses.
Searchable future self.
Focus techniques
Pomodoro
25 min work / 5 min break. Repeat.
Time blocking
Calendar blocks для each task type.
No Slack morning
First 2 hours — no communication. Deep work.
Meeting audit
Monthly: necessary? Decline где not.
Delegation
To others
- Self-serve dashboards
- Documentation
- Train stakeholders SQL
- Automation
Up
Ask manager prioritize when overloaded.
Anti-patterns
Perfectionism
Polish 95 → 100%. Last 5% often не add value.
Ship at 80% когда marginal effort high.
Over-engineering
Complex solution для simple problem.
«Quick analysis» → don't build ML model.
Reactive
Everything Slack-driven → no strategic time.
Proactively plan weeks.
Shiny objects
New tools, trendy frameworks. Often distract.
Choose core tools, master.
Energy management
Not time management
8-hour day, но 4 productive hours. Optimize для 4, не 8.
Morning deep
Best time deep work. Reserve.
Meetings after lunch
Usually lower cognitive load.
Rest
Sleep, exercise. Obvious, but critical.
Communication efficiency
Async > sync
Slack message > meeting.
Short messages
TL;DR at top.
Reduce meetings
Only if decision needed. Otherwise Slack / doc.
Documentation
Reply с link к doc > explain 10th time.
Fighting interruptions
Slack DND
Status «focus», turn off notifications.
Batch responses
Check Slack hourly, not every 5 min.
Designated hours
«Office hours 3-4pm». Questions там.
Signal availability
«🔴 In focus till 4pm» status.
Metrics of own productivity
Quantitative
- Projects completed
- Dashboards owned
- Ad-hoc resolved
- Code written
Qualitative
- Stakeholder satisfaction
- Recognition
- Learning
Track
Weekly review: «What completed? What delayed? Why?»
Common time wasters
1. Slack / Email
Interruption primary. Batch.
2. Over-planning
Plan 30 min / execute 1 hour. Flip ratio.
3. Meetings
Audit все. Decline 20%.
4. Re-doing
No version control → redo.
5. Perfectionism
Polish excessively.
Tools stack
Project management
- Linear (software)
- Notion
- Todoist
- Personal: Apple Reminders
Notes
- Notion
- Obsidian
- Bear
Calendar
- Google Calendar
- Apple Calendar
- Fantastical (Mac)
Time tracking
- Toggl
- Clockify
- Rescue Time
Optional, but enlightening.
Books / resources
- «Deep Work» — Cal Newport
- «4-Hour Workweek» (selectively)
- «Getting Things Done»
На собесе
«Как handle конкурирующие priorities?»
- Impact × effort matrix
- Ask manager prioritize
- Communicate trade-offs
«Automate часто?»
- Recurring reports
- Data pulls
- Templates
Связанные темы
FAQ
Overtime?
Occasional ok. Chronic — signal process broken.
Too many meetings?
Audit, decline, shorten. Bring agenda.
Slow кажется?
Focus on impact, не speed. 1 right analysis > 5 bad.
Тренируйте skills — откройте тренажёр с 1500+ вопросами для собесов.