LEADER 04032nam  22006735  450 
001 9910767566303321
005 20250807124836.0
010   $a9781484297544
010   $a1484297547
024 7 $a10.1007/978-1-4842-9754-4
035   $a(MiAaPQ)EBC30983281
035   $a(Au-PeEL)EBL30983281
035   $a(DE-He213)978-1-4842-9754-4
035   $a(OCoLC)1413232148
035   $a(OCoLC-P)1413232148
035   $a(CaSebORM)9781484297544
035   $a(CKB)29181439100041
035   $a(Perlego)4515837
035   $a(EXLCZ)9929181439100041
100   $a20231201d2024      u|         0
101 0 $aeng
135   $aurcnu||||||||
181   $ctxt$2rdacontent
182   $cc$2rdamedia
183   $acr$2rdacarrier
200 14$aThe Ultimate Guide to Functions in Power Query $eTurn Raw Data into Actionable Insights /$fby Omid Motamedisedeh
205   $a1st ed. 2024.
210  1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2024.
215   $a1 online resource (410 pages)
300   $aIncludes index.
311 08$a9781484297537 
311 08$a1484297539 
327   $aChapter 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.
330   $aThis 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 learn how to leverage power functions to process and transform large datasets from various sources and discover 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. You will: 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 Deploy 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 Leverage real-world examples and exercises to hone your skills and gain practical experience with the tool.
606   $aDatabase management
606   $aArtificial intelligence$xData processing
606   $aData structures (Computer science)
606   $aInformation theory
606   $aDatabase Management System
606   $aDatabase Management
606   $aData Science
606   $aData Structures and Information Theory
615  0$aDatabase management.
615  0$aArtificial intelligence$xData processing.
615  0$aData structures (Computer science)
615  0$aInformation theory.
615 14$aDatabase Management System.
615 24$aDatabase Management.
615 24$aData Science.
615 24$aData Structures and Information Theory.
676   $a005.54
700   $aMotamedisedeh$b Omid$01453564
801  0$bMiAaPQ
801  1$bMiAaPQ
801  2$bMiAaPQ
906   $aBOOK
912   $a9910767566303321
996   $aThe Ultimate Guide to Functions in Power Query$93656205
997   $aUNINA