by Maya Raviv | Oct 11, 2021 | Power Query
Hi again. This is Maya (you can find me on Linkedin here), with my second post on DataChant: a revision of a previous tutorial. Removing empty rows or columns from tables is a very common challenge of data-cleaning. The tutorial in mention, which happens to be one of...
by Gil Raviv | Sep 10, 2021 | Book
Follow @gilra Here is a quick update for my Russian friends and colleagues. My book “Power Query в Excel и Power BI: сбор, объединение и преобразование данныхis” is available here. I am truly humbled by the impact that the book had made on the journey of...
by Gil Raviv | Aug 25, 2021 | Power Query
Follow @gilra Earlier this month I published a new and very practical Power BI app on Microsoft AppSource. The app audits Excel workbooks and detects changes and errors. To implement the app I needed to resolve key obstacles that are very common when you import Excel...
by Gil Raviv | Aug 16, 2021 | Power BI, Update
This Friday was my last day at Avanade. It was an amazing journey for me and I would like to deeply thank many people at Avanade for the inspiration, friendship, and wonderful experience over the last 5 years. Avanade was a great home and a family for me. I started as...
by Gil Raviv | Aug 4, 2021 | Uncategorized
Follow @gilra I admit that the technique I will share with you in this post may not have many use-cases, but it was a crucial component for the Excel Compare Power BI app that we released on AppSource earlier this week, and you can consider reading this post as a...