2022

December

• Mastering Differences and Pitfalls when Switching SQL Databases: PostgreSQL vs. MySQL vs. SQLITE vs. Hive vs. Presto (AWS Athena)

2021

April

• Biases in learning to rank models and three approaches to deal with them

February

• Avro and avro schemas - how they work and why they are useful

January

• A Gentle Intro to the Basic Architecture of Message Brokers: RabbitMQ vs. Kafka

2020

November

• Intro into APIs and how to access public REST APIs with `curl`

October

• Pointwise, Pairswise and Listwise Learning to Rank Models - Three Approaches to Optimize Relative Ordering

September

• AI-Machine-Learning-Buzzword-Bingo

August

• The Intuition of Word Embeddings: How you Teach A Computer to Understand Text

July

• Jupyter Notebooks: Boost your productivity with Extensions and Magic Commands

June

• Mastering ElasticSearch Queries If You Have Only Worked With SQL Before
• How the Inverted Index and Scoring Work in ElasticSearch
• Working with Complex Datatypes in Hive

2019

September

• Plotting with Seaborn

August

• Mastering Data Preparation with Pandas: Subsetting, Filtering and Joining DataFrames

2018

December

• Everything You Need to Know to Use Git for Version Control
• Automatically changing the R working directory on Mac OS to source file location

November

• Formatting tables in R Markdown with kableExtra
• R Markdown for Novices: All you need to know to get started