Happy Birthday and #PowerQuery Book Update

I am celebrating my birthday today, so I wanted to share with you a quick update about my book. It is now in production. You can already pre-order it here. Current release date is September 4, 2018.

The title of the book will change a bit: The new name is Collect, Transform and Combine data using Power Query in Excel and Power BI

(Can you find the differences?)

Here are some numbers about the book: The book manuscript has 400 pages, 14 chapters, 144 figures (screenshots and diagram flows), 71 exercises, and 200 resources and solution files (.xlsx and .pbix). I hope you are going to love it.



  1. Edh Reply

    Cannot wait. I hope your method of providing examples is to have one that is empty that we have to build, then a solution file if we get stuck.

    • Gil Raviv Reply

      Thank you Edh. The exercises are built for you to start with problem and the data sources. You can try to resolve it with a blank workbook or Power BI report, or read the step-by-step walk through that explain the solution. For those who like shortcuts, there are also solution files available to download.

  2. Pat Biggar Reply

    Thanks for the heads up Gil, just added to my MUST READ for this year, btw hope you had a great birthday

    • Gil Raviv Post authorReply

      Thank you Pat. It was a good birthday. I hope that the book will meet your expectations.

Leave a Reply