國立虎尾科技大學 |

Beginning DAX with Power BI = The SQL Pro’s Guide to Better Business Intelligence /

紀錄類型:	書目-語言資料,印刷品 : Monograph/item
正題名/作者:	Beginning DAX with Power BI/ by Philip Seamark.
其他題名:	The SQL Pro’s Guide to Better Business Intelligence /
作者:	Seamark, Philip.
面頁冊數:	XVII, 264 p. 84 illus.online resource. :
Contained By:	Springer Nature eBook
標題:	Microsoft software. -
電子資源:	https://doi.org/10.1007/978-1-4842-3477-8
ISBN:	9781484234778

Beginning DAX with Power BI = The SQL Pro’s Guide to Better Business Intelligence /
Seamark, Philip.

Beginning DAX with Power BIThe SQL Pro’s Guide to Better Business Intelligence /[electronic resource] :by Philip Seamark. - 1st ed. 2018. - XVII, 264 p. 84 illus.online resource.

Chapter 1: Introduction to DAX -- Chapter 2: Variables -- Chapter 3: Context -- Chapter 4: Summarizing and Aggregating -- Chapter 5: Joins -- Chapter 6: Filtering -- Chapter 7: Dates -- Chapter 8: Debugging and Optimizing -- Chapter 9: Practical DAX.

Attention all SQL Pros, DAX is not just for writing Excel-based formulas! Get hands-on learning and expert advice on how to use the vast capabilities of the DAX language to solve common data modeling challenges. Beginning DAX with Power BI teaches key concepts such as mapping techniques from SQL to DAX, filtering, grouping, joining, pivoting, and using temporary tables, all aimed at the SQL professional. Join author Philip Seamark as he guides you on a journey through typical business data transformation scenarios and challenges, and teaches you, step-by-step, how to resolve challenges using DAX. Tips, tricks, and shortcuts are included and explained, along with examples of the SQL equivalent, in order to accelerate learning. Examples in the book range from beginner to advanced, with plenty of detailed explanation when walking through each scenario. What You’ll Learn: Turbocharge your Power BI model by adding advanced DAX programming techniques Know when to use calculated measures versus calculated columns Generate new tables on the fly from existing data Optimize, monitor, and tune Power BI to improve performance of your models Discover new ideas, tricks, and time-saving techniques for better models This book is for business intelligence developers, business analysts, or any SQL user who wants to use Power BI as a reporting tool. A solid understanding of SQL is recommended, as examples throughout the book include the DAX equivalents to SQL problem/solution scenarios. Philip Seamark,a Senior BI architect with Trade Me and a Microsoft Data Platform MVP with more than 25 years of commercial experience delivering business applications across multiple technologies. He is an experienced database and BI professional with a deep understanding of the Microsoft stack and extensive knowledge of data warehouse (DW) methodologies and enterprise data modeling. Philip writes for the Power BI community site, and is a speaker at many industry events, Microsoft Ignite, Data Insights, Power BI User Groups, SQL Saturdays, and more.

ISBN: 9781484234778

Standard No.: 10.1007/978-1-4842-3477-8doiSubjects--Topical Terms:

1253736
Microsoft software.

LC Class. No.: QA76.76.M52

Dewey Class. No.: 004.165

Beginning DAX with Power BI = The SQL Pro’s Guide to Better Business Intelligence /
LDR:03671nam a22003975i 4500 001 992170
003 DE-He213
005 20200630120605.0
007 cr nn 008mamaa
008 201225s2018 xxu| s |||| 0|eng d
020 $a 9781484234778 $9 978-1-4842-3477-8
024 7 $a 10.1007/978-1-4842-3477-8 $2 doi
035 $a 978-1-4842-3477-8
050 4 $a QA76.76.M52
072 7 $a UMP $2 bicssc
072 7 $a COM051380 $2 bisacsh
072 7 $a UMP $2 thema
082 0 4 $a 004.165 $2 23
100 1 $a Seamark, Philip. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1203123
245 1 0 $a Beginning DAX with Power BI $h [electronic resource] : $b The SQL Pro’s Guide to Better Business Intelligence / $c by Philip Seamark.
250 $a 1st ed. 2018.
264 1 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2018.
300 $a XVII, 264 p. 84 illus. $b online resource.
336 $a text $b txt $2 rdacontent
337 $a computer $b c $2 rdamedia
338 $a online resource $b cr $2 rdacarrier
347 $a text file $b PDF $2 rda
505 0 $a Chapter 1: Introduction to DAX -- Chapter 2: Variables -- Chapter 3: Context -- Chapter 4: Summarizing and Aggregating -- Chapter 5: Joins -- Chapter 6: Filtering -- Chapter 7: Dates -- Chapter 8: Debugging and Optimizing -- Chapter 9: Practical DAX.
520 $a Attention all SQL Pros, DAX is not just for writing Excel-based formulas! Get hands-on learning and expert advice on how to use the vast capabilities of the DAX language to solve common data modeling challenges. Beginning DAX with Power BI teaches key concepts such as mapping techniques from SQL to DAX, filtering, grouping, joining, pivoting, and using temporary tables, all aimed at the SQL professional. Join author Philip Seamark as he guides you on a journey through typical business data transformation scenarios and challenges, and teaches you, step-by-step, how to resolve challenges using DAX. Tips, tricks, and shortcuts are included and explained, along with examples of the SQL equivalent, in order to accelerate learning. Examples in the book range from beginner to advanced, with plenty of detailed explanation when walking through each scenario. What You’ll Learn: Turbocharge your Power BI model by adding advanced DAX programming techniques Know when to use calculated measures versus calculated columns Generate new tables on the fly from existing data Optimize, monitor, and tune Power BI to improve performance of your models Discover new ideas, tricks, and time-saving techniques for better models This book is for business intelligence developers, business analysts, or any SQL user who wants to use Power BI as a reporting tool. A solid understanding of SQL is recommended, as examples throughout the book include the DAX equivalents to SQL problem/solution scenarios. Philip Seamark,a Senior BI architect with Trade Me and a Microsoft Data Platform MVP with more than 25 years of commercial experience delivering business applications across multiple technologies. He is an experienced database and BI professional with a deep understanding of the Microsoft stack and extensive knowledge of data warehouse (DW) methodologies and enterprise data modeling. Philip writes for the Power BI community site, and is a speaker at many industry events, Microsoft Ignite, Data Insights, Power BI User Groups, SQL Saturdays, and more.
650 0 $a Microsoft software. $3 1253736
650 0 $a Microsoft .NET Framework. $3 565417
650 0 $a Big data. $3 981821
650 1 4 $a Microsoft and .NET. $3 1114109
650 2 4 $a Big Data/Analytics. $3 1106909
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9781484234761
776 0 8 $i Printed edition: $z 9781484234785
776 0 8 $i Printed edition: $z 9781484247877
856 4 0 $u https://doi.org/10.1007/978-1-4842-3477-8
912 $a ZDB-2-CWD
912 $a ZDB-2-SXPC
950 $a Professional and Applied Computing (SpringerNature-12059)
950 $a Professional and Applied Computing (R0) (SpringerNature-43716)