000 03932nam a22005415i 4500
001 978-1-4842-9754-4
003 DE-He213
005 20251030110845.0
007 cr nn 008mamaa
008 231201s2024 xxu| s |||| 0|eng d
020 _a9781484297544
_9978-1-4842-9754-4
024 7 _a10.1007/978-1-4842-9754-4
_2doi
050 4 _aQA76.9.D3
072 7 _aUN
_2bicssc
072 7 _aCOM021000
_2bisacsh
072 7 _aUN
_2thema
100 1 _aMotamedisedeh, Omid.
_eauthor.
_4aut
_4http://id.loc.gov/vocabulary/relators/aut
_967803
245 1 4 _aThe Ultimate Guide to Functions in Power Query
_h[electronic resource] :
_bTurn Raw Data into Actionable Insights /
_cby Omid Motamedisedeh.
250 _a1st ed. 2024.
264 1 _aBerkeley, CA :
_bApress :
_bImprint: Apress,
_c2024.
300 _aXXV, 392 p. 80 illus.
_bonline resource.
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bc
_2rdamedia
338 _aonline resource
_bcr
_2rdacarrier
347 _atext file
_bPDF
_2rda
505 0 _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.
520 _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.
650 0 _aDatabase management.
_960571
650 0 _aArtificial intelligence
_xData processing.
650 0 _aData structures (Computer science).
_966708
650 0 _aInformation theory.
_957783
650 1 4 _aDatabase Management System.
650 2 4 _aDatabase Management.
_960571
650 2 4 _aData Science.
650 2 4 _aData Structures and Information Theory.
_966709
710 2 _aSpringerLink (Online service)
773 0 _tSpringer Nature eBook
776 0 8 _iPrinted edition:
_z9781484297537
776 0 8 _iPrinted edition:
_z9781484297551
776 0 8 _iPrinted edition:
_z9798868810848
856 4 0 _uhttps://doi.org/10.1007/978-1-4842-9754-4
912 _aZDB-2-CWD
912 _aZDB-2-SXPC
999 _c56707
_d56707