東華大學圖書館 |

語系: 繁體中文

說明(常見問題)

回圖書館首頁

手機版館藏查詢

登入

回首頁

切換: 標籤 | MARC模式 | ISBD

FindBook

Google Book

Amazon

博客來

The ultimate guide to functions in Power Query = turn raw data into actionable insights /

紀錄類型:	書目-電子資源 : Monograph/item
正題名/作者:	The ultimate guide to functions in Power Query/ by Omid Motamedisedeh.
其他題名:	turn raw data into actionable insights /
作者:	Motamedisedeh, Omid.
出版者:	Berkeley, CA :Apress : : 2024.,
面頁冊數:	xxv, 392 p. :ill., digital ;24 cm.
內容註:	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.
Contained By:	Springer Nature eBook
標題:	Database management - Computer programs. -
電子資源:	https://doi.org/10.1007/978-1-4842-9754-4
ISBN:	9781484297544

The ultimate guide to functions in Power Query = turn raw data into actionable insights /
Motamedisedeh, Omid.

The ultimate guide to functions in Power Queryturn raw data into actionable insights /[electronic resource] :by Omid Motamedisedeh. - Berkeley, CA :Apress :2024. - xxv, 392 p. :ill., digital ;24 cm.

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.

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 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 able to 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.

ISBN: 9781484297544

Standard No.: 10.1007/978-1-4842-9754-4doiSubjects--Uniform Titles:

Power Query (Computer file)
Subjects--Topical Terms:

686272
Database management
--Computer programs.

LC Class. No.: QA76.9.D3

Dewey Class. No.: 005.7565

The ultimate guide to functions in Power Query = turn raw data into actionable insights /
LDR:02979nmm a2200325 a 4500 001 2368298
003 DE-He213
005 20231201084940.0
006 m d
007 cr nn 008maaau
008 241127s2024 cau s 0 eng d
020 $a 9781484297544 $q (electronic bk.)
020 $a 9781484297537 $q (paper)
024 7 $a 10.1007/978-1-4842-9754-4 $2 doi
035 $a 978-1-4842-9754-4
040 $a GP $c GP
041 0 $a eng
050 4 $a QA76.9.D3
072 7 $a UN $2 bicssc
072 7 $a COM069000 $2 bisacsh
072 7 $a UN $2 thema
082 0 4 $a 005.7565 $2 23
090 $a QA76.9.D3 $b M917 2024
100 1 $a Motamedisedeh, Omid. $3 3712154
245 1 4 $a The ultimate guide to functions in Power Query $h [electronic resource] : $b turn raw data into actionable insights / $c by Omid Motamedisedeh.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2024.
300 $a xxv, 392 p. : $b ill., digital ; $c 24 cm.
505 0 $a 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.
520 $a 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 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 able to 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.
630 0 0 $a Power Query (Computer file) $3 3712155
650 0 $a Database management $x Computer programs. $3 686272
650 1 4 $a Database Management System. $3 3591759
650 2 4 $a Database Management. $3 891010
650 2 4 $a Data Science. $3 3538937
650 2 4 $a Data Structures and Information Theory. $3 3382368
710 2 $a SpringerLink (Online service) $3 836513
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/978-1-4842-9754-4
950 $a Professional and Applied Computing (SpringerNature-12059)