The power of color applied to decision making when creating impactful graphs — In essence, what is a graph made of? Shapes, lines and bars, probably. Some text elements, definitely. Figures, maybe. But most importantly: colors. Whether you choose a black and white design or a colorful one, the colors of any data visualization will have a non-negligible impact on the reader. A…

And a Hands-on Example to Apply Them Right Away — 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…

1. Identify — 2. Understand — 3. Act — Who can claim to handle databases of impeccable quality and reliability every day? I personally cannot, and to be completely honest this is part of the reasons why I enjoy working as a data analyst. Even if data cleaning is rarely the best part in data science, it is nevertheless…

My recipe for building a solid data story — Do you know this feeling when you know deep inside that you want to talk about a technical topic but you don’t really know how to correctly treat it in an article? Finding the right angle to convey the right message can be tricky sometimes. Particularly when tackling technical topics…

A 4-step method and concrete examples to apply right away — September often calls for new resolutions. Summer vacations are over, activity is picking up again. Why not use this time to set up new habits — or improve current ones — about staying up to date with the latest developments in the field of data science? When I started my…

Where does this new role fit into data teams? And why should you care about it? — For a few years now the term “analytics engineer” has been used in the field of data science to describe a new data role. For example in an article published in January 2021 Prukalpa Sankar mentions the emergence of new roles like analytics engineers. Is it to say that the…

How to use Google Sheets to directly load data into BigQuery — and why it is the best solution for certain use cases — When talking about data management at a company, what comes to mind first are keywords like “data architecture”, “data engineering pipelines”, “data quality checks”… in short, concepts around the structuration of data that flows across an organization. Indeed, all best practices regarding data management rely on the assumption that we…

5 questions you should ask every business user before you even start analyzing data + 1 hands-on exercise to illustrate a real-life situation — Whether it is requests for specific in-depth analyses or widely used dashboards, requests keep coming to data analysts in a more or less structured process. In the end it is their job to collect, prioritize and answer the needs of business users, isn’t it?

5+1 reasons why this is my favorite data viz’ tool — and why it could become yours too — As I kept growing as a data analyst working at start-ups and scale-ups, I discovered several data visualization tools: Salesforce’s Tableau, Microsoft’s PowerBI, open-source Metabase… and obviously Google’s DataStudio. It is hard to evaluate how widely used DataStudio is across companies. But if we compare Gartner’s Magic Quadrant for Analytics…