You may have heard the term “Bullet Journal” or “BuJo” before. Maybe even long before today. The creator of the Bullet Journal is Ryder Carroll, an American digital product designer and art director. And what you may not know (yet) is that he initially created this method to better structure his learning efforts while he was still in college in the late 1990s.

In 2013 he started sharing his own life-hack on his website. As he explains it his website went viral in the summer of 2013, since then he has turned his personal routine into a full-time job. Surprising…

As a former consultant in a “pre-COVID-19” world I used to travel a lot and I always wanted to use this time in a useful way. I have been listening to podcasts on a regular basis for over two years now, and I must say that the variety of podcasts as well as their quality has greatly improved since that time. …

Duplicates are a recurring problem for any database user. There are several reasons why some duplicates may appear in a data set, and a sanity check is often necessary before any analysis can be conducted properly. This is why I want to share with you some lessons learned from my experience in dealing with duplicates using SQL.

Let’s set the scene. You just conducted a brilliant analysis to evaluate how many clients you or your company acquired over the past year. Your conclusion seems to confirm your intuition: the number of clients has tripled over the past 12 months! You…

SQL stands for Structured Query Language. Unfortunately, this does not mean that you will come up naturally with a perfectly structured piece of code once you start programming in this computer language.

As a Data Analyst, I keep applying myself three simple rules to better structure my SQL queries. They allow me not only to avoid mistakes in the way that I query from databases, but also to save time — for myself as well as for the colleagues I share my queries with. Let me present you these tricks and illustrate them with a real-life example.

1. Visualize your query output

Efficiently structuring your…

Let us begin by stating the obvious: since we have been living with the existence of COVID-19 for months now, we can sometimes be obsessed with it. I personally googled so much topics about coronavirus that I may have contributed significantly to Google Trends statistics — I hope not though. Beyond my personal need for answers in these times of uncertainty, I wanted to know: Am I the only one obsessed with coronavirus? What are other people searching on Google these days? How has the search for coronavirus on the Internet evolved since the beginning of the pandemic?

To learn…

Over the past few months, I was shocked by the increasing amount of shared online content about “how to be productive”. With half of humanity under lockdown, having to stay at home despite being healthy surely is frustrating, and some may want to use this time to do things they would never have the opportunity to do otherwise.

However, there is something intriguing about this trend. As if that was not enough to stay healthy and take care of yourself and your relatives during this difficult time, should you also be productive?! As a young woman starting her “adult life”…

As an aspiring Data Analyst, I have been developing a passion for creating data visualizations of all kinds. While my first trials were very basic (and quite ugly if I want to be fully honest), I found myself developing a simple method before even getting into the graphical execution of any data visualization. During the conceptual phase of a graph creation, I asked myself 3 main questions. Answering them while conceiving, building and sharing a graph would help me keep in sight what I have been building this graph for. …

Due to the coronavirus crisis, millions of French people are currently being confined to home. In response to this unprecedented situation, several French companies and institutions have been putting their resources online for free. More than ever, now is the right time to start learning French. Or to refresh your memories of past French classes!

According to the language learning platform Duolingo, French is the second most studied language worldwide. There are actually many reasons to learn French, from getting a better intercultural understanding to adding a plus on your resume. …