Muutke küpsiste eelistusi

E-raamat: Ultimate Guide to Functions in Power Query: Turn Raw Data into Actionable Insights

  • Formaat: EPUB+DRM
  • Ilmumisaeg: 01-Dec-2023
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781484297544
Teised raamatud teemal:
  • Formaat - EPUB+DRM
  • Hind: 49,39 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Ultimate Guide to Functions in Power Query: Turn Raw Data into Actionable InsightsSuurem pilt
  • Formaat: EPUB+DRM
  • Ilmumisaeg: 01-Dec-2023
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781484297544
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

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. Youll 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 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.

Chapter 1: Introduction to Power Query.
Chapter 2: Data Types.
Chapter 3: Number Functions.
Chapter 4: Text Functions.
Chapter 5: Date and Time Functions.
Chapter 6: List Functions.
Chapter 7: Record Functions.
Chapter 8: Table Functions.
Chapter 9: Extracting from Data Sources.
Chapter 10: Other Functions.

Omid Motamedisedeh is a freelance data and business intelligence analyst with a PhD in Industrial Engineering. Hes 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.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97814842975446e.html