Data cheat sheets

Data cheat sheets on Sefism, written by Tauseef Fayyaz: every concept in plain words, why it is used and the pitfall that catches people out.

76 sheets
5120 concepts

Free to learn. Credits keep it fair.

Reading is free. Adding a roadmap, keeping a cheat sheet or asking Tauseef a question uses credits, which only make sure the platform goes to people who are actually learning.

15creditswhen you join
1stroadmapfree to add
Morecreditson request, as you learn

Specialise

Go deep in one area of engineering.

Cheat sheet · Specialise
Data analytics cheat sheet
SQL, spreadsheets, dashboards, insight.
Chapters
1. 1What analysts do
2. 2Spreadsheets properly
3. SQL for analysis
+ 4 more
- 8 chapters
- 73 concepts
Opens with credits
Cheat sheet · Specialise
Data engineering cheat sheet
Pipelines, warehouses, Spark, dbt.
Chapters
1. 1Foundations and ingestion
2. 2Analytical SQL and data modelling
3. File formats, lakes and lakehouses
+ 7 more
- 10 chapters
- 77 concepts
Opens with credits
Cheat sheet · Specialise
Data science cheat sheet
Statistics, pandas, ML, experiments.
Chapters
1. 1Code for data: Python or R
2. 2Statistics and probability you use
3. SQL for data work
+ 7 more
- 10 chapters
- 76 concepts
Opens with credits
Cheat sheet · Specialise
Pandas cheat sheet
Reading data, selecting, filtering, missing values, groupby, merge and join, reshaping and dates in pandas, with copy-on-write in mind.
Chapters
1. 1Loading and saving data
2. 2Selecting rows and columns
3. Filtering and sorting
+ 7 more
- 10 chapters
- 63 concepts
Opens with credits

Browse the cheat sheets by topic

Each of these is its own page: the foundations shelf, the career shelf, the sheets that are open end to end. The filters above do the same thing without a page load.

Work with me

Stuck on something specific?

Writing only gets you so far. If you want an answer to your situation rather than the general case, book a session and we will work through it together. Sessions are free for approved Sefism members, and a few slots open each week.