The Resource Beginning DAX with Power BI : The SQL Pro’s Guide to Better Business Intelligence, by Philip Seamark, (electronic resource)

Beginning DAX with Power BI : The SQL Pro’s Guide to Better Business Intelligence, by Philip Seamark, (electronic resource)

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
by Philip Seamark
Creator
Author
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
http://library.link/vocab/creatorName
Seamark, Philip
Dewey number
658.054
http://bibfra.me/vocab/relation/httpidlocgovvocabularyrelatorsaut
GXbQnghCq1E
LC call number
QA76.76.M52
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/subjectName
  • Microsoft software
  • Microsoft .NET Framework
  • Big data
  • Microsoft and .NET
  • Big Data/Analytics
Label
Beginning DAX with Power BI : The SQL Pro’s Guide to Better Business Intelligence, by Philip Seamark, (electronic resource)
Instantiates
Publication
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
Dimensions
unknown
Extent
1 online resource (270 pages)
Form of item
online
Isbn
9781484234778
Media category
computer
Media MARC source
rdamedia
Media type code
c
Other control number
10.1007/978-1-4842-3477-8
Sound
unknown sound
Specific material designation
remote
System control number
  • (CKB)4100000002891934
  • (MiAaPQ)EBC5335439
  • (DE-He213)978-1-4842-3477-8
  • (EXLCZ)994100000002891934
Label
Beginning DAX with Power BI : The SQL Pro’s Guide to Better Business Intelligence, by Philip Seamark, (electronic resource)
Publication
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
Dimensions
unknown
Extent
1 online resource (270 pages)
Form of item
online
Isbn
9781484234778
Media category
computer
Media MARC source
rdamedia
Media type code
c
Other control number
10.1007/978-1-4842-3477-8
Sound
unknown sound
Specific material designation
remote
System control number
  • (CKB)4100000002891934
  • (MiAaPQ)EBC5335439
  • (DE-He213)978-1-4842-3477-8
  • (EXLCZ)994100000002891934

Library Locations

  • Albert D. Cohen Management LibraryBorrow it
    181 Freedman Crescent, Winnipeg, MB, R3T 5V4, CA
    49.807878 -97.129961
  • Architecture/Fine Arts LibraryBorrow it
    84 Curry Place, Winnipeg, MB, CA
    49.807716 -97.136226
  • Archives and Special CollectionsBorrow it
    25 Chancellors Circle (Elizabeth Dafoe Library), Room 330, Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Bibliothèque Alfred-Monnin (Université de Saint-Boniface)Borrow it
    200, avenue de la Cathédrale, Local 2110, Winnipeg, MB, R2H 0H7, CA
    49.888861 -97.119735
  • Bill Larson Library (Grace Hospital)Borrow it
    300 Booth Drive, G-227, Winnipeg, MB, R3J 3M7, CA
    49.882400 -97.276436
  • Carolyn Sifton - Helene Fuld Library (St. Boniface General Hospital)Borrow it
    409 Tache Avenue, Winnipeg, MB, R2H 2A6, CA
    49.883388 -97.126050
  • Concordia Hospital LibraryBorrow it
    1095 Concordia Avenue, Winnipeg, MB, R2K 3S8, CA
    49.913252 -97.064683
  • Donald W. Craik Engineering LibraryBorrow it
    75B Chancellors Circle (Engineering Building E3), Room 361, Winnipeg, MB, R3T 2N2, CA
    49.809053 -97.133292
  • E.K. Williams Law LibraryBorrow it
    224 Dysart Road, Winnipeg, MB, R3T 5V4, CA
    49.811829 -97.131017
  • Eckhardt-Gramatté Music LibraryBorrow it
    136 Dafoe Road (Taché Arts Complex), Room 257, Winnipeg, MB, R3T 2N2, CA
    49.807964 -97.132222
  • Elizabeth Dafoe LibraryBorrow it
    25 Chancellors Circle, Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Fr. H. Drake Library (St. Paul's College)Borrow it
    70 Dysart Road, Winnipeg, MB, R3T 2M6, CA
    49.810605 -97.138184
  • J.W. Crane Memorial Library (Deer Lodge Centre)Borrow it
    2109 Portage Avenue, Winnipeg, MB, R3J 0L3, CA
    49.878000 -97.235520
  • Libraries Annex (not open to the public; please see web page for details)Borrow it
    25 Chancellors Circle (in the Elizabeth Dafoe Library), Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Neil John Maclean Health Sciences LibraryBorrow it
    727 McDermot Avenue (Brodie Centre), 200 Level, Winnipeg, MB, R3E 3P5, CA
    49.903563 -97.160554
  • Sciences and Technology LibraryBorrow it
    186 Dysart Road, Winnipeg, MB, R3T 2M8, CA
    49.811526 -97.133257
  • Seven Oaks General Hospital LibraryBorrow it
    2300 McPhillips Street, Winnipeg, MB, R2V 3M3, CA
    49.955177 -97.148865
  • Sister St. Odilon Library (Misericordia Health Centre)Borrow it
    99 Cornish Avenue, Winnipeg, MB, R3C 1A2, CA
    49.879592 -97.160425
  • St. John's College LibraryBorrow it
    92 Dysart Road, Winnipeg, MB, R3T 2M5, CA
    49.811242 -97.137156
  • Victoria General Hospital LibraryBorrow it
    2340 Pembina Highway, Winnipeg, MB, R3T 2E8, CA
    49.806755 -97.152739
  • William R Newman Library (Agriculture)Borrow it
    66 Dafoe Road, Winnipeg, MB, R3T 2R3, CA
    49.806936 -97.135525
Processing Feedback ...