The Definitive Guide to Power Query M - What to expect?
Вставка
- Опубліковано 11 лип 2024
- I'm happy to announce our new book: 'The Definitive Guide to Power Query (M). The book aims to teach users the M language, so they can solve almost 100% of their data transformation challenges. In this video, I walk through the table of contents and provide context on what the book teaches.
You can buy the book here: geni.us/ODZl8
WRITTEN ARTICLE:
gorilla.bi/power-query/the-de...
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
Website: gorilla.bi
SUBSCRIBE TO MY CHANNEL
ua-cam.com/users/bigorilla?sub_con...
LET'S CONNECT:
Blog: gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#M #powerquery #bigorilla
The book is available at: geni.us/ODZl8. So glad the book can now help others master M. Thank you all for your support, much appreciated 🙌🙌
I have your book. It is indeed everything you say. I am reading it cover to cover.
I am very happy to have it! ❤
Hi Rick, I received the book a couple of days ago and it's an outstanding reference that I recommend to anyone looking to improve their Power Query skills. You, Gregory and Melissa have done a great job in creating a resource for those who were looking for that "next level" when it comes to PQ.
Right now I'm doing a deep dive into Chapter 3: Accessing and Combining Data. It's great to be able to fully understand what PQ is doing and how I can improve and optimize a task I do almost daily. So far, just about every chapter has revealed some tip or trick or explanation that will improve my workflow and make my job easier.
I've taken advantage of your YT and blog content for some time, and Melissa's famous date table has been my go-to solution for a long time. Glad to be able to support your efforts in a small way by buying this book.
Thanks!
Hey George, you're so welcome. You even went out of your way to leave a comment. Many thanks!
ordered this instant classic yesterday. thanks!
❤❤ appreciate that. I’m sure you’re gonna find tons of gems useful for your day to day. Thanks for the support Markus!
Ordered the book. Good work
Thank you!
It nice to see you back, I bought the book and I am hyped to read it. I am hopeful that you have a successful book publication.
My man! I hope you're gonna like it!
This is high-quality work. Look forward to buying a copy!
Thank you! Go for it ;) I’m sure you’ll like it!
Trusting your efforts on bringing this book out successfully. Thank you very much.. Bought it 😁
Congrats Rick!
❤ thank you!
I have just purchased your book. Thanks for the great ideas! 💡
Rick, that is thrilling news! I don't even need to finish watching this video to decide to buy it. Your previous UA-cam videos give me enough reason to make this book a must-have. I am looking forward to using it. Thank you very much for all your help with Power Query. Cheers
Appreciate you GosCee. Really appreciate your trust in our work.
I also hope to shoot out some more videos the coming time. It's been a long long time. And it's such a great way of providing content. Stay tuned for more :)
Rick
Eagerly awaiting to buy this book. Thanks for all the effort.
Hope you enjoy it!
Just bought it...looking forward to reading this amazing book. 😀
enjoy! I'm confident you'll pick up some nice tips and tricks!
Another customer! Book bought. Thanks Rick and team for identifying a gap in the market when it comes to focussing on M itself, rather than just the M generated by the UI.
Awesome! I have learned SO much after subscribing to Packt. Definitely worth the subscription! Will be downloading this asap !
Welcome aboard!
Hi Rick, I have just ordered it as well and I am sure it will be of great help on my personal M-Journey. Thank you for your videos you have done for the community.
Marcus
Glad it was helpful! Hope you like the book🙏
Already bought it ❤👍
You already got it, I'm glad to hear that ! 🙌. I hope you're going to pick up some cool stuff! We covered a lot of ground, and there's something in there for everyone. The question just remains, where to start ;-)
Hope the walk through the table of contents helped. I appreciate your support Kebincui !
Data types are the main cause of many of my unexpected results in PQ, especially when doing replace or other matching to lookup/merge etc. So they are VERY important to me!
I think you'll love the data types chapter in our new book. Honestly, when I started writing it I thought it was going to be a tough but reasonable chapter. It ended up being the hardest one of all. If you happen to get the book, do drop me a note with your thoughts on it!
I think you'll love the data types chapter in our new book. Honestly, when I started writing it I thought it was going to be a tough but reasonable chapter. It ended up being the hardest one of all. If you happen to get the book, do drop me a note with your thoughts on it!
Hi Rick, welcome back. We miss you
I've missed you too. Back in action now :)
Thanks for the explanation.
Was debating about getting it, have it in my wishlst, but was not sure how it compared to the likes of M is for Data Monkey which i already own. This will be a nice addition to my collection.
Congrats on the publication!
Hey Erik,
That's a good question! There's some great M books out there. M is for data monkey (and the revised version of it), then there's Collect Combine and Transform by Gil Raviv.
And both books do well at explaining how to solve practical problems by using the User interface. Gil Raviv even touches some custom M coding for creating your own functions.
Yet this book really focuses on the M language itself. The fundamentals of how it works, but also characteristics of data types, values. How you can work with structured values to improve your work flow, create your custom functions, built a connector.
I'd say this book teaches you M to solve you solutions, whereas the other ones focus on mostly the UI. While they both have their place, this one gives you the skills to understand the coding language behind all the buttons.
@@BIGorilla That's excellent and exactly what i was looking for. Look forward going through it !
@@eriknegron1047 Fantastic, enjoy the read!
M is highly underrated, yet powerful. Cheers
Agree. And at the same time, a lot of people have never seen it before. Especially excel users. There’s a huge market for this still to create awareness for!
@@BIGorilla Agree. This book won’t be an entry level for people I think - looking at its contents and structure. I work at a large company (over 11.000 employees) and ofc in D&A roles people know M, but often not well enough (eg Me). The real market expansion is at the ones u just mentioned: good old Excel users performing daunting transformations with IF statements, clicks and all kinds of “crap” to be honest. I still havent found a proper way to let people feel the power of M/PQ. Using PBi reports sometimes works, however they dont care about the back-end so to speak
Great! Now give us a Gorilla discount, I guy from Brazil wants to get it😅
Hey Luis - You might be able to find some amazon stores that discount the book. For instance, the Dutch store offers the book now with 63% discount for the paperback version: www.amazon.nl/Definitive-Guide-Power-Query-Transformation/dp/1835089720/ref=zg_bs_g_16437535031_d_sccl_1/262-4382161-2742433?psc=1
If you'd find one that does that with the kindle version, you're all set!
Rick, ik heb je boek ondertussen sterk aanbevolen aan mijn collega-dataspecialisten op het werk.
Super! Ik denk echt dat er voor veel mensen een wereld open kan gaan qua M taal. En de talloze mogelijkheden die er zijn. Bedankt voor de aanbevelingen :)!
Hey Rick,
Are you thinking in launch a M course? That would be great.
Great book!
Yes I’m thinking of that too! I hope to work on that in H2 of this year 😁
I just ordered the book. I hope it has a link to sample files.
Awesome!!! it's going to be like to have a piece of your brain printend in my hands.
Hope you like it. And I agree. It sure feels like a piece of my brain is in it. It’s still recovering from the writings 🤯 😋
Hi Rick, I have hearded about you recently. In your book, do you explain the advance M code?
Thank you…
💯👍
Hi Rick, How can i get PDF version, is it available for purchasing.
I believe with each printed version, you can request a pdf with packt for free.
If you only want pdf, you can go here: www.packtpub.com/product/the-definitive-guide-to-power-query-m/9781835089729
Bonjour à vous !
Une version française du guide serait grandement appréciée...🙏
At the moment, no. Who knows, maybe in the future!
Hi Rick, congrats for the book. This was the missing knowledge in what regards to the M language. We definitely needed a guide to M.
Indeed, you were missed.
Just curious though, do you cover in your book the trick to call your M steps from a file saved elsewhere for example?!
We don't cover that in the book since it's a method I don't recommend in general. Ofcourse feel free to use it!
yahay!! I saw what you did there.... you used the 5 W's and an H... someone knows Lean
Hey Dvul,
Haha that’s fun. Admittedly, I don’t know any Lean, but if that’s what it covers. I guess the framework makes explicit what seems like a natural story to tell.
Been working on the book for months, I completely winged this walkthrough. Hope you liked it!
Can I buy it in PDF so I can look things up in the book?
Hey Geert - yes absolutely. I believe the PDF is available through Packt: www.packtpub.com/product/the-definitive-guide-to-power-query-m/9781835089729
They also provide a yearly subscription, just in case you like reading a lot of different technical books. Hope that helps, Rick
@@BIGorilla Bedankt Rick, ik heb de PDF meteen gekocht! Ik ben benieuwd naar dit uitgebreide naslagwerk! 🙂
Het downloaden van de oefenbestanden is een beetje een moeizaam proces - file per file downloaden, en .csv wordt automatisch .txt. (...)
Kan dit wat gestroomlijnd worden (bv. een ZIP-file per hoofdstuk)?
@@GeertDelmulle ik moet bekennen zelf niet zo handig te zijn met Github. Maar Greg Deckler stuurt mij net door dat je de bestanden in een keer kunt downloaden als zip. Dan behoudt je ook het CSV formaat, in plaats van .txt. Om dat te doen:
1. Je kunt navigeren naar github.com/PacktPublishing/The-Definitive-Guide-to-Power-Query-M-/
2. Bovenaan de pagina staat een groene knop met ""
3. Als je daar op klikt staat er "Download Zip"
Dan heb je de bestanden van alle hoofdstukken in een keer. Help dat?
Groet, Rick
Good to know you still remember your YT password
I know right. The password just popped up in my mind today. And I got lucky it worked. Hope to be here more now :)
@@BIGorilla We hope so too!
@@mrbartuss1Show some respect, man!
These people have worked long and hard on this comprehensive book - they deserve some appreciation for their hard labour.
@@GeertDelmulle Respect is what I meant. I really hope there will be more videos from him
We are all waiting for Microsoft to improve the M editor. Asking Find and alike functions is too much? A debugger I bet is just out of discussion...
That would be so nice. Hopefully its coming later!
Good job!
Thank you!