The Definitive Guide to Power Query (M): Mastering complex data transformation with Power Query

The Definitive Guide to Power Query (M): Mastering complex data transformation with Power Query

By Gregory Deckler, Rick de Groot and 1 more

$43.99$29.99

BookEllipseMar 2024Ellipse758 pagesEllipse1st Edition

eBook

$43.99$29.99

Print

$54.99

Subscription

$15.99 Monthly
Play Sample Audio
00:00 / 00:00

eBook

$43.99$29.99

Print

$54.99

Subscription

$15.99 Monthly

Key benefits

    • Get comprehensive coverage of fundamental and advanced Power Query concepts
    • Gain hands-on experience with practical examples based on real-world problems
    • Delve into the intricacies of Power Query M language for enhanced data manipulation

Book description

Data transformation is a critical step in building data models and business intelligence reports. Power Query is an invaluable tool for anyone who wants to master data transformation, and this book will equip you with the knowledge and skills to make the most of it. The Definitive Guide to Power Query (M) will help you build a solid foundation in the Power Query M language. As you progress through the chapters, you'll learn how to use that knowledge to implement advanced concepts and data transformations. This will set the stage for an uncompromisingly thorough exploration of the Power Query M Language. You'll also get to grips with optimizing performance, handling errors, and implementing efficient data processing techniques. As this is a hands-on guide, the practical examples in the chapters will help you gain the skills to apply Power Query to real-world problems and improve your data analysis capabilities. By the end of this book, you will be able to leverage all of Power Query's remarkable capabilities for data transformation.

Who is this book for?

This book is for business analysts, business intelligence professionals, and power business users working with data who want to add Power Query mastery to their resume. This book will be beneficial for anyone who wants to automate their process of data cleaning and save huge amount of time. Having some basic experience in Power Query is recommended.

What you will learn

Gain a strong understanding of Power Query fundamentals Master various functions within Power Query to perform complex data operations Acquire knowledge about values, types, and control structures in Power Query Develop proficiency in error handling techniques Learn performance optimization strategies for Power Query Apply what you’ve learned to real-world scenarios, including common troublesome patterns

What do you get with eBook? Show details

Feature iconInstant access to your Digital eBook purchase
Feature iconDownload this book in EPUB and PDF formats
Feature iconAI Assistant (beta) to help accelerate your development
Feature iconAccess this title in our online reader with advanced features
Feature iconDRM FREE - Read whenever, wherever and however you want

Product Details


Publication date :

Mar 29, 2024

Length :

758 pages

Edition :

1st Edition

Language :

English

ISBN-13 :

9781835089729

Vendor :

Microsoft

Category :

Concepts :

Product Details


Publication date :

Mar 29, 2024

Length :

758 pages

Edition :

1st Edition

Language :

English

ISBN-13 :

9781835089729

Vendor :

Microsoft

Category :

Concepts :

What do you get with eBook? Show details

Feature iconInstant access to your Digital eBook purchase
Feature iconDownload this book in EPUB and PDF formats
Feature iconAI Assistant (beta) to help accelerate your development
Feature iconAccess this title in our online reader with advanced features
Feature iconDRM FREE - Read whenever, wherever and however you want

Product Details


Publication date :

Mar 29, 2024

Length :

758 pages

Edition :

1st Edition

Language :

English

ISBN-13 :

9781835089729

Vendor :

Microsoft

Category :

Concepts :

Table of Contents

19 Chapters


Recommendations for you

Similar Content in Data

(1-1 of 10) 
Et al.Et al.
Aug 2023Ellipse230 Pages

Customer reviews


Rating distribution

RatingRatingRatingRatingRating5 (1 Ratings)

100%

0%

0%

0%

0%

Filter reviews by


Richard Martin | Apr 29, 2024
RatingRatingRatingRatingRating5

Has everything a data cleaner could ask for.

Success

Feefo Verified review


Authors (4)

(1-1 of 4) 
Greg Deckler
LinkedinGithub
Greg Deckler is Vice President of the Microsoft Practice at Fusion Alliance and has been a professional technology systems consultant for over 25 years. Internationally recognized as an expert in Power BI, Greg Deckler is a Microsoft MVP for Data Platform and a superuser within the Power BI community with over 100,000 messages read, more than 11,000 replies, over 2,300 answers, and more than 75 entries in the Quick Measures Gallery. Greg founded the Columbus Azure ML and Power BI User Group (CAMLPUG) and presents at numerous conferences and eve...
Brian Julius
LinkedinGithub
Brian describes himself as a "lifelong data geek", having spent his entire career in BI training and education, policy analysis and implementation, economic consulting, litigation support, and survey research. He has worked as a data analyst, economist/data scientist, and in multiple executive positions leading data-related teams and projects. Since 2019, he has focused on Power BI, including serving as Project Manager on his agency's first large-scale implementation.
Rick de Groot
LinkedinGithub
Rick de Groot was born in the Netherlands and has been working in BI for more than 14 years. He went freelance in 2016 and now works as an independent Power BI consultant. On his mission to make Power BI more accessible, he started two blogs: BI Gorilla and PowerQuery. how, and a YouTube channel sharing Power Query and Power BI content. His commitment to offering free content through multiple platforms has led him to earning the Microsoft Data Platform MVP award for two consecutive years.
Melissa de Korte
Linkedin
Melissa de Korte’s approach to facing challenges is fueled by relentless curiosity. She is a dedicated community member and content creator. Her portfolio includes blogs, tutorials, courses, and webinars, that make Power Query M more accessible and useful for all. Behind her professional persona lies a genuine dedication to empowering others through education and knowledge sharing, and a desire to encourage professionals to embrace the potential of Power Query, M.

Get free access to Packt library with over 7500+ books and video courses for 7 days!

FAQs


Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

  • You may make copies of your eBook for your own use onto any machine
  • You may not pass copies of the eBook on to anyone else

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

  1. Register on our website using your email address and the password.
  2. Search for the title by name or ISBN using the search option.
  3. Select the title you want to purchase.
  4. Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title. 
  5. Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)

  • If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
  • To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
  • To view your account details or to download a new copy of the book go to www.packtpub.com/account
  • To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

  • You can get the information you need immediately
  • You can easily take them with you on a laptop
  • You can download them an unlimited number of times
  • You can print them out
  • They are copy-paste enabled
  • They are searchable
  • There is no password protection
  • They are lower price than print
  • They save resources and space

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.