| Description |
1 online resource : illustrations |
| Physical Medium |
polychrome |
| Description |
text file |
| Note |
Includes index. |
| Contents |
Intro; Supercharge Excel; 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() and HASONEVALUE() |
|
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: KPIs; 19: Concept: Multiple Data Tables; 20: Concept: Cube Formulas; 21: Moving from Excel to Power BI; 22: Next Steps on Your DAX Journey; Appendix A: Answers to Practice Exercises; Index |
| Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
| Subject |
Microsoft Excel (Computer file)
|
|
Microsoft Excel (Computer file) |
|
Microsoft PowerPivot (Computer file)
|
|
Microsoft PowerPivot (Computer file) |
|
Microsoft Excel (Computer file) |
|
SQL (Computer program language)
|
|
SQL (Computer program language) |
|
COMPUTERS -- Desktop Applications -- Spreadsheets. |
| Genre/Form |
Electronic books.
|
|
Electronic books.
|
| ISBN |
9781615472369 (electronic book) |
|
1615472363 (electronic book) |
|
9781615473595 (electronic book) |
|
1615473599 (electronic book) |
|
9781615470532 |
|
1615470530 |
|
