Articles filed underETL
Migration to Europe: interactive visualisation using Tableau
By Pierre-Nicolas Schwab •
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…
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…
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…
Fuzzy Matching with Alteryx: tests, results and comparison
By Pierre-Nicolas Schwab •
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…
Fuzzy matching: comparison of 4 methods for making a join
By Pierre-Nicolas Schwab •
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…
Linkedin algorithm: 1 reaction will get you 83 views
By Pierre-Nicolas Schwab •
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…
Fuzzy matching between tables: 2 ETL compared (Tableau Prep Builder vs Anatella)
By Pierre-Nicolas Schwab •
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,…
