general
-
Time Travel with Data – Use cases and techniques
Data Historization is a pretty frequent need in data analytics that should be managed at some point in most of the companies. Let’s just think about the following use case. A company is having it’s sales order backlog in it’s ERP system. Management is interested in the backlog, but not only how much it is…
-
Consolidating and Enriching Multiple Excel Sheets
In excel it happens often that multiple sheets should be consolidated in one and that should be enriched with a higher level grouping. In this short post I’m showing you how you can use Power Query to do that in a dynamic way in no more that 3 minutes. Cheers!
-
Data Awareness as the essential skill in the 2020’s
Evolution is something that cannot be stopped. Darwin said it is not the smartest, neither the strongest who will survive, but the one who can adapt changes quickly. And this is so true. Sometimes we have to act with this principle in our private life, just as in our profession. I’m currently reading a book…
-
I’m the data guy, but… which one exactly?
A lot of times I’m asked about my job by my relatives, friends or even a bank or administration office, and to be honest sometimes it is pretty hard for me to answer. Not that I wouldn’t know what I do, but when sometimes I’m saying I’m BI expert or Data Engineer they ask what?…
Adam's Perspective on Data 