High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI, 2nd Edition

Contents at a Glance
About the Author .................................................................................................xxvii
Acknowledgments ................................................................................................xxix
Introduction ..........................................................................................................xxxi
■ Chapter 1: Self-Service Business Intelligence with Excel 2016 ............................ 1
■ Chapter 2: Power View and Tables ...................................................................... 17
■ Chapter 3: Filtering Data in Power View ............................................................. 57
■ Chapter 4: Charts in Power View ........................................................................ 87
■ Chapter 5: Advanced Charting with Power View ............................................... 121
■ Chapter 6: Interactive Data Selection in Power View ........................................ 143
■ Chapter 7: Images and Presentation in Power View ......................................... 175
■ Chapter 8: Mapping Data in Power View ........................................................... 205
■ Chapter 9: 3D Maps ........................................................................................... 225
■ Chapter 10: Discovering and Loading Data with Get & Transform
in Excel 2016 ..................................................................................................... 279
■ Chapter 11: Transforming Data Sets Using Get & Transform ............................. 321
■ Chapter 12: Data Cleansing with Get & Transform ............................................ 349
■ Chapter 13: Data Mashup with Get & Transform ............................................... 371
■ Chapter 14: Extending the Excel Data Model Using Power Pivot ....................... 411
■ Chapter 15: Extending the Data Model with Calculated Columns ..................... 463
■ CONTENTS AT A GLANCE
vi
■ Chapter 16: Adding Measures to the Data Model .............................................. 495
■ Chapter 17: Analyzing Data over Time with DAX ............................................... 529
■ Chapter 18: Self-Service Business Intelligence with PowerBI.com .................. 565’