| Description |
1 online resource |
| Physical Medium |
polychrome |
| Description |
text file |
| Contents |
Intro; Appendix_A:_Answers_to_Practice_Exercise; Hereâ#x80;#x99;s How: Getting Power BI Desktop; Hereâ#x80;#x99;s How: Loading Data from a New Source; Hereâ#x80;#x99;s How: Joining Tables in Power BI Desktop; Hereâ#x80;#x99;s How: Making Changes to a Table That Is Already Loaded; Hereâ#x80;#x99;s How: Deleting Steps in a Query; Hereâ#x80;#x99;s How: Importing New Tables; Hereâ#x80;#x99;s How: Changing the File Location of an Existing Connection; Hereâ#x80;#x99;s How: Inserting a Matrix; Hereâ#x80;#x99;s How: Writing Measures; Hereâ#x80;#x99;s How: Increasing Font Size; Hereâ#x80;#x99;s How: Using IntelliSense; Hereâ#x80;#x99;s How: Editing Measures. |
|
Hereâ#x80;#x99;s How: Adding Comments to MeasuresHereâ#x80;#x99;s How: Creating New Pages in Power BI; Hereâ#x80;#x99;s How: Changing Display Names in Visuals; Hereâ#x80;#x99;s How: Word Wrapping in a Visual; Hereâ#x80;#x99;s How: Applying Conditional Formatting; Hereâ#x80;#x99;s How: Drilling Through Rows in a Matrix; Hereâ#x80;#x99;s How: Moving an Existing Measure to a Different Home Table; Hereâ#x80;#x99;s How: Creating a Day Type Calculated Column; Hereâ#x80;#x99;s How: Changing the MonthName Sort Order; Hereâ#x80;#x99;s How: Using ALLEXCEPT(); Hereâ#x80;#x99;s How: Turning Off Auto Date/Time; Hereâ#x80;#x99;s How: Manually Adding Data to Power BI; Hereâ#x80;#x99;s How: Using What-If. |
|
Hereâ#x80;#x99;s How: Solving Practice Exercise 70Hereâ#x80;#x99;s How: Creating a Morphing Switch Measure; Hereâ#x80;#x99;s How: Applying Banding; Hereâ#x80;#x99;s How: Editing a Table Previously Created with Enter Data; Hereâ#x80;#x99;s How: Deleting Interim Calculated Columns; Hereâ#x80;#x99;s How: Adding a Budget Table; Hereâ#x80;#x99;s How: Publishing a Report to PowerBI.com; Hereâ#x80;#x99;s How: Using Analyze in Excel; Hereâ#x80;#x99;s How: Converting a Pivot Table to Cube Formulas; Hereâ#x80;#x99;s How: Writing CUBEVALUE() from Scratch; Hereâ#x80;#x99;s How: Applying Filters to Cube Formulas; Hereâ#x80;#x99;s How: Adding a Slicer Without a Pivot Table. |
|
Hereâ#x80;#x99;s How: Connecting a Slicer to a Cube FormulaHereâ#x80;#x99;s How: Importing Excel Power Pivot Workbooks to Power BI Desktop; Hereâ#x80;#x99;s How: Writing Measures; 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; Appendix A: Answers to Practice Exercises; Table of Here's How Sections; Index. |
| Note |
Includes index. |
| Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
| Subject |
Microsoft PowerPivot (Computer file)
|
|
Microsoft PowerPivot (Computer file) |
|
Microsoft Excel (Computer file)
|
|
Microsoft Excel (Computer file) |
|
Microsoft Excel (Computer file) |
|
Business intelligence -- Computer programs.
|
|
Business intelligence. |
|
Computer programs. |
|
COMPUTERS -- Enterprise Applications -- Business Intelligence Tools. |
| Genre/Form |
Electronic books.
|
| Other Form: |
Print version: Allington, Matt. Super Charge Power BI : Power BI Is Better When You Learn to Write DAX. Chicago : Holy Macro! Books, ©2018 |
| ISBN |
9781615472352 (electronic book) |
|
1615472355 (electronic book) |
|
9781615473601 (electronic book) |
|
1615473602 (electronic book) |
|
