Prepare and analyze in 7 min with Tableau

Share this post

In this video (commented in French) I will show you how from disparate Excel files you can simply straighten your data so that you can then simply analyze them.

The Use Case is rather simple: you work in mass distribution, and you have to analyze the sales and profits of your stores (in Europe). Obviously your sales manager pointed out a big profitability problem.

Your mission is to help him analyze this problem!

But now, reality reminds you and your data is not necessarily well standardized.

Preparatory work is therefore required to be able to properly consolidate these considerate sales data from separate data sources (here Excel files).

Then, once the data has been consolidated, we can embark on a fairly simple analysis and be able to respond to the real business challenges:

  • Why do I have a profitability concern?
  • In which product line am I seeing the concern (or is it generalized)?
  • Is it a regional, local problem?
  • and above all what is the cause?
  • Etc.
Share this post

Benoit Cayla

In more than 15 years, I have built-up a solid experience around various integration projects (data & applications). I have, indeed, worked in nine different companies and successively adopted the vision of the service provider, the customer and the software editor. This experience, which made me almost omniscient in my field naturally led me to be involved in large-scale projects around the digitalization of business processes, mainly in such sectors like insurance and finance. Really passionate about AI (Machine Learning, NLP and Deep Learning), I joined Blue Prism in 2019 as a pre-sales solution consultant, where I can combine my subject matter skills with automation to help my customers to automate complex business processes in a more efficient way. In parallel with my professional activity, I run a blog aimed at showing how to understand and analyze data as simply as possible: Learning, convincing by the arguments and passing on my knowledge could be my caracteristic triptych.

View all posts by Benoit Cayla →

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Fork me on GitHub