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.
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
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
Click here to download the MP3 file.
Transcript of this session:
Download this podcast transcript [PDF]
Resources for this podcast
More information & tutorials on Power Query
- Introduction to Power Query – podcast
- Unpivot data with Power Query [tutorial]
- Import web data using 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.
One Response to “Easily Convert JSON to Excel – Step by Step Tutorial”
Great guide! You mentioned that "Power Query in Excel offers a quick, easy and straightforward way to convert JSON to Excel." This is very true for simple structures. For those dealing with deeply nested JSON that Power Query struggles with, I've found a few tips helpful: 1) Flatten the JSON structure before importing if possible, 2) Use Python for more complex transformations as you suggested.