The Ultimate Guide to the M Language in Excel Power Query: M Is for (Data) Monkey Free Epub Book
Download free epub books M Is for (Data) Monkey:
Are you an Excel or Power BI user who wants to learn how to clean, transform, and automate your data using Power Query and M language? If so, you might be interested in downloading a free epub book called M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query by Ken Puls and Miguel Escobar. In this article, we'll tell you what this book is about, why you should download it, how to download it, how to read it, and what else you can learn from it. Let's get started!
Download free epub books M Is for (Data) Monkey:
What is M Is for (Data) Monkey?
M Is for (Data) Monkey is a book that teaches you how to use Power Query and M language to get and transform data in Excel and Power BI. Power Query is a tool that allows you to connect to various data sources, such as files, folders, databases, web pages, and more, and apply different transformations to the data, such as filtering, sorting, merging, pivoting, unpivoting, grouping, aggregating, and more. M language is the programming language behind Power Query that lets you write custom formulas and functions to manipulate the data even further.
The book is written by Ken Puls and Miguel Escobar, two experts and trainers in Excel and Power BI who have years of experience in working with data. They are also the founders of Skillwave Training, an online platform that offers courses and resources on Power Query, Power BI, DAX, and more. The book is based on their popular online course called Power Query Academy, which has helped thousands of students master Power Query and M language.
The book covers the following topics:
How to import data from various sources using Power Query
How to override Power Query defaults and customize your queries
How to append, merge, and join tables and queries using Power Query
How to define data types and format your data using Power Query
How to import web data and data from Exchange using Power Query
How to group and summarize data using Power Query
How to transpose and unpivot complex data using Power Query
How to automate refreshing your queries using Power Query
How to write Power Query formulas and use conditional logic using M language
How to understand the M language syntax and structure
How to create custom functions using M language
How to use dynamic parameters and calendar tables using M language
How to organize your queries and document your code using M language
The book is designed for beginners who have no prior knowledge of Power Query or M language, as well as intermediate users who want to improve their skills and learn some advanced techniques. The book is full of practical examples, exercises, tips, and best practices that will help you master Power Query and M language in no time.
Why download free epub books?
An epub book is a digital book format that can be read on various devices and applications. Epub stands for electronic publication, and it is one of the most popular and widely supported formats for ebooks. Epub books have some advantages over other formats, such as PDF or MOBI, such as:
Epub books are flexible and adaptable. They can adjust to different screen sizes, orientations, fonts, colors, and layouts depending on the device and application you use. This makes them more user-friendly and accessible than other formats that have fixed layouts.
Epub books are interactive and dynamic. They can contain hyperlinks, images, audio, video, animations, tables, charts, graphs, and other multimedia elements that enhance the reading experience. They can also support features such as bookmarks, annotations, highlights, search functions, dictionaries, translations, text-to-speech, and more.
Epub books are lightweight and portable. They have smaller file sizes than other formats that can take up more space on your device or slow down your performance. They can also be easily transferred between devices or shared with others via email or cloud services.
Downloading free epub books is a convenient and cost-effective way of accessing a wide range of books online. You can find free epub books on various websites that offer public domain books (books that are no longer under copyright protection), open source books (books that are licensed under creative commons or similar licenses), or promotional books (books that are offered for free by authors or publishers for a limited time or for a specific purpose). Downloading free epub books can help you:
Save money on buying physical or digital books that can be expensive or hard to find.
Save time on searching for books in libraries or bookstores that may not have the books you want or need.
Save space on storing books in your home or office that can clutter your environment or collect dust.
Expand your knowledge and skills by reading books on various topics and genres that interest you or relate to your work or studies.
How to download free epub books M Is for (Data) Monkey?
Now that you know what M Is for (Data) Monkey is and why you should download it as an epub book, you might be wondering how to do it. There are many websites that offer free epub books, but not all of them are reliable, secure, or legal. Some websites may have low-quality or outdated books, some may have malware or viruses that can harm your device or steal your data, and some may violate the authors' or publishers' rights and copyrights.
To help you avoid these problems, we have compiled a list of some of the best and safest websites where you can download free epub books M Is for (Data) Monkey. We have also compared them based on some criteria, such as quality, reliability, and security. Here is a table that summarizes the pros and cons of each website:
Website Pros Cons ------- ---- ---- PDFRoom - High-quality and updated books- Easy to use and navigate- No registration or login required- No ads or pop-ups - Limited selection of books- No direct download link for epub format- Need to convert PDF to epub using another tool Amazon - Large and diverse selection of books- Trusted and reputable website- Compatible with Kindle devices and apps- Offers customer reviews and ratings - Need to register and login with an Amazon account- Need to pay for some books or subscribe to Kindle Unlimited- Need to use a VPN or proxy to access some books from different regions Epub.pub - Dedicated website for epub books- Offers various genres and categories- Supports user uploads and requests- Allows online reading and downloading - Need to register and login with an email or social media account- Need to verify your email address before downloading- May contain some pirated or unauthorized books Library Genesis - Huge and comprehensive collection of books- Offers multiple formats and languages- Provides multiple mirrors and links for downloading- No registration or login required - Illegal and blocked in some countries- May have broken or expired links- May have malware or viruses As you can see, each website has its own advantages and disadvantages. You can choose the one that suits your needs and preferences the best. However, we recommend that you always check the legality and legitimacy of the website before downloading any book, and always scan the downloaded file for any potential threats. We also advise that you respect the authors' and publishers' rights and support them by buying their books if you can afford it.
How to read free epub books M Is for (Data) Monkey?
Once you have downloaded free epub books M Is for (Data) Monkey, you might be wondering how to read them. Epub books can be read on various devices and applications, such as computers, smartphones, tablets, e-readers, web browsers, and more. However, not all devices and applications support epub format natively, so you may need to install some additional software or plugins to open and read epub books.
Here is a brief tutorial on how to open and read epub books on different devices and applications:
On computers: You can use a desktop application such as Calibre, Adobe Digital Editions, Sumatra PDF, or FBReader to read epub books on your Windows, Mac, or Linux computer. You can also use a web browser extension such as EPUBReader for Firefox or Readium for Chrome to read epub books online.
On smartphones and tablets: You can use a mobile application such as Google Play Books, Apple Books, Aldiko, Moon+ Reader, or Lithium to read epub books on your Android or iOS device. You can also use a web browser app such as Safari or Chrome to read epub books online.
On e-readers: You can use an e-reader device such as Kindle, Kobo, Nook, or Sony Reader to read epub books. However, some e-readers may not support epub format natively, so you may need to convert epub files to another format such as MOBI or PDF using a tool such as Calibre or Online-Convert before transferring them to your e-reader.
Some tips and tricks on how to enhance your reading experience with epub books are:
Adjust the font size, color, brightness, and orientation according to your preference and comfort.
Use the table of contents, bookmarks, annotations, highlights, search functions, dictionaries, translations, text-to-speech, and other features to navigate and interact with the book.
Sync your reading progress and settings across different devices and applications using cloud services or accounts.
Share your thoughts and opinions on the book with other readers using social media or online forums.
What else can you learn from free epub books M Is for (Data) Monkey?
Downloading and reading free epub books M Is for (Data) Monkey is a great way to learn how to use Power Query and M language to get and transform data in Excel and Power BI. However, that's not all you can learn from this book. Here are some of the key takeaways from the book that you can apply to your own data projects:
Power Query and M language are powerful and versatile tools that can help you automate and simplify your data preparation tasks.
Power Query and M language can handle various types and sources of data, such as text, numbers, dates, times, tables, lists, records, functions, and more.
Power Query and M language can perform various transformations on the data, such as filtering, sorting, merging, pivoting, unpivoting, grouping, aggregating, transposing, formatting, and more.
Power Query and M language can create custom formulas and functions to manipulate the data even further using conditional logic, parameters, variables, loops, recursion, and more.
Power Query and M language can organize and document your queries and code using comments, steps, groups, folders, names, descriptions, and more.
If you want to learn more about Power Query and M language after reading this book, you can also check out some of these resources:
The official Microsoft documentation on Power Query and M language: https://docs.microsoft.com/en-us/power-query/
The official Microsoft blog on Power Query and M language: https://techcommunity.microsoft.com/t5/power-query/bd-p/PowerQuery
The official Microsoft forum on Power Query and M language: https://social.technet.microsoft.com/Forums/en-US/home?forum=powerquery
The Skillwave Training website by Ken Puls and Miguel Escobar: https://www.skillwave.training/
The Excelguru website by Ken Puls: https://www.excelguru.ca/
The Powered Solutions website by Miguel Escobar: https://www.poweredsolutions.co/
Conclusion
In this article, we have shown you how to download free epub books M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query by Ken Puls and Miguel Escobar. We have explained what this book is about, why you should download it as an epub book, how to download it from various sources, how to read it on different devices and applications, and what else you can learn from it.
We hope that you have enjoyed reading this article and that you have learned something new and useful from it. We also hope that you have downloaded and read free epub books M Is for (Data) Monkey and that you have applied what you learned from it to your own data projects. We believe that Power Query and M language are essential skills for any Excel or Power BI user who wants to work with data more efficiently and effectively.
Thank you for reading this article. If you have any questions or feedback about it or about free epub books M Is for (Data) Monkey, please feel free to share them with us in the comments section below. We would love to hear from you!
FAQs
Here are some frequently asked questions about free epub books M Is for (Data) Monkey:
Q1: What is Power Query?
A1: Power Query is a tool that allows you to connect to various data sources, such as files, folders, databases, web pages, and more, and apply different transformations to the data, such as filtering, sorting, merging, pivoting, unpivoting, grouping, aggregating, and more OK, I'll continue writing the FAQs based on the outline I created. Here are the rest of the FAQs: Q2: What is M language?
A2: M language is the programming language behind Power Query that lets you write custom formulas and functions to manipulate the data even further. M language has a syntax and structure that is similar to other functional programming languages, such as F# or Haskell. M language can handle various types and sources of data, such as text, numbers, dates, times, tables, lists, records, functions, and more.
Q3: What is Power BI?
A3: Power BI is a business intelligence platform that allows you to analyze, visualize, and share insights from your data. Power BI consists of various components, such as Power BI Desktop, Power BI Service, Power BI Mobile, Power BI Report Server, and more. Power BI integrates with Power Query and M language to help you get and transform data from various sources. Power BI also integrates with Power Pivot and DAX to help you model and calculate data. Power BI also integrates with Power View and Power Map to help you create interactive reports and dashboards.
Q4: Where can I buy a physical copy of M Is for (Data) Monkey?
A4: If you prefer to read a physical copy of M Is for (Data) Monkey instead of a free epub book, you can buy it from various online or offline retailers, such as Amazon, Barnes & Noble, Book Depository, or your local bookstore. The price may vary depending on the retailer and the availability. The ISBN of the book is 978-1615470341.
Q5: How can I contact the authors of M Is for (Data) Monkey?
A5: If you want to contact the authors of M Is for (Data) Monkey to ask them questions, give them feedback, or thank them for their work, you can do so through their websites or social media accounts. Here are some ways to reach them:
Ken Puls: https://www.excelguru.ca/contact-us/, https://twitter.com/ExcelguruKenPul, https://www.linkedin.com/in/kenpuls/
Miguel Escobar: https://www.poweredsolutions.co/contact-us/, https://twitter.com/escobarmiguel, https://www.linkedin.com/in/miguelescobar/
71b2f0854b