Nicht aus der Schweiz? Besuchen Sie lehmanns.de
Ultimate Guide to Functions in Power Query -  Omid Motamedisedeh

Ultimate Guide to Functions in Power Query (eBook)

Turn Raw Data into Actionable Insights
eBook Download: PDF
2023 | First Edition
XXV, 392 Seiten
Apress (Verlag)
978-1-4842-9754-4 (ISBN)
Systemvoraussetzungen
46,99 inkl. MwSt
(CHF 45,90)
Der eBook-Verkauf erfolgt durch die Lehmanns Media GmbH (Berlin) zum Preis in Euro inkl. MwSt.
  • Download sofort lieferbar
  • Zahlungsarten anzeigen

This book is a complete guide to using functions in Power Query and is designed to help users of all skill levels learn and master its various functions.

The Ultimate Guide to Functions in Power Query begins with an introduction to Power Query and an overview of the different types of functions available, along with detailed explanations of how to use each of them. You'll see how to leverage power functions to process and transform large datasets from various sources and learn advanced techniques such as creating custom functions and using conditional statements. The book also covers best practices for using functions, including tips on how to optimize query performance and troubleshoot common errors. Using practical example applications, Author Omid Motamedisedeh demonstrates how to optimize your data processing workflows, saving time and boosting productivity.

By the end of the book, readers will have a deep understanding of Power Query functions and be able to apply their knowledge to a wide range of data analysis tasks.

What You Will Learn

  • Master the fundamentals of Power Query, including how to load and transform data from various sources
  • Understand all the functions available in Power Query, including text, date/time, logical, numeric, and more
  • Use functions to transform data and perform complex calculations
  • Employ advanced techniques such as custom functions, conditional statements, and working with parameters
  • Optimize query performance, handle errors, and use the M language effectively
  • Use real-world examples and exercises to hone your skills and gain practical experience with the tool

Who This Book Is For

Anyone who wants to learn how to use functions in Power Query to transform and analyze data. This includes data analysts, business analysts, Excel users, and data scientists. Readers should have a basic understanding of Excel and data analysis concepts, but may be new to Power Query and functions.



Omid Motamedisedeh is a freelance data and business intelligence analyst with a PhD in Industrial Engineering. He's currently working towards his second PhD at Queensland University of Technology. Omid has authored six books in the field of Excel in Farsi, along with several articles in industry journals (Electric Power Systems Research, Journal of Building Engineering, Energy, Neural Computing and Applications, and more). His primary reason for writing his first book in English is the lack of a comprehensive and complete reference for Power Query functions. He decided to fill this gap by writing one himself.
This book is a complete guide to using functions in Power Query and is designed to help users of all skill levels learn and master its various functions.The Ultimate Guide to Functions in Power Query begins with an introduction to Power Query and an overview of the different types of functions available, along with detailed explanations of how to use each of them. You ll see how to leverage power functions to process and transform large datasets from various sources and learn advanced techniques such as creating custom functions and using conditional statements. The book also covers best practices for using functions, including tips on how to optimize query performance and troubleshoot common errors. Using practical example applications, Author Omid Motamedisedeh demonstrates how to optimize your data processing workflows, saving time and boosting productivity.By the end of the book, readers will have a deep understanding of Power Query functions and be ableto apply their knowledge to a wide range of data analysis tasks.What You Will LearnMaster the fundamentals of Power Query, including how to load and transform data from various sourcesUnderstand all the functions available in Power Query, including text, date/time, logical, numeric, and moreUse functions to transform data and perform complex calculationsEmploy advanced techniques such as custom functions, conditional statements, and working with parametersOptimize query performance, handle errors, and use the M language effectivelyUse real-world examples and exercises to hone your skills and gain practical experience with the toolWho This Book Is ForAnyone who wants to learn how to use functions in Power Query to transform and analyze data. This includes data analysts, business analysts, Excel users, and data scientists. Readers should have a basic understanding of Excel and data analysis concepts, but may be new to Power Query and functions.
Erscheint lt. Verlag 1.12.2023
Zusatzinfo XXV, 392 p. 80 illus.
Sprache englisch
Themenwelt Mathematik / Informatik Informatik Datenbanken
Mathematik / Informatik Informatik Netzwerke
Informatik Theorie / Studium Algorithmen
Informatik Theorie / Studium Künstliche Intelligenz / Robotik
Naturwissenschaften
Schlagworte Conditional statements in Power Query • Data Visualization • Excel Power Query • List Functions in Power Query • Power Query • Power Query advanced techniques • Power Query basics • Power Query custom functions • Power Query data analysis • Power Query functions • Power Query in Power BI • Power Query M language • Power Query transformations • Table functions in Power Query
ISBN-10 1-4842-9754-7 / 1484297547
ISBN-13 978-1-4842-9754-4 / 9781484297544
Informationen gemäß Produktsicherheitsverordnung (GPSR)
Haben Sie eine Frage zum Produkt?
PDFPDF (Wasserzeichen)
Größe: 11,5 MB

DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasser­zeichen und ist damit für Sie persona­lisiert. Bei einer missbräuch­lichen Weiter­gabe des eBooks an Dritte ist eine Rück­ver­folgung an die Quelle möglich.

Dateiformat: PDF (Portable Document Format)
Mit einem festen Seiten­layout eignet sich die PDF besonders für Fach­bücher mit Spalten, Tabellen und Abbild­ungen. Eine PDF kann auf fast allen Geräten ange­zeigt werden, ist aber für kleine Displays (Smart­phone, eReader) nur einge­schränkt geeignet.

Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.

Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.

Mehr entdecken
aus dem Bereich
Build memory-efficient cross-platform applications using .NET Core

von Trevoir Williams

eBook Download (2024)
Packt Publishing (Verlag)
CHF 29,30
Learn asynchronous programming by building working examples of …

von Carl Fredrik Samson

eBook Download (2024)
Packt Publishing Limited (Verlag)
CHF 29,30