1. LinkedIn: the sentiments expressed and their effect on virality

   By Pierre-Nicolas Schwab • 14 june 2021

   Everyone agrees that the content of LinkedIn posts is a determining factor in the probability that they go viral. So today, I'm not going to answer the question "What should we talk about on LinkedIn?" but rather "How should we talk about…

   

2. The 3 factors that determine 55% of the success of your LinkedIn posts

   31/05/21

   Understanding how LinkedIn's algorithm works is a necessity to stay visible on this social network. This article reveals the results of an analysis I realized using 4.599 million LinkedIn posts in 193 countries. The results are surprising and challenge a lot…

   

3. 224 words, the magic number to boost the impact of your LinkedIn posts

   19/05/21

   Word count is one of the factors that determines the success of a post on LinkedIn, along with hashtags. I have made an analysis of nearly 5 million posts in 100 countries that shows a linear correlation between the word count…

   

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

   17/05/21

   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,…

   

5. Data Mining: Definitions, 5 Free Tools, and Techniques

   10/05/21

   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)…

   

6. AI enriches the experience of visitors to the Alechinsky exhibition

   By Pierre-Nicolas Schwab • 30 april 2021

   In a context where the Covid crisis severely impacts culture, it is more important than ever to build visitor loyalty. I had proposed different ways to improve the customer experience in museums, and today I suggest discovering an initiative of the Royal…

   

7. The place of data wrangling in the data value cycle

   19/04/21

   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…

   

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

   16/04/21

   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…

   

9. The UK Data Ethics Framework Explained

   02/04/21

   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…

   

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

    29/03/21

    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…

    

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

    26/03/21

    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…

    

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

    22/03/21

    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…

    

13. Benchmark: which ETL to choose to handle large files?

    15/03/21

    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…

    

14. ETL: use of ternary operators for data extraction in Excel

    12/02/21

    How to use an ETL solution to extract information from an Excel file and reconcile it? After explaining a method to automate the extraction from many Excel files, in today's post, I will go into more depth and explain how…

    

15. How to automate the extraction of data from Excel files

    01/02/21

    This is the problem that I have been facing recently. A client asked me to process data from hundreds of Excel files. Frankly, I didn't want to spend hours extracting this data manually. So, I automated the process with Anatella and…

    

16. Data preparation: definition, examples, advice [guide 2023]

    18/01/21

    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…

    

17. Data visualization: definition, examples, tools, advice [guide 2021]

    09/12/20

    Data Visualization, or DataViz, is the discipline that focuses on the graphical representation of raw data. The purpose of data visualization is to create value. The last few years have seen the emergence of new tools and practices around data visualization…

    

18. [Podcast] Teaching children to use digital technology

    23/11/20

    Nathalie Kuborn (We Are Coders), Gaëlle Girardeau (Cood) and Christophe Coquis (Geek Junior) talk to us about learning about computers, digital technology and the introduction to digital culture for children: the market, courses and advice. The market for teaching digital…

    

19. [Podcast] The essence of Data Art and Data Visualisation

    09/10/20

    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)…

    

20. Tutorial: How to create a Joyplot using Tableau

    02/10/20

    After having explained to you how to create an isometric hexmap, I now tackle a more difficult subject: creating a joyplot using Tableau. I used a joyplot in the visualisation I submitted to the IronViz. As this type of graph is relatively…

    

21. Covid-19: impact on the IT consulting market and outlook

    25/09/20

    The Covid-19 crisis has had a massive impact on the IT market. Some parts of this sector have benefited (think of everything that revolves around remote working), but others have also suffered enormously. This is the case of IT consultancy. According…

    

22. Rethinking the customer experience in museums with (Big) data

    09/09/20

    How can Big Data help museums reinvent themselves? How can data collection techniques be used to understand visitors better? How can data be used to build visitor loyalty? In this article, we propose a series of reflections on current and…

    

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

    10/08/20

    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…

    

24. Tableau Iron Viz 2020: thoughts on my first participation

    04/08/20

    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…

    

25. Migration to Europe: interactive visualisation using Tableau

    13/07/20

    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…

    

26. What do you have to talk about on LinkedIn to get likes and comments?

    06/07/20

    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…

    

27. What is the best time to post on LinkedIn?

    29/06/20

    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…

    

28. Fuzzy Matching with Alteryx: tests, results and comparison

    26/06/20

    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…

    

29. Fuzzy matching: comparison of 4 methods for making a join

    19/06/20

    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…

    

30. Linkedin algorithm: 1 reaction will get you 83 views

    15/06/20

    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…

    

31. Fuzzy matching between tables: 2 ETL compared (Tableau Prep Builder vs Anatella)

    12/06/20

    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,…

    

32. New LinkedIn algorithm: here’s how to stay visible

    27/05/20

    Linkedin's engineers published the recipe for their new algorithm on May 12, 2020. The least we can say is that it completely changes the practice of making a post go viral. If you want your LinkedIn posts to be seen…

    

33. Connected insurance: reliability of connected wristbands and hacking

    15/04/20

    In today's article, we will talk about the reliability of connected Fitbit wristbands and how they are being hacked. The phenomenon is still not very widespread in Europe, but in the United States, it has become a real problem. It…

    

34. How to hack the recommendation algorithms?

    12/02/20

    Hacking a recommendation algorithm is an operation that can be very profitable. Indeed, some recommendation algorithms are ubiquitous in our digital life and strongly influence our behaviour. We have become dependent on algorithms without realising it. For example, 35% of…

    

35. Simon Weckert, a German artist, has succeeded in hacking Google Maps

    07/02/20

    Hack an algorithm? Not necessarily as complicated as it sounds, and the economic consequences can be significant. Indeed, everything today is governed by algorithms, especially recommendation algorithms. Hijacking a recommendation algorithm can, therefore, have considerable financial repercussions. In today's article,…

    

36. 2025: the end of personalisation algorithms?

    13/01/20

    At a time when Amazon already achieves 35% of its turnover thanks to the algorithmic recommendation and launches two new personalisation tools (Discover and Showroom), Gartner announces the end of personalisation algorithms by 2025.  This ambiguous announcement seems to deserve…