Earn money by answering our surveys

Register now!
IntoTheMinds consulting blog
Advice in Data & IT
How many hashtags should you put in your LinkedIn posts? [Research]
May17

How many hashtags should you put in your LinkedIn posts? [Research]

How many hashtags should you put in your LinkedIn posts to increase their visibility? By the way, is it a good thing to put hashtags, and how does the LinkedIn algorithm react? I have analyzed 4.988 million LinkedIn posts in more than 100 countries, and I will give you the answer in this article. If you want to receive more exclusive results by email, please subscribe to my newsletter and follow me on LinkedIn. Only for our...

Read More
Data Mining: Definitions, 5 Free Tools, and Techniques
May10

Data Mining: Definitions, 5 Free Tools, and Techniques

After the collection and preparation process, data analysis is necessary to find meaning in a data set. Looking at a page of data does very little for building models of customer behavior, so we need an intelligent way (data mining) to sift through information. By using statistics-based approaches and algorithms, we can start to mine data. Only for our subscribers: exclusive analyses and marketing advice Email address  *...

Read More
The place of data wrangling in the data value cycle
Apr19

The place of data wrangling in the data value cycle

In the world of data, data wrangling is a bit of a buzzword these days. We have already proposed a general overview here. In today’s article, we explain it in more detail and position data wrangling within the data value cycle. Summary Reminder on data wrangling Step 1: data acquisition Step 2: data storage Step 3: data exploitation Only for our subscribers: exclusive analyses and marketing advice Email address  * Subscribe...

Read More
Excel dominates the business world… and that’s not about to change
Apr16

Excel dominates the business world… and that’s not about to change

Few brands have a 100% penetration rate. Microsoft is one of them. Even better, one of its products, Microsoft Excel, is used by 99.99% of the world’s businesses. Microsoft Excel is everywhere. Can’t stand it anymore? Well, you’re going to have to get used to it because it’s not going to change any time soon. But if Excel has undeniable qualities, we must also question its efficiency in performing specific...

Read More
The UK Data Ethics Framework Explained
Apr02

The UK Data Ethics Framework Explained

First published in June 2018, the Government’s Data Ethics Framework is another way of protecting our sensitive information in a data-driven world. The framework was then updated in September 2020 to be more extensive and to create more awareness of these guidelines. Yet despite this, many are still unaware of what this framework actually is and what purpose it serves. That’s why we’ve put together this guide. Below, we’re going to...

Read More
Data wrangling: definition, steps, tools [guide 2021]
Mar29

Data wrangling: definition, steps, tools [guide 2021]

Data wrangling might sound like quite the intimidating tech term on the surface yet anyone can develop an understanding of this process with a little bit of time and effort. Data wrangling, also known as data munging, is part of the larger process of  “data preparation”. Data wrangling is the process performed to collect, select, re-structure, enrich and ultimately transform information with the aim of answering a specific question....

Read More
ETL benchmark: how long does it take to process 1 billion lines?
Mar26

ETL benchmark: how long does it take to process 1 billion lines?

In a previous article, I highlighted the importance of processing speed when choosing a data preparation solution (ETL). I made a first benchmark between Alteryx, Tableau Prep, and Anatella on a file of 108 million lines. This time I repeated the operation on 1.039 billion lines and added Talend to the benchmark. The results are unexpected since the processing speeds vary by a factor of 1 to 20. TEASER : stay tuned. In my next article...

Read More
Data preparation: how to choose the right solution for your needs?
Mar22

Data preparation: how to choose the right solution for your needs?

I regularly use 4 data preparation solutions: Alteryx, Tableau Prep, Talend, and Anatella. The G2 benchmark lists no less than 40 of them. This article explains why the G2 benchmark is not necessarily relevant and what criteria to use to compare the ETL (Extract – Transform – Load) solutions best suited to your needs. Summary What is an ETL? The G2 benchmark criteria The most important criteria for choosing an ETL, in my...

Read More
Benchmark: which ETL to choose to handle large files?
Mar15

Benchmark: which ETL to choose to handle large files?

When it comes to data preparation, it is clear that a large part of the processes still takes place offline, with archives extracted from relational databases. And when these archives need to be manipulated by data engineers, it is essential to have an ETL that can handle the load. In today’s article, I propose to tackle the fascinating subject of large files by comparing 2 ETL’s that I use daily: Alteryx and Anatella....

Read More
SEO: 50,000 pages analyzed and 2m of queries easily accessible
Jan25

SEO: 50,000 pages analyzed and 2m of queries easily accessible

SEO research. We analyzed 50000 web pages, covering 185 keywords related to data science in 16 countries. The raw data came from Ahrefs. We used Anatella to prepare and clean the data and Tableau to visualize it. This research’s main result is that there are untapped opportunities to rank on the first page of Google on English keywords outside English-speaking countries. Here is what we learned. Some figures from our SEO...

Read More
Data preparation: definition, examples, advice [guide 2021]
Jan18

Data preparation: definition, examples, advice [guide 2021]

To talk about data preparation, what better way to start than from observation. In the world of data, there is a rule that everyone knows: 80% of a data scientist’s time is spent preparing his data, and only 20% working on it, especially its visualization. This article will focus on data preparation: the most frequently encountered problems, tools, and trends. Let’s go for new data adventures! Summary Introduction Data...

Read More
[Podcast] The essence of Data Art and Data Visualisation
Oct09

[Podcast] The essence of Data Art and Data Visualisation

Nicholas Rougeux defines himself as a “data artist”, and his talent for visualising data is obvious. So obvious that he markets his work in the form of posters and I even got one for my birthday 🙂 Run to his blog (www.c82.net) if you lack inspiration or if you want to see the best in DataViz. In this podcast, I talk with Nicholas about his creative process, his sources of inspiration, and of course, the technical aspects...

Read More
Isometric Hexmap using Tableau: a step-by-step guide
Aug10

Isometric Hexmap using Tableau: a step-by-step guide

As part of my participation in the Iron Viz 2020, I created a new type of visualisation using Tableau, which has received a lot of positive feedback. I called it ‘isometric hexmap’. In this article, I explain how to reproduce this type of representation and give you access to the source files. You can access the interactive version on Tableau Public. If you like this visualisation, feel free to leave a comment and to use...

Read More
Tableau Iron Viz 2020: thoughts on my first participation
Aug04

Tableau Iron Viz 2020: thoughts on my first participation

The Iron Viz is the “world championship” that crowns the 3 leading Tableau developers, a software that allows you to visualise the data. This year I decided to participate also (access my contribution here). In this article, I look back on my experience, what I learned from the preparation of the competition and the difficulties I encountered. 6 tips for a good #Dataviz Spend time choosing a rich, quality primary data...

Read More
Migration to Europe: interactive visualisation using Tableau
Jul13

Migration to Europe: interactive visualisation using Tableau

How can migration to EU countries be represented attractively? This is the question I wanted to answer using Tableau Software. If the question was simple, the answer was not so simple, and it took me a few days of deliberation to find the right solution and the right design. Below I present it to you with the modus operandi to reproduce it. Only for our subscribers: exclusive analyses and marketing advice Email address  *...

Read More