The Leanpub 60 Day 100% Happiness Guarantee
Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms...
Data Transformation with Power Query
Self-Service ETL, Data Preparation Pipelines, and the M Language for Analysts
This book is 100% completeLast updated on 2026-07-18
Stop cleaning the same data every month. Learn how to automate data preparation with Power Query, build professional ETL pipelines, master the M language, and create refreshable, auditable workflows that prepare data for Excel, Power BI, and modern analytics.
Minimum price
$9.90
$16.00
You pay
Author earns
PDF
EPUB
About
About the Book
About This Book
Most analysts spend more time preparing data than analyzing it.
This book shows you how to change that.
Data Transformation with Power Query is the third volume of the Excel for Data Analytics & Business Intelligence Pathway and the definitive guide to building professional, refreshable, and auditable data preparation pipelines inside Microsoft Excel.
Instead of relying on repetitive copy-and-paste operations, fragile formulas, and manual data cleaning, you will learn how to automate the entire preparation process using Power Query and the M language. Every transformation becomes documented, reproducible, and reusable—turning hours of repetitive work into a single-click refresh.
Inside this book, you will learn how to:
- Connect to Excel files, CSV files, databases, folders, web data, and other data sources.
- Build professional ETL (Extract, Transform, Load) pipelines.
- Clean, profile, validate, and reshape messy data.
- Merge and append data from multiple sources.
- Master the Applied Steps architecture and the M language.
- Design parameterized, maintainable, and production-ready Power Query solutions.
- Prepare high-quality data for Power Pivot, DAX, Power BI, and enterprise analytics.
Unlike books that teach Power Query as a collection of ribbon commands, this volume teaches it as a professional data engineering discipline. The focus is not merely on using the software—it is on designing robust data preparation systems that can be trusted, audited, and maintained.
This book is ideal for:
- Data Analysts
- Business Intelligence Professionals
- Financial and Operations Analysts
- Power BI Developers
- Excel Power Users
- Business Analysts
- Anyone who works with recurring reports and messy data
Whether you are preparing data for Excel dashboards, Power BI models, SQL-based analytics, or enterprise reporting, this book will help you replace manual work with automated, repeatable analytical pipelines.
Professional analytics begins with clean data. This book teaches you how to build it.
Feedback
Author
About the Author
fru kingsly
FRU Kingsly is a data professional, analytics educator, and technology consultant specializing in data analytics, business intelligence, data engineering, and analytical communication. His work focuses on helping individuals and organizations develop the technical skills and analytical thinking required to transform raw data into trusted business insight.
Through consulting, technical training, and professional curriculum development, he has worked across areas including SQL, Power BI, data warehousing, cloud analytics, visualization, and enterprise reporting systems. His approach emphasizes that analytics is not only about tools, but also about judgment, clarity, structure, and responsible decision-making.
Data Analytics Foundations was written to provide the kind of rigorous, structured analytical education that many professionals never formally receive: one that teaches not only how to perform analysis, but how to think analytically before touching the data.
Get the free sample chapters
Click the buttons to get the free sample in PDF or EPUB, or read the sample online here
Earn $8 on a $10 Purchase, and $16 on a $20 Purchase
We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.
(Yes, some authors have already earned much more than that on Leanpub.)
In fact, authors have earned over $15 million writing, publishing and selling on Leanpub.
Learn more about writing on Leanpub
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Learn more about Leanpub's ebook formats and where to read them
Write and Publish on Leanpub
You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!
Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.
Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.