The Ultimate Power Query Cookbook for Power BI and Excel

The Ultimate Power Query Cookbook for Power BI and Excel
Author :
Publisher : BPB Publications
Total Pages : 522
Release :
ISBN-10 : 9789355517395
ISBN-13 : 9355517394
Rating : 4/5 (394 Downloads)

Book Synopsis The Ultimate Power Query Cookbook for Power BI and Excel by : Dominick Raimato

Download or read book The Ultimate Power Query Cookbook for Power BI and Excel written by Dominick Raimato and published by BPB Publications. This book was released on 2024-01-22 with total page 522 pages. Available in PDF, EPUB and Kindle. Book excerpt: Novice or expert, learn to simplify and optimize data transformations KEY FEATURES ● Practical approaches to cleansing, connecting and transforming data in Power Query. ● Real-life examples that readers can apply to their own work. ● Master Power Query for Excel and Power BI with step-by-step recipes. DESCRIPTION “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. WHAT YOU WILL LEARN ● Learn to connect to files, databases, and third-party services. ● Manage data types and formats to optimize storage. ● Transform, create, and manipulate queries. ● Combine, merge, filter, and cleanse queries. ● Integrate artificial intelligence to accelerate insights. ● Perform complex and scalable transformations. WHO THIS BOOK IS FOR Novice or expert, this book is designed for all Excel users, data analysts, Power BI power users, business professionals and data enthusiasts to get the most out of your data solutions when transforming your data in Power Query. TABLE OF CONTENTS 1. Introduction to Power Query 2. Connect to File-Based Data Sources 3. Connect to Web-Based Data Sources 4. Connect to Database Sources 5. Connect to Third-Party Data Sources 6. Managing Data Types 7. Transforming Columns 8. Cleansing Columns 9. Creating New Columns 10. Combining and Manipulating Queries 11. Using Python, R, and AI 12. Indexing 13. Parameters 14. Functions 15. Advanced Web Connections 16. Manipulating Supporting Queries


The Ultimate Power Query Cookbook for Power BI and Excel Related Books

The Ultimate Power Query Cookbook for Power BI and Excel
Language: en
Pages: 522
Authors: Dominick Raimato
Categories: Computers
Type: BOOK - Published: 2024-01-22 - Publisher: BPB Publications

DOWNLOAD EBOOK

Novice or expert, learn to simplify and optimize data transformations KEY FEATURES ● Practical approaches to cleansing, connecting and transforming data in Po
Power Query Cookbook
Language: en
Pages: 412
Authors: Andrea Janicijevic
Categories: Computers
Type: BOOK - Published: 2021-10-15 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

Leverage your source data from hundreds of different connections, perform millions of different transformations, and easily manage highly complex data lifecycle
Introducing Microsoft Power BI
Language: en
Pages: 453
Authors: Alberto Ferrari
Categories: Computers
Type: BOOK - Published: 2016-07-07 - Publisher: Microsoft Press

DOWNLOAD EBOOK

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Intr
Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
Language: en
Pages: 874
Authors: Gil Raviv
Categories: Computers
Type: BOOK - Published: 2018-10-08 - Publisher: Microsoft Press

DOWNLOAD EBOOK

Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query
Mastering Microsoft Power BI
Language: en
Pages: 632
Authors: Brett Powell
Categories: Computers
Type: BOOK - Published: 2018-03-29 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

Design, create and manage robust Power BI solutions to gain meaningful business insights Key Features Master all the dashboarding and reporting features of Micr