Coverart for item
The Resource Beginning DAX with Power BI : the SQL pro's guide to better business intelligence, Philip Seamark

Beginning DAX with Power BI : the SQL pro's guide to better business intelligence, Philip Seamark

Label
Beginning DAX with Power BI : the SQL pro's guide to better business intelligence
Title
Beginning DAX with Power BI
Title remainder
the SQL pro's guide to better business intelligence
Statement of responsibility
Philip Seamark
Creator
Author
Subject
Language
eng
Summary
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
Member of
Cataloging source
N$T
http://library.link/vocab/creatorName
Seamark, Philip
Dewey number
005.74
Index
index present
LC call number
QA76.7
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/subjectName
  • Query languages (Computer science)
  • Business
  • Computer Science
  • Microsoft and .NET
  • Big Data/Analytics
Label
Beginning DAX with Power BI : the SQL pro's guide to better business intelligence, Philip Seamark
Instantiates
Publication
Distribution
Copyright
Note
Includes index
Antecedent source
unknown
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
txt
Content type MARC source
rdacontent
Contents
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
Control code
SPR1030303471
Dimensions
unknown
Extent
1 online resource.
File format
unknown
Form of item
online
Isbn
9781484234761
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
c
Other control number
10.1007/978-1-4842-3477-8
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000960
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
  • on1030303471
  • (OCoLC)1030303471
Label
Beginning DAX with Power BI : the SQL pro's guide to better business intelligence, Philip Seamark
Publication
Distribution
Copyright
Note
Includes index
Antecedent source
unknown
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
txt
Content type MARC source
rdacontent
Contents
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
Control code
SPR1030303471
Dimensions
unknown
Extent
1 online resource.
File format
unknown
Form of item
online
Isbn
9781484234761
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
c
Other control number
10.1007/978-1-4842-3477-8
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000960
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
  • on1030303471
  • (OCoLC)1030303471

Library Locations

Processing Feedback ...