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 *...
What do you have to talk about on LinkedIn to get likes and comments?
After analysing the best hours to post on LinkedIn, I tackled a much more difficult problem: determining which topics generated the most views and engagement on LinkedIn. In today’s post, I will show you the results I was able to achieve using 2 specific tools: Anatella for data extraction and preparation on the one hand, and Tableau for exploring and visualising the effects on the other. If you are interested in this type of...
What is the best time to post on LinkedIn?
In their attempt to understand how the LinkedIn algorithm works, users of this social network often debate the ideal time to put their content online. I decided to do some analysis to get to the bottom of the truth and myths in this story. If you are interested in this kind of analysis and want to do the same with your data, subscribe to our newsletter (below). When the procedure and tools are ready to be released to carry out these...
Fuzzy Matching with Alteryx: tests, results and comparison
Fuzzy matching is a handy technique in many everyday situations. Alteryx offers a Fuzzy Matching feature that I have compared to Anatella’s function. I had already talked about Fuzzy Matching in this post. The features of Fuzzy Matching in Tableau Prep builder not being convincing, I wanted to see what Alteryx had to offer. In the end, Anatella gives better results, and the programming of the ETL process is much more efficient....
Fuzzy matching: comparison of 4 methods for making a join
In a previous article, I shared with you a solution to make a fuzzy matching between 2 different tables. I had then compared 2 ETL (Extract Transform Load) solutions. Tableau Prep Builder did not achieve the desired result. So, I turned to Anatella. In today’s article, I explore the different Fuzzy Matching algorithms available in this tool and their effects. As you will see, an algorithm emerges as the winner of the...
Linkedin algorithm: 1 reaction will get you 83 views
How does Linkedin algorithm influence? What is the correlation between the number of likes or comments and the number of views in LinkedIn? Everybody’s trying to understand LinkedIn’s algorithm. Some are even trying to hack it. While theories abound, no one knows how it works. I’ve rolled up my sleeves, and today I’m going to explain it to you, with a statistical model to back it up. BONUS: receive your...
Fuzzy matching between tables: 2 ETL compared (Tableau Prep Builder vs Anatella)
If you are manipulating data for analysis or visualisation purposes, you may have encountered this problem before. You need to create a join between 2 databases, but the entries in the reference field are not the same. Differences in spelling, different terminologies, … the reasons are many and varied. During the research that I’m doing to visualise migration flows, I was confronted with this problem. I had to solve it by...