Power Query Cookbook

Power Query Cookbook
Author :
Publisher : Packt Publishing Ltd
Total Pages : 412
Release :
ISBN-10 : 9781800567931
ISBN-13 : 1800567936
Rating : 4/5 (936 Downloads)

Book Synopsis Power Query Cookbook by : Andrea Janicijevic

Download or read book Power Query Cookbook written by Andrea Janicijevic and published by Packt Publishing Ltd. This book was released on 2021-10-15 with total page 412 pages. Available in PDF, EPUB and Kindle. Book excerpt: Leverage your source data from hundreds of different connections, perform millions of different transformations, and easily manage highly complex data lifecycles with Power Query Key FeaturesCollect, combine, and transform data using Power Query's data connectivity and data preparation featuresOvercome the problems faced while accessing data from multiple sources and reshape it to meet your business requirementsExplore how the M language can be used to write your own customized solutionsBook Description Power Query is a data preparation tool that enables data engineers and business users to connect, reshape, enrich, and transform their data to facilitate relevant business insights and analysis. With Power Query's wide range of features, you can perform no-code transformations and complex M code functions at the same time to get the most out of your data. This Power Query book will help you to connect to data sources, achieve intuitive transformations, and get to grips with preparation practices. Starting with a general overview of Power Query and what it can do, the book advances to cover more complex topics such as M code and performance optimization. You'll learn how to extend these capabilities by gradually stepping away from the Power Query GUI and into the M programming language. Additionally, the book also shows you how to use Power Query Online within Power BI Dataflows. By the end of the book, you'll be able to leverage your source data, understand your data better, and enrich it with a full stack of no-code and custom features that you'll learn to design by yourself for your business requirements. What you will learnUnderstand how to use Power Query to connect and explore dataExplore ways to reshape and enrich dataDiscover the potential of Power Query across the Microsoft platformBuild complex and custom transformationsUse M code to write new queries against data sourcesUse the Power Query Online tool within Power BI DataflowsImplement best practices such as reusing dataflows, optimizing expanding table operations, and field mappingWho this book is for This book is for data analysts, BI developers, data engineers, and anyone looking for a desk reference guide to learn how Power Query can be used with different Microsoft products to handle data of varying complexity. Beginner-level knowledge of Power BI and the M Language will help you to get the best out of this book.


Power Query Cookbook Related Books

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
Power Query Cookbook
Language: en
Pages: 412
Authors: Andrea Janicijevic
Categories: Database design
Type: BOOK - Published: 2021-10-15 - Publisher:

DOWNLOAD EBOOK

Leverage your source data from hundreds of different connections, perform millions of different transformations, and easily manage highly complex data lifecycle
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
M Is for (Data) Monkey
Language: en
Pages: 298
Authors: Ken Puls
Categories: Computers
Type: BOOK - Published: 2015-06-01 - Publisher: Tickling Keys, Inc.

DOWNLOAD EBOOK

Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and "M" is the name of the programming language created by it. As m
Microsoft Power BI Cookbook
Language: en
Pages: 786
Authors: Brett Powell
Categories: Computers
Type: BOOK - Published: 2017-09-27 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

Publisher's note: This edition from 2017 is outdated and does not make use of the most recent Power BI updates. A new third edition, updated to the latest relea