Название: The Ultimate Power Query Cookbook for Power BI and Excel: Leveraging Power Query for collecting, combining and transforming your data
Автор: Dominick Raimato
Издательство: BPB Publications
Год: 2024
Страниц: 398
Язык: английский
Формат: epub (true)
Размер: 19.5 MB

"The Ultimate Power Query Cookbook for Power BI and Excel" serves up easy-to-follow recipes that transform data into meaningful insights. You will learn to clean messy files, combine datasets, and even use AI magic to Power BI and Excel.

This book will walk you through the basics of getting connected to data with Power Query. You will understand how to ingest data from files, folders, databases, websites, APIs, and other third party sources. Once connected, you will learn how to transform the data so it is ready for your use. We will clean up columns, filter, replace, extract, and classify data in Power Query to meet your needs. The book offers over 100 practical recipes, ensuring you understand each step with clear explanations and examples. Lastly, we will go over advanced techniques to help optimize and simplify your transformations allowing fast refreshes all while helping you manage them in the future.

This book will help you know how to apply these techniques and recipes to your data all while understanding the implications of making certain decisions. This will enable you to have better conversations with other data professionals who are providing data for your use.

Data has infiltrated every aspect of our lives. The expectation of querying data and finding meaningful insights is now going beyond traditional business intelligence teams and becoming a required skill for analysts across the entire organization. While there are many tools out there that can be used to query and transform data, Power Query has proven to be a leader in this space.

This book is an all-inclusive guide to querying and transforming data with Power Query. Starting with accessing data from diverse sources, we walk through how data is transformed, cleansed, merged, appended, and manipulated to turn raw data into a meaningful data model to obtain insights.

Throughout this book, you will learn different ways transform your data to support efficient refreshes while preventing your model from experiencing bloat. We will explore best practices and use cases to help you understand how to best apply these concepts in your real-life scenarios.

This book is intended for anyone who is interested in data analytics or needs to manipulate data for their use. While the primary audience is for data analysts and business intelligence developers who build models for reports and insights, anyone who has a need to transform data will find value with the contents of this book. Whether you are a novice or expert, you will find value from the contents of this book.