Powerful ideas from top nonfiction
Try Blinkist to get the key ideas from 7,500+ bestselling nonfiction titles and podcasts. Listen or read in just 15 minutes.
Get started for free
Blink 3 of 8 - The 5 AM Club
by Robin Sharma
M Is for (Data) Monkey summary
Ken Puls
Brief summary
M Is for (Data) Monkey by Ken Puls is a comprehensive guide to Microsoft Excel's Power Query tool. It offers step-by-step instructions and real-world examples to help you master the art of data transformation and analysis.
Topics
Table of Contents
M Is for (Data) Monkey
Summary of key ideas
Understanding Power Query and M Language
In M Is for (Data) Monkey by Ken Puls and Miguel Escobar, we delve into the world of Power Query, a powerful data transformation tool in Microsoft Excel. The authors begin by introducing the reader to the concept of Power Query and its capabilities, including its M language, which is used to perform data transformation operations.
We learn about the various data sources that Power Query can connect to, such as databases, web pages, and text files. The authors provide step-by-step instructions on how to connect to and import data from these sources, and then guide us through the process of transforming the imported data using Power Query.
Data Transformation and Cleaning
As we progress through M Is for (Data) Monkey, we explore the different data transformation operations that Power Query supports. These include filtering, sorting, grouping, and aggregating data, as well as techniques for handling errors and missing values. The authors emphasize the importance of data cleaning and demonstrate how Power Query can be used to clean and prepare data for analysis.
In addition, Puls and Escobar introduce us to the concept of data types and show us how to handle them effectively in Power Query. They explain how to change data types, handle date and time values, and work with text and numerical data. The authors also discuss the importance of data modeling and how Power Query can be used to create data models for analysis.
Advanced Data Transformation Techniques
In the latter part of the book, the authors dive into more advanced data transformation techniques. They discuss the use of custom functions and parameters in Power Query, which allow for reusability and scalability of data transformation tasks. They also cover the use of conditional logic and loops in M language to perform complex data transformations.
Puls and Escobar further explore the capabilities of Power Query in handling hierarchical data structures, such as JSON and XML. They demonstrate how to flatten and expand nested data, as well as how to work with APIs to import and transform web-based data. Throughout these discussions, the authors provide practical examples and exercises to reinforce learning.
Creating Interactive Dashboards and Reports
As we near the end of M Is for (Data) Monkey, the focus shifts to using Power Query in conjunction with Power Pivot and Power BI to create interactive dashboards and reports. Puls and Escobar explain how to load data into Power Pivot from Power Query, create relationships between different data tables, and build data models for analysis.
The authors also demonstrate the process of creating visualizations and reports using Power BI, a business analytics tool that works seamlessly with Power Query. They explain how to leverage the data transformation capabilities of Power Query to build compelling and insightful dashboards and reports.
Conclusion: Mastering Power Query for Effective Data Management
In conclusion, M Is for (Data) Monkey serves as an in-depth guide to mastering Power Query and the M language for effective data management and analysis. Puls and Escobar equip us with the knowledge and skills needed to harness the full potential of Power Query in transforming, cleaning, and preparing data for analysis, and in creating powerful visualizations and reports.
The book is suitable for Excel users, data analysts, and business intelligence professionals looking to enhance their data manipulation and visualization capabilities. With its comprehensive coverage of Power Query's features and functionalities, M Is for (Data) Monkey provides a valuable resource for anyone working with data in Excel or Power BI.
How do we create content on this page?
More knowledge in less time
Read or listen
Get the key ideas from nonfiction bestsellers in minutes, not hours.
Find your next read
Get book lists curated by experts and personalized recommendations.
Shortcasts New
We’ve teamed up with podcast creators to bring you key insights from podcasts.
What is M Is for (Data) Monkey about?
M Is for (Data) Monkey by Ken Puls is a comprehensive guide to using Microsoft Excel's Power Query tool. The book provides step-by-step instructions and real-world examples to help readers master data transformation and analysis. Whether you're a beginner or an experienced Excel user, this book will help you unlock the full potential of Power Query.
M Is for (Data) Monkey Review
M Is for (Data) Monkey (2015) teaches readers how to analyze and visualize data effectively using Microsoft Excel and Power Query. Here's why this book is worth your time:
- Explains complex data analysis techniques in clear, understandable language, making it accessible even for beginners.
- Demonstrates how to automate data tasks and save time, increasing efficiency and productivity in data processing.
- Offers practical examples and exercises that help readers apply the concepts in a hands-on way, ensuring comprehension and retention.
Who should read M Is for (Data) Monkey?
Individuals looking to improve their data analysis and manipulation skills
Professionals who want to enhance their Excel and Power BI capabilities
Data enthusiasts who are eager to learn about Power Query and its applications
Categories with M Is for (Data) Monkey
Book summaries like M Is for (Data) Monkey
People ❤️ Blinkist
Sven O.
It's highly addictive to get core insights on personally relevant topics without repetition or triviality. Added to that the apps ability to suggest kindred interests opens up a foundation of knowledge.
Thi Viet Quynh N.
Great app. Good selection of book summaries you can read or listen to while commuting. Instead of scrolling through your social media news feed, this is a much better way to spend your spare time in my opinion.
Jonathan A.
Life changing. The concept of being able to grasp a book's main point in such a short time truly opens multiple opportunities to grow every area of your life at a faster rate.
Renee D.
Great app. Addicting. Perfect for wait times, morning coffee, evening before bed. Extremely well written, thorough, easy to use.
People also liked these summaries
4.8 Stars
Average ratings on iOS and Google Play
43 Million
Downloads on all platforms
10+ years
Experience igniting personal growth
M Is for (Data) Monkey FAQs
What is the main message of M Is for (Data) Monkey?
The main message of M Is for (Data) Monkey emphasizes mastering data analysis skills using Microsoft Excel efficiently.
How long does it take to read M Is for (Data) Monkey?
Reading time for M Is for (Data) Monkey depends on individual pace. The Blinkist summary can be read quickly.
Is M Is for (Data) Monkey a good book? Is it worth reading?
M Is for (Data) Monkey is recommended for its practical approach to Excel data analysis, making it a valuable read.
Who is the author of M Is for (Data) Monkey?
The author of M Is for (Data) Monkey is Ken Puls.
What to read after M Is for (Data) Monkey?
If you're wondering what to read next after M Is for (Data) Monkey, here are some recommendations we suggest:
- Big Data by Viktor Mayer-Schönberger and Kenneth Cukier
- Physics of the Future by Michio Kaku
- On Intelligence by Jeff Hawkins and Sandra Blakeslee
- Brave New War by John Robb
- Abundance# by Peter H. Diamandis and Steven Kotler
- The Signal and the Noise by Nate Silver
- You Are Not a Gadget by Jaron Lanier
- The Future of the Mind by Michio Kaku
- The Second Machine Age by Erik Brynjolfsson and Andrew McAfee
- Out of Control by Kevin Kelly