The Impact of Power Query – Survey Results
Recently I shared with you a survey here and asked you to estimate the impact of Power Query: How much time does Power Query save you in a year? How much...
Category: Power Query
Preserving context from multiple worksheets – Bonus Exercise – Chapter 5 – #PowerQuery Book
This is the third bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. Today's bonus exercise takes...
Preserving Context from CSV – Bonus Exercise – Chapter 5 – #PowerQuery Book
This is the second bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. In Chapter 5 you learn how to...
The potential impact of #PowerQuery – Your story can be featured
Earlier this year I published a survey to assess the impact of Power Query in organizations. I have decided to publish this survey again, and share the results...
My #PowerQuery book has arrived
If you are following me on social media, this video will not be new. Two days ago I received my print copy of the book. The book is real :) I was so excited...
Finding mismatched headers and creating a conversion table – Bonus Exercise – Chapter 4 – #PowerQuery Book
This is the first post of a series of bonus exercises that will accompany my book, Collect, Combine, and Transform Data using Power Query in Excel and Power...
The Digital Version of the New #PowerQuery Book is Ready
This is exciting! The digital version of the book "Collect, Combine and Transform Data Using Power Query in Excel and Power BI" is out. You can purchase it...
First Page of Chapter 1 “Introduction to Power Query”
Today I got from the production team the first chapters of the book for final proofreading. I had to share with you a screenshot of the first page of Chapter...
Book Excerpt: Translating Text in Excel and Power BI using Power Query
I am excited to share an excerpt from the draft manuscript of my book. In this excerpt, which is part of chapter 12, "Advanced Text Analytics: Extracting...
The Potential Impact of #PowerQuery – A Crowd Wisdom Survey
Answer this short survey to estimate the potential business impact of Power Query. Once you answer the survey, you can scroll down to review the results below....
