Supercharge Power BI

Power BI is Better When You Learn To Write DAX

Matt Allington (Autor)

Buch | Softcover

346 Seiten

2024 | Fourth edition
Holy Macro! Books (Verlag)
9781615470846 (ISBN)

Titel wird leider nicht erscheinen

Artikel merken

Data analysis expressions (DAX) is the formula language of Power BI. Learning the DAX language is key to empower Power BI users so they can take advantage of these new Business Intelligence (BI) capabilities. This volume clearly explains the concepts of DAX while at the same time offering hands-on practice to engage the reader and help new knowledge stick. This third edition has been updated for the new Power BI Ribbon interface while still providing a bridge for readers wanting to learn DAX in the Power BI, Power Pivot, or Excel.Updated for new Power BI User Interface.

Matt Allington is an Microsoft Data Platform MVP that specialises in teaching and helping business users leverage the Power BI suite of tools to achieve positive business outcomes. Matt has a unique work experience history having spent 15 years working in commercial roles using data, and also having spent 10 years working in IT roles supporting business users to get the data they need. It is the combination of this work history and Matt's rare skill and ability to clearly explain technical concepts that make this book such a valuable stand-alone learning resource. Matt Allington is an Microsoft Data Platform MVP that specialises in teaching and helping business users leverage the Power BI suite of tools to achieve positive business outcomes. Matt has a unique work experience history having spent 15 years working in commercial roles using data, and 10 years working in IT roles supporting business users to get the data they need. It is the combination of this work history and Matt's rare skill and ability to clearly explain technical concepts that make this book such a valuable stand-alone learning resource.

Introduction
1: Concept: Introduction to Data Modelling
2: Concept: Loading Data
3: Concept: Measures
4: DAX Topic: SUM(), COUNT(), COUNTROWS(), MIN(), MAX(), COUNTBLANK(), and DIVIDE()
5: Concept: Filter Propagation
6: Concept: Lookup Tables and Data Tables
7: DAX Topic: The Basic Iterators SUMX() and AVERAGEX()
8: DAX Topic: Calculated Columns
9: DAX Topic: CALCULATE()
10: Concept: Evaluation Context and Context Transition
11: DAX Topic: IF(), SWITCH(), and FIND()
12: DAX Topic: VALUES(), HASONEVALUE(), SELECTEDVALUE(), and CONCATENATEX()
13: DAX Topic: ALL(), ALLEXCEPT(), and ALLSELECTED()
14: DAX Topic: FILTER()
15: DAX Topic: Time Intelligence
16: DAX Topic: RELATED() and RELATEDTABLE()
17: Concept: Disconnected Tables
18: Concept: Multiple Data Tables
19: Concept: Using Analyze in Excel and Cube Formulas
20: Transferring Your Skills to Excel
21: Next Steps on Your DAX Journey

Erscheinungsdatum	05.04.2024
Zusatzinfo	Illustrations
Verlagsort	Uniontown
Sprache	englisch
Maße	209 x 273 mm
Themenwelt	Mathematik / Informatik ► Informatik ► Datenbanken
Themenwelt	Wirtschaft ► Betriebswirtschaft / Management ► Unternehmensführung / Management
ISBN-13	9781615470846 / 9781615470846
Zustand	Neuware