High impact data visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI. (2016)

• Record Type: Book
• Further Information: Note: Adam Aspin.
• Authors: Aspin, Adam
• Contents: At a Glance; Contents; About the Author; Acknowledgments; Introduction; Chapter 1: Self-Service Business Intelligence with Excel 2016; The Excel BI Toolkit; The Self-Service Business Intelligence Universe in Excel 2016; Get and Transform; Power Pivot; The Excel Data Model; DAX; Power View; 3D Maps; The Power BI Service; Preparing the Excel BI Toolkit; Enabling the Excel BI Toolkit; Power View; Get and Transform; 3D Maps; Corporate BI or Self-Service BI?; The Excel Data Model; How This Book Is Designed to Be Read; Discovering Data; Creating a Data Model. Taking Data and Preparing It for OutputDelivering Geodata; Taking Existing Excel BI and Sharing It; Delivering Excel BI to Mobile Devices; Learning the Product Suite Following a Real-World Path; Conclusion; Chapter 2: Power View and Tables; The Power View Experience; Adding a Power View Sheet to an Excel Workbook; The Power View Interface; The Power View Ribbon; The Field List; Using the Field List; Renaming or Deleting a Power View Report; Tables in Power View; Adding a Table; Deleting a Table; Changing the Table Size and Position; Changing Column Order; Removing Columns from a Table. Types of DataData and Aggregations; Enhancing Tables; The Design Ribbon; Row Totals; Formatting Columns of Numbers; Default Formatting; Changing Column Widths; Font Sizes in Tables; Copying a Table; Sorting by Column; Table Granularity; Matrix Tables; Row Matrix; Column Matrix; Sorting Data in Matrix Tables; Drilling Through with Matrix Tables; Drilling Down; Drilling Up; Reapplying Matrix Visualization; Drilling Through with Column Hierarchies; Card Visualizations; Card Visualization Styles; Sorting Data in Card-View Tables; Switching Between Table Types; Key Performance Indicators. Creating Power View Reports and Tables Without a Data ModelConclusion; Chapter 3: Filtering Data in Power View; Filters; View Filters; Adding Filters; Using the (All) Filter; Clearing Filters; Deleting Filters; Expanding and Collapsing Filters; Subsetting Large Filter Lists; Searching for Specific Elements in a Filter; Clearing a Filter Subset; Filtering with Wildcards; Clearing a Filter Element Search; Filtering Different Data Types; Range Filter Mode; List Filter Mode; Quickly Excluding Outliers; Date and Time Data; Other Data Types; Multiple Filters; Advanced Filters. Applying an Advanced FilterClearing an Advanced Filter; Advanced Wildcard Filters; Numeric Filters; Date and Time Filters; Complex Filters; Advanced Text Filter Options; Advanced Numeric Filter Options; Advanced Date Filter Options; Visualization-Level Filters; Filter Hierarchy; Filtering Tips; Don't Filter Too Soon; Drill-Down and Filters; Annotate, Annotate, Annotate; Conclusion; Chapter 4: Charts in Power View; A First Chart; Deleting a Chart; Basic Chart Modification; Basic Chart Types; Column Charts; Line Charts; Pie Charts; Essential Chart Adjustments; Resizing Charts.
• Edition: Second edition
• Publisher Details: United States : Apress
• Publication Date: 2016
• Copyright Date: 2016
• Extent: 1 online resource (xxxii, 599 pages), color illustrations
• Subjects: 001.4/226; Computer science; Information visualization; REFERENCE -- Questions & Answers; Information visualization; Computers -- Data Processing; Information technology: general issues; Electronic books
• Languages: English
• ISBNs: 9781484224007; 1484224000; 1484223993; 9781484223994
• Related ISBNs: 9781484223994
• Notes: Note: Online resource; title from PDF title page (SpringerLink, viewed December 8, 2016).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.