| |
| |
| Introduction | |
| |
| |
| |
| Introduction to Data Visualization | |
| |
| |
| |
| Fundamentals of Visualization | |
| |
| |
| Data Visualization versus Artistic Visualization | |
| |
| |
| The Place of Infographics | |
| |
| |
| Using 3D Effectively | |
| |
| |
| The Illusion of Depth | |
| |
| |
| Additional Dimensions | |
| |
| |
| A Description of the Problem and a Proposed Solution | |
| |
| |
| Summary | |
| |
| |
| |
| Designing a Visualization | |
| |
| |
| Goals of Visualization | |
| |
| |
| Human Perceptual Abilities | |
| |
| |
| Strategic, Tactical, and Operational Views | |
| |
| |
| Glance and Go versus Data Exploration | |
| |
| |
| Using Color in Visualizations | |
| |
| |
| Use of Perspective and Shape | |
| |
| |
| Summary | |
| |
| |
| |
| Microsoft's Toolset for Visualizing Data | |
| |
| |
| |
| The Microsoft Toolset | |
| |
| |
| A Brief History | |
| |
| |
| Database Tools | |
| |
| |
| The Place of Each Front-End Tool | |
| |
| |
| Installing the Sample Databases | |
| |
| |
| Summary | |
| |
| |
| |
| Building Data Sets to Support Visualization | |
| |
| |
| What Data Sets Are | |
| |
| |
| Why We Need Them | |
| |
| |
| How Data Sets Are Created | |
| |
| |
| Why Data Sets Are Important | |
| |
| |
| Common Data Set Elements | |
| |
| |
| Data Quality | |
| |
| |
| Metadata | |
| |
| |
| Formatting | |
| |
| |
| Data Volume | |
| |
| |
| Automated Data | |
| |
| |
| Types of Data Sets and Sources | |
| |
| |
| Data in the Internet Age | |
| |
| |
| Spreadsheets | |
| |
| |
| When to Store Data in a Spreadsheet | |
| |
| |
| SQL Tables | |
| |
| |
| OLAP and Tabular Models | |
| |
| |
| Reports and Data Feeds | |
| |
| |
| Hadoop and Other Nonrelational Sources | |
| |
| |
| Creating Data Sets for Visualization | |
| |
| |
| Copy and Paste | |
| |
| |
| Exporting Data from Systems | |
| |
| |
| Import Techniques and Tools | |
| |
| |
| Getting Started | |
| |
| |
| Your First Data Set | |
| |
| |
| Your First Data Set | |
| |
| |
| Getting Data | |
| |
| |
| Cleaning Your Data | |
| |
| |
| Moving Your Data into a Good Format for Visualization | |
| |
| |
| Verifying Your Data by Prototyping | |
| |
| |
| Summary | |
| |
| |
| |
| Excel and PowerPivot | |
| |
| |
| What are Excel and PowerPivot? | |
| |
| |
| PowerPivot versus BISM versus Analysis Services | |
| |
| |
| Column Stores | |
| |
| |
| Multidimensional versus In Memory Models | |
| |
| |
| Creating Your First PowerPivot Model | |
| |
| |
| |
| Understand Your Data | |
| |
| |
| |
| Create Your First Model | |
| |
| |
| |
| Does Your Model Work? | |
| |
| |
| What Does Excel Do for Me? | |
| |
| |
| Pivot Charts and Tables | |
| |
| |
| Summary | |
| |
| |
| |
| Power View | |
| |
| |
| What Is Power View? | |
| |
| |
| BISM: The First Requirement for Power View | |
| |
| |
| Creating a Power View Report | |
| |
| |
| Creating a Data Source | |
| |
| |
| Creating a New Power View Report in Excel | |
| |
| |
| Enhancing Data Models for Power View | |
| |
| |
| Cleaning Up Your Data Model | |
| |
| |
| Adding Metadata for Power View | |
| |
| |
| Sharing Power View Reports | |
| |
| |
| Publish in SharePoint | |
| |
| |
| Exporting to PowerPoint | |
| |
| |
| Installing the Power View Samples | |
| |
| |
| Summary | |
| |
| |
| |
| PerformancePoint | |
| |
| |
| Tabular versus Multidimensional Sources | |
| |
| |
| Requirements for Running PerformancePoint | |
| |
| |
| SharePoint Requirements | |
| |
| |
| Authentication Issues when Using Secure Store Service | |
| |
| |
| KPIs, Scorecards, Filters, Reports, and Dashboards | |
| |
| |
| Creating a Data Source | |
| |
| |
| Mapping the Time Dimension | |
| |
| |
| KPIs | |
| |
| |
| Scorecards | |
| |
| |
| Filters | |
| |
| |
| Analytic Reports | |
| |
| |
| Dashboards | |
| |
| |
| Combining Visualizations in PerformancePoint | |
| |
| |
| Embedding an SSRS Report | |
| |
| |
| Embedding Excel Reports | |
| |
| |
| Creating Web Part Pages in SharePoint | |
| |
| |
| Adding Web Parts | |
| |
| |
| PerformancePoint Connections | |
| |
| |
| Installing the PerformancePoint Samples | |
| |
| |
| Summary | |
| |
| |
| |
| Reporting Services | |
| |
| |
| Native versus Integrated Mode | |
| |
| |
| Native Mode | |
| |
| |
| SharePoint Integrated Mode | |
| |
| |
| Shared and Embedded Data Sources | |
| |
| |
| Authentication: A Better Solution | |
| |
| |
| The Double Hop Problem | |
| |
| |
| Set Execution Context: Requirements and Setup | |
| |
| |
| Expressions in Reporting Services | |
| |
| |
| Business Intelligence Development Studio and Visual Studio versus Report Builder | |
| |
| |
| Installing the Reporting Services Samples | |
| |
| |
| Summary | |
| |
| |
| |
| Custom Code | |
| |
| |
| Silverlight, WPF, XAML, and HTML5 | |
| |
| |
| The Future of Silverlight | |
| |
| |
| Accessing Data from HTML5 | |
| |
| |
| Installing the HTML5 samples | |
| |
| |
| A Web Service Sample in C# | |
| |
| |
| Summary | |
| |
| |
| |
| Visual Analytics in Practice | |
| |
| |
| |
| Scorecards and Indicators | |
| |
| |
| A Quick Understanding: Glance and Go | |
| |
| |
| KPIs | |
| |
| |
| Drill Down | |
| |
| |
| Drill Through | |
| |
| |
| Drill Across | |
| |
| |
| Tool Choices, with Examples | |
| |
| |
| PerformancePoint | |
| |
| |
| Excel | |
| |
| |
| Implementation Examples | |
| |
| |
| Implementing a Scorecard in Excel | |
| |
| |
| PerformancePoint Services (PPS) Scorecard: Traffic Lights | |
| |
| |
| Custom Indicators in PerformancePoint | |
| |
| |
| Summary | |
| |
| |
| |
| Timelines | |
| |
| |
| Types of Temporal Analysis Visualization | |
| |
| |
| Timelines | |
| |
| |
| Line Charts | |
| |
| |
| Bar and Column Charts | |
| |
| |
| Combined Charting | |
| |
| |
| Scatter Plots and Bubble Charts | |
| |
| |
| Tiling | |
| |
| |
| Animation | |
| |
| |
| Tool Choices, with Examples | |
| |
| |
| PerformancePoint Services (PPS) | |
| |
| |
| SQL Server Reporting Services (SSRS) | |
| |
| |
| Excel | |
| |
| |
| Power View | |
| |
| |
| Implementation Examples | |
| |
| |
| Power View Animated Scatter Plot | |
| |
| |
| Combining Lines and Columns in Excel | |
| |
| |
| A Drillable Line Chart in PPS | |
| |
| |
| A Data-Driven Timeline Using SSRS and Data Bars | |
| |
| |
| Summary | |
| |
| |
| |
| Comparison Visuals | |
| |
| |
| Overview of Point-in-Time Comparisons | |
| |
| |
| Explaining Perspective and Perceiving Comparisons | |
| |
| |
| Pie Charts Versus Bar Charts | |
| |
| |
| Bullet Charts | |
| |
| |
| Radar Charts | |
| |
| |
| Matrices | |
| |
| |
| Custom Comparisons | |
| |
| |
| Tool Choices, with Examples | |
| |
| |
| PerformancePoint Services | |
| |
| |
| SSRS | |
| |
| |
| Excel | |
| |
| |
| Power View | |
| |
| |
| HTML5 | |
| |
| |
| Implementation Examples | |
| |
| |
| PerformancePoint: Column Graphs | |
| |
| |
| Excel: Multiple Axes and Scale Breaks | |
| |
| |
| Excel: Radar Charts | |
| |
| |
| SSRS: A Bullet Chart | |
| |
| |
| HTML5 | |
| |
| |
| Summary | |
| |
| |
| |
| Slice and Dice: Ad Hoc Analytics | |
| |
| |
| Explanation of Terms | |
| |
| |
| Self-Service Bl | |
| |
| |
| The Place of PowerPivot | |
| |
| |
| Definitions | |
| |
| |
| Tool Choices with Examples | |
| |
| |
| PerformancePoint: Analytic Charts | |
| |
| |
| PerformancePoint: Drill Across | |
| |
| |
| Excel Pivot Tables | |
| |
| |
| SSRS Drill Down and Drill Through | |
| |
| |
| Power View | |
| |
| |
| Implementation Examples | |
| |
| |
| SSRS: Dynamic Measures | |
| |
| |
| Integrating PPS and SSRS on a Single Page | |
| |
| |
| Power View: Exploring Data | |
| |
| |
| Summary | |
| |
| |
| |
| Relationship Analysis | |
| |
| |
| Visualizing Relationships: Nodes, Trees, and Leaves | |
| |
| |
| Network Maps | |
| |
| |
| Color Wheel | |
| |
| |
| Tree Structures: Organization Charts and Other Hierarchies | |
| |
| |
| Strategy Maps | |
| |
| |
| Tool Choices | |
| |
| |
| PPS Decomposition Tree | |
| |
| |
| Excel and NodeXL | |
| |
| |
| PerformancePoint Services (PPS) Strategy Maps | |
| |
| |
| HTML5 Structure Maps | |
| |
| |
| Implementation Examples | |
| |
| |
| Building an Organization Chart in PerformancePoint | |
| |
| |
| Building a Network Map in HTML5 | |
| |
| |
| Color Wheel in HTML5 | |
| |
| |
| Summary | |
| |
| |
| |
| Embedded Visualizations | |
| |
| |
| Tabular Data: Adding Visual Acuity | |
| |
| |
| Embedded Charts: Sparklines and Bars | |
| |
| |
| Conditional Formatting | |
| |
| |
| Indicators | |
| |
| |
| Bullet Graphs | |
| |
| |
| Tool Choices with Examples | |
| |
| |
| Excel | |
| |
| |
| SQL Server Reporting Services (SSRS) | |
| |
| |
| PerformancePoint | |
| |
| |
| Implementation Examples | |
| |
| |
| Embedding Visualizations on a Pivot Table | |
| |
| |
| Summary | |
| |
| |
| |
| Other Visualizations | |
| |
| |
| Traditional Infographics | |
| |
| |
| Periodic Tables | |
| |
| |
| Swim Lanes | |
| |
| |
| Transportation Maps | |
| |
| |
| Mind Maps | |
| |
| |
| Venn Diagram | |
| |
| |
| CAD Drawings | |
| |
| |
| 3D Modeling | |
| |
| |
| Funnels | |
| |
| |
| Flow Diagrams | |
| |
| |
| Geographic Information System Maps | |
| |
| |
| Heatmaps | |
| |
| |
| Summary | |
| |
| |
| |
| Choosing a Microsoft Tool | |
| |
| |
| Strengths and Weaknesses of Each Tool | |
| |
| |
| PerformancePoint | |
| |
| |
| Reporting Services | |
| |
| |
| Excel/Excel Services | |
| |
| |
| Power View | |
| |
| |
| HTML5 | |
| |
| |
| Matching a Visualization to a Tool | |
| |
| |
| |
| DAX Function Reference | |
| |
| |
| Date and Time Functions | |
| |
| |
| Filter Functions | |
| |
| |
| Information Functions | |
| |
| |
| Lookup Functions | |
| |
| |
| Parent-Child Functions | |
| |
| |
| Logical Functions | |
| |
| |
| Text Functions | |
| |
| |
| Statistical Functions | |
| |
| |
| Math and Trig Functions | |
| |
| |
| Time Intelligence Functions | |
| |
| |
| Index | |