The Definitive Guide to Power Query M - What to expect?

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 ธ.ค. 2024

ความคิดเห็น • 78

  • @BIGorilla
    @BIGorilla  8 หลายเดือนก่อน +8

    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 🙌🙌

  • @GeorgeKlucsarits
    @GeorgeKlucsarits 8 หลายเดือนก่อน +2

    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!

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน +1

      Hey George, you're so welcome. You even went out of your way to leave a comment. Many thanks!

  • @juansebastianquinteroboter245
    @juansebastianquinteroboter245 8 หลายเดือนก่อน +1

    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.

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน

      My man! I hope you're gonna like it!

  • @markusleucht6603
    @markusleucht6603 8 หลายเดือนก่อน +2

    ordered this instant classic yesterday. thanks!

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน +1

      ❤❤ appreciate that. I’m sure you’re gonna find tons of gems useful for your day to day. Thanks for the support Markus!

  • @monicacisneros327
    @monicacisneros327 5 หลายเดือนก่อน

    I just ordered the book. I hope it has a link to sample files.

  • @rodrigochavez7
    @rodrigochavez7 8 หลายเดือนก่อน +1

    Hey Rick,
    Are you thinking in launch a M course? That would be great.
    Great book!

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน +2

      Yes I’m thinking of that too! I hope to work on that in H2 of this year 😁

  • @whizzohk
    @whizzohk 8 หลายเดือนก่อน

    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.

    • @BIGorilla
      @BIGorilla  4 หลายเดือนก่อน

      You rock!

  • @cooolbreeze
    @cooolbreeze 5 หลายเดือนก่อน

    I think there is an error in Chapter 3. On Page 59, in the section about Folders, 2nd paragraph, describes how Folder.Contents and File.Contents works. I think you meant to describe how Folder.Contents and Folder.Files work? Also, what is said about Folder.Contents is confusing. It implies that the function will delve into each folder within the path. But this function's scope is only the folder that's fed to it

  • @GosCee
    @GosCee 8 หลายเดือนก่อน

    Rick, that is thrilling news! I don't even need to finish watching this video to decide to buy it. Your previous TH-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

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน +1

      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

  • @McIlravyInc
    @McIlravyInc 8 หลายเดือนก่อน

    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!

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน

      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!

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน

      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!

  • @adwaitetiwarycfa7087
    @adwaitetiwarycfa7087 7 หลายเดือนก่อน

    This is high-quality work. Look forward to buying a copy!

    • @BIGorilla
      @BIGorilla  7 หลายเดือนก่อน

      Thank you! Go for it ;) I’m sure you’ll like it!

  • @mohamedbakr595
    @mohamedbakr595 8 หลายเดือนก่อน +1

    Hi Rick, How can i get PDF version, is it available for purchasing.

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน +1

      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

  • @melann1111
    @melann1111 8 หลายเดือนก่อน +1

    Awesome! I have learned SO much after subscribing to Packt. Definitely worth the subscription! Will be downloading this asap !

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน

      Welcome aboard!

  • @clay4gli
    @clay4gli 6 หลายเดือนก่อน

    I have your book. It is indeed everything you say. I am reading it cover to cover.
    I am very happy to have it! ❤

    • @BIGorilla
      @BIGorilla  4 หลายเดือนก่อน

      Wow, thank you!

  • @gonzuic
    @gonzuic 6 หลายเดือนก่อน

    Hi Rick, I have hearded about you recently. In your book, do you explain the advance M code?
    Thank you…

    • @BIGorilla
      @BIGorilla  4 หลายเดือนก่อน +1

      Absolutely. From fundamentals to more advanced concepts. There’s something in there if you want to master the M language. 😊

  • @7213261
    @7213261 8 หลายเดือนก่อน +1

    Congrats Rick!

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน

      ❤ thank you!

  • @mcwahaab
    @mcwahaab 8 หลายเดือนก่อน

    Eagerly awaiting to buy this book. Thanks for all the effort.

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน

      Hope you enjoy it!

  • @garywatson928
    @garywatson928 8 หลายเดือนก่อน +1

    Ordered the book. Good work

    • @BIGorilla
      @BIGorilla  7 หลายเดือนก่อน

      Thank you!

  • @Gosiapon
    @Gosiapon 8 หลายเดือนก่อน

    I have just purchased your book. Thanks for the great ideas! 💡

  • @eriknegron1047
    @eriknegron1047 8 หลายเดือนก่อน +1

    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!

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน

      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.

    • @eriknegron1047
      @eriknegron1047 8 หลายเดือนก่อน +1

      @@BIGorilla That's excellent and exactly what i was looking for. Look forward going through it !

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน

      @@eriknegron1047 Fantastic, enjoy the read!

  • @themolestones
    @themolestones 8 หลายเดือนก่อน +1

    Just bought it...looking forward to reading this amazing book. 😀

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน +2

      enjoy! I'm confident you'll pick up some nice tips and tricks!

  • @gezin_longuevilleosaer4245
    @gezin_longuevilleosaer4245 8 หลายเดือนก่อน

    Rick, ik heb je boek ondertussen sterk aanbevolen aan mijn collega-dataspecialisten op het werk.

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน

      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 :)!

  • @IshraDataLabs
    @IshraDataLabs 5 หลายเดือนก่อน

    Purchased !!

  • @marcusdrees5155
    @marcusdrees5155 8 หลายเดือนก่อน

    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

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน

      Glad it was helpful! Hope you like the book🙏

  • @juanalfonso5259
    @juanalfonso5259 8 หลายเดือนก่อน +1

    Hi Rick, welcome back. We miss you

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน

      I've missed you too. Back in action now :)

  • @Franklinvaz
    @Franklinvaz 7 หลายเดือนก่อน

    Trusting your efforts on bringing this book out successfully. Thank you very much.. Bought it 😁

    • @BIGorilla
      @BIGorilla  4 หลายเดือนก่อน

      Hope you enjoy it!

  • @GeertDelmulle
    @GeertDelmulle 8 หลายเดือนก่อน

    Can I buy it in PDF so I can look things up in the book?

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน +1

      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

    • @GeertDelmulle
      @GeertDelmulle 8 หลายเดือนก่อน

      @@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)?

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน

      @@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

  • @kebincui
    @kebincui 8 หลายเดือนก่อน +1

    Already bought it ❤👍

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน

      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 !

  • @aartdevletter5822
    @aartdevletter5822 8 หลายเดือนก่อน

    M is highly underrated, yet powerful. Cheers

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน

      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!

    • @aartdevletter5822
      @aartdevletter5822 8 หลายเดือนก่อน

      @@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

  • @epernayjfl
    @epernayjfl 8 หลายเดือนก่อน

    Bonjour à vous !
    Une version française du guide serait grandement appréciée...🙏

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน +1

      At the moment, no. Who knows, maybe in the future!

  • @datadragyn
    @datadragyn 4 หลายเดือนก่อน

    Own it and love it

  • @luisfernandomacedo1451
    @luisfernandomacedo1451 8 หลายเดือนก่อน +1

    Great! Now give us a Gorilla discount, I guy from Brazil wants to get it😅

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน +1

      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!

  • @raitup00
    @raitup00 8 หลายเดือนก่อน +1

    Awesome!!! it's going to be like to have a piece of your brain printend in my hands.

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน +1

      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 🤯 😋

  • @mrbartuss1
    @mrbartuss1 8 หลายเดือนก่อน +2

    Good to know you still remember your YT password

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน +2

      I know right. The password just popped up in my mind today. And I got lucky it worked. Hope to be here more now :)

    • @mrbartuss1
      @mrbartuss1 8 หลายเดือนก่อน

      @@BIGorilla We hope so too!

    • @GeertDelmulle
      @GeertDelmulle 8 หลายเดือนก่อน

      @@mrbartuss1Show some respect, man!
      These people have worked long and hard on this comprehensive book - they deserve some appreciation for their hard labour.

    • @mrbartuss1
      @mrbartuss1 8 หลายเดือนก่อน

      @@GeertDelmulle Respect is what I meant. I really hope there will be more videos from him

  • @rrrraaaacccc80
    @rrrraaaacccc80 7 หลายเดือนก่อน

    💯👍

  • @RobertoStaltari
    @RobertoStaltari 8 หลายเดือนก่อน +1

    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...

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน

      That would be so nice. Hopefully its coming later!

  • @erivaldolopes632
    @erivaldolopes632 8 หลายเดือนก่อน

    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?!

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน +1

      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!

  • @Charlie888
    @Charlie888 8 หลายเดือนก่อน

    Good job!

    • @BIGorilla
      @BIGorilla  8 หลายเดือนก่อน +1

      Thank you!