by Maya Raviv | Jun 26, 2023 | Data Chant
Do you need to detect changes or errors between two revisions of mission-critical Excel workbooks? Would it be awesome if you could do it without the need to open the files every time? In 2021, we released a Power BI app, called Excel Compare. Due to its high demand...
by Delia Fernandez | May 16, 2022 | Data Chant
Guest Author: Henk-Jan van Well As a follow up to two older Matrix Multiplication posts here and here, I would like to share with you an alternative query for matrix multiplication using the Cartesian product-functionality within Power Query. This post first appeared...
by Delia Fernandez | Mar 24, 2022 | Data Chant
Now that we have introduced the technology in the previous blog post, Introduction to Power BI Dataflows, this post will cover topics about the authoring experience, some important considerations, basic architecture, and Do’s and Dont’s. Options to create tables This...
by Delia Fernandez | Feb 9, 2022 | Data Chant
For my first blog post I wanted to write about one of my favorite topics: Power BI Dataflows. If it’s the first time you read about this product or if it’s a product you have been trying to learn more about, this is meant for you. What Are Power BI Dataflows? This...
by Gil Raviv | Oct 15, 2021 | Data Chant
I have been quiet for a while and had a lot of thinking about my next chapter after leaving Avanade last August. Today, I would like to share with you a small bit of personal news, but more importantly — a major update about DataChant’s next chapter. Since 2013, when...
by Gil Raviv | Sep 10, 2021 | Data Chant
Follow @gilra Here is a quick update for my Russian friends and colleagues. My book “Power Query в Excel и Power BI: сбор, объединение и преобразование данныхis” is available here. This post first appeared...