The Data Analyst
From first principles to the interview room, the way the work is actually done.
Reading guide
Full 14-chapter Data Analyst guide
Concepts, frameworks, and SQL, from first principles to interview room.
~90 min · 14 chapters
Read guideInterview Q&A
FreeTop 25 Data Analyst Interview Questions
Grouped by round, answered the way a senior analyst would say it.
SQL & querying · Data prep & modeling · Statistics & analysis · Business sense & viz · Behavioral & domain
Open Top 25 Q&ATable of contents
- 1
How to use this guide
~4 min read
- 2
What a Data Analyst actually does
~7 min read
- 3
SQL, the analyst's primary language
~10 min read
- 4
Advanced SQL that sets you apart
~10 min read
- 5
How data is stored and moved
~9 min read
- 6
Data quality and cleaning
~6 min read
- 7
Statistics analysts actually use
~8 min read
- 8
Business metrics and KPIs
~5 min read
- 9
Visualization and dashboards
~5 min read
- 10
From analysis to influence
~6 min read
- 11
Handling data responsibly
~5 min read
- 12
Landing the role
~8 min read
- 13
Appendix A · Ten principles to carry into the job
~3 min read
- 14
Appendix B · Quick-reference glossary
~4 min read