fbpx
Search
Close this search box.

CP052: Book Review – M is for Data Monkey by Ken & Miguel

Share

Facebook
Twitter
LinkedIn

In the 52nd session of Chandoo.org podcast, let’s discuss monkeys, Ok, I am kidding. We are going to talk about M is for Data Monkey book.

session-052 - Book Review - M is for Data Monkey by Ken Puls & Miguel Escoabr

What is in this session?

In this podcast,

  • Updates: Why so much gap between episodes?
  • Quick introduction to Power Query
  • Why you should get this book?
  • What is in this book?
  • A very cool example of the techniques you will learn
  • Conclusions

Listen to this session

Click here to download the MP3 file.

Transcript of this session:

Download this podcast transcript [PDF]

Resources for this podcast

M is for Data Monkey book

More information &  tutorials on Power Query

More resources on Power Query

Courses to help you tackle data problems

What is your favorite Power Query book?

Have you read M is for data monkey? How do you like it? What other books on PQ do you read? Please share your opinions and suggestions in the comment box.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Weighted Average in Excel with Percentage Weights

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

9 Responses to “CP052: Book Review – M is for Data Monkey by Ken & Miguel”

  1. Mike says:

    Not really a podcast, but more a book recommendation for your friends book that you haven't read all of but are compensated for if we purchase through your links...

    • Chandoo says:

      Hi Mike, I think you misunderstood. Neither the friendship nor very small sales commission impacted my review. I genuinely like the book and want to share it with the podcast audience. I have spend first 12 minutes of the podcast (almost 40%) just talking about Power Query in general. Even while talking about the book, I emphasized on how the book helps you navigate PQ and use it better. I have read 2/3rds of the book and I know valuable content when I see it. You can take a call by reading it yourself.

      PS: Almost all leading and new Excel authors are my friends. So according to your logic, I should not review any books.

      • Hui... says:

        Just to add to what Chandoo said, Nearly all the Excel books are written by Excel MVP's, a few aren't
        As MVP's we are all part of a quite vibrant community where we meat, correspond and solve issues with each other regularly.
        It is not uncommon to wake up and find I have 50 emails from MVP's who are discussing any number of Excel issues.
        Next week I have a Meetup schedule to catchup with other Excel people on Financial Modelling in Perth, I catchup with teh MVP's in Australia once a year and we have a Global MVP conference in the USA once per year.
        Once you delve into Excel you quickly realise that none of us are Expert, we maybe in one small area but Excel is so huge that we use/need this community to spread and learn ideas.

  2. David Hager says:

    Enjoyed your podcast. Sounds like you and your family had a great vacation, as well.

  3. Excel Whizz says:

    Enjoyed the podcast too. I've read Power Query for Power BI and Excel (Chris Webb) which I'd recommend and will get round to this one at some point soon. I think it's the future and it's worth swotting up on it!

  4. dan l says:

    The book is pretty good, and powerquery is an absolute must have for the power pivot era.

  5. Jitendra kumar says:

    Hi, I am using Excel for a survey and need to be able to disable and enable cells based on responses from other cells. My worksheet is protected and all cells are locked, except the ones with the answer. Nothing fancy but need to know if its possible to run a script in the background and as the user answers questions, other question rows appear? 

  6. Gijeet says:

    Is M still applicable for Power BI Desktop of only for Excel?

  7. Shoaib says:

    Hi chandoo,

    Please advise books for VBA, TO become an expert in VBA from Beginner.
    the book which also shows easiest way of learning.

    please suggest some book for VBA as I am beginner for VBA/Macros

Leave a Reply