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.
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.
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.
Thanks for the heads up Gil, just added to my MUST READ for this year, btw hope you had a great birthday
Thank you Pat. It was a good birthday. I hope that the book will meet your expectations.
Happy Birthday – look forward to your book. BTW, my birthday was June 9.
Thank you Nick. Hope you had a good birthday-month.
Hi Gil
Is your book going to be based on new changes in UI coming to power query from October this year?
No. The book is planned to be released next month. The book is not focused on trivial explanations of the UI, but on solving common real-life data challenges. As such, I donβt expect the new UI to make any difference. But I will monitor any gaps between the latest Power Query and the book closely and publish on my blog the clarification for any mismatch that we will found. Does it make sense?
Thats great Gil, I guess i can safely place the order π will keep an eye on your blog posts in future as well.Thanks a lot for publishing your book on this subject.
Thank you K B.
Hi! Thank you for your blog. Will it be possible to get an Ebook version?
Thank you Nathan for reading. Yes, you can order the eBook. Currently only in Microsoft Press store https://www.microsoftpressstore.com/store/collect-combine-and-transform-data-using-power-query-9781509308019
Thanks for your quick reply π
Does your book cover how to configure social media dashboards? including M query to extract likes and reactions?
The book covers the retrieval of Facebook posts, comments and shares. Likes and reactions are not covered.