| Introduction |
|
xxiii | |
|
PART I Introduction to Data Visualization |
|
|
1 | (32) |
|
1 Fundamentals of Visualization |
|
|
3 | (10) |
|
Data Visualization versus Artistic Visualization |
|
|
4 | (3) |
|
The Place of Infographics |
|
|
7 | (1) |
|
|
|
7 | (1) |
|
|
|
8 | (1) |
|
|
|
9 | (1) |
|
A Description of the Problem and a Proposed Solution |
|
|
10 | (1) |
|
|
|
11 | (2) |
|
2 Designing a Visualization |
|
|
13 | (20) |
|
|
|
13 | (2) |
|
Human Perceptual Abilities |
|
|
15 | (3) |
|
Strategic, Tactical, and Operational Views |
|
|
18 | (3) |
|
Glance and Go versus Data Exploration |
|
|
21 | (2) |
|
Using Color in Visualizations |
|
|
23 | (5) |
|
Use of Perspective and Shape |
|
|
28 | (3) |
|
|
|
31 | (2) |
|
PART II Microsoft's Toolset for Visualizing Data |
|
|
33 | (136) |
|
|
|
35 | (18) |
|
|
|
35 | (5) |
|
|
|
40 | (4) |
|
The Place of Each Front-End Tool |
|
|
44 | (2) |
|
Installing the Sample Databases |
|
|
46 | (5) |
|
|
|
51 | (2) |
|
4 Building Data Sets to Support Visualization |
|
|
53 | (16) |
|
|
|
53 | (1) |
|
|
|
53 | (1) |
|
How Data Sets Are Created |
|
|
54 | (1) |
|
Why Data Sets Are Important |
|
|
54 | (1) |
|
|
|
54 | (1) |
|
|
|
55 | (1) |
|
|
|
55 | (1) |
|
|
|
56 | (1) |
|
|
|
56 | (1) |
|
|
|
57 | (1) |
|
Types of Data Sets and Sources |
|
|
57 | (1) |
|
|
|
58 | (1) |
|
|
|
58 | (1) |
|
When to Store Data in a Spreadsheet |
|
|
58 | (1) |
|
|
|
59 | (1) |
|
|
|
60 | (1) |
|
|
|
60 | (1) |
|
Hadoop and Other Nonrelational Sources |
|
|
61 | (1) |
|
Creating Data Sets for Visualization |
|
|
62 | (1) |
|
|
|
62 | (1) |
|
Exporting Data from Systems |
|
|
62 | (1) |
|
Import Techniques and Tools |
|
|
62 | (1) |
|
|
|
63 | (1) |
|
|
|
63 | (1) |
|
|
|
63 | (1) |
|
|
|
64 | (1) |
|
|
|
65 | (1) |
|
Moving Your Data into a Good Format for Visualization |
|
|
66 | (1) |
|
Verifying Your Data by Prototyping |
|
|
67 | (1) |
|
|
|
68 | (1) |
|
|
|
69 | (18) |
|
What are Excel and PowerPivot? |
|
|
69 | (1) |
|
PowerPivot versus BISM versus Analysis Services |
|
|
69 | (4) |
|
|
|
73 | (2) |
|
Multidimensional versus In Memory Models |
|
|
75 | (1) |
|
Creating Your First PowerPivot Model |
|
|
75 | (1) |
|
Step 1: Understand Your Data |
|
|
76 | (1) |
|
Step 2: Create Your First Model |
|
|
76 | (11) |
|
Step 3: Does Your Model Work? |
|
|
87 | |
|
What Does Excel Do for Me? |
|
|
82 | (1) |
|
|
|
82 | (4) |
|
|
|
86 | (1) |
|
|
|
87 | (18) |
|
|
|
87 | (3) |
|
BISM: The First Requirement for Power View |
|
|
90 | (1) |
|
Creating a Power View Report |
|
|
91 | (1) |
|
|
|
91 | (1) |
|
Creating a New Power View Report in Excel |
|
|
91 | (6) |
|
Enhancing Data Models for Power View |
|
|
97 | (1) |
|
Cleaning Up Your Data Model |
|
|
97 | (1) |
|
Adding Metadata for Power View |
|
|
98 | (2) |
|
Sharing Power View Reports |
|
|
100 | (1) |
|
|
|
101 | (2) |
|
|
|
103 | (1) |
|
Installing the Power View Samples |
|
|
103 | (1) |
|
|
|
104 | (1) |
|
|
|
105 | (28) |
|
Tabular versus Multidimensional Sources |
|
|
105 | (1) |
|
Requirements for Running PerformancePoint |
|
|
106 | (1) |
|
|
|
106 | (2) |
|
Authentication Issues when Using Secure Store Service |
|
|
108 | (2) |
|
KPIs, Scorecards, Filters, Reports, and Dashboards |
|
|
110 | (1) |
|
|
|
110 | (2) |
|
Mapping the Time Dimension |
|
|
112 | (6) |
|
|
|
118 | (2) |
|
|
|
120 | (1) |
|
|
|
121 | (1) |
|
|
|
122 | (1) |
|
|
|
123 | (1) |
|
Combining Visualizations in PerformancePoint |
|
|
124 | (1) |
|
|
|
125 | (1) |
|
|
|
125 | (1) |
|
Creating Web Part Pages in SharePoint |
|
|
126 | (1) |
|
|
|
127 | (1) |
|
PerformancePoint Connections |
|
|
128 | (2) |
|
Installing the PerformancePoint Samples |
|
|
130 | (2) |
|
|
|
132 | (1) |
|
|
|
133 | (14) |
|
Native versus Integrated Mode |
|
|
133 | (1) |
|
|
|
134 | (1) |
|
SharePoint Integrated Mode |
|
|
134 | (2) |
|
Shared and Embedded Data Sources |
|
|
136 | (1) |
|
Authentication: A Better Solution |
|
|
137 | (1) |
|
|
|
138 | (1) |
|
Set Execution Context: Requirements and Setup |
|
|
138 | (2) |
|
Expressions in Reporting Services |
|
|
140 | (1) |
|
Business Intelligence Development Studio and Visual Studio versus Report Builder |
|
|
141 | (4) |
|
Installing the Reporting Services Samples |
|
|
145 | (1) |
|
|
|
146 | (1) |
|
|
|
147 | (22) |
|
Silverlight, WPF, XAML, and HTML5 |
|
|
147 | (3) |
|
The Future of Silverlight |
|
|
150 | (1) |
|
Accessing Data from HTML5 |
|
|
151 | (1) |
|
Installing the HTML5 samples |
|
|
152 | (2) |
|
A Web Service Sample in C# |
|
|
154 | (13) |
|
|
|
167 | (2) |
|
PART III Visual Analytics in Practice |
|
|
169 | (188) |
|
10 Scorecards and Indicators |
|
|
171 | (20) |
|
A Quick Understanding: Glance and Go |
|
|
172 | (1) |
|
|
|
172 | (1) |
|
|
|
173 | (1) |
|
|
|
174 | (1) |
|
|
|
174 | (1) |
|
Tool Choices, with Examples |
|
|
175 | (1) |
|
|
|
175 | (2) |
|
|
|
177 | (2) |
|
|
|
179 | (1) |
|
Implementing a Scorecard in Excel |
|
|
179 | (3) |
|
PerformancePoint Services (PPS) Scorecard: Traffic Lights |
|
|
182 | (5) |
|
Custom Indicators in PerformancePoint |
|
|
187 | (2) |
|
|
|
189 | (2) |
|
|
|
191 | (36) |
|
Types of Temporal Analysis Visualization |
|
|
192 | (2) |
|
|
|
194 | (1) |
|
|
|
195 | (2) |
|
|
|
197 | (1) |
|
|
|
198 | (1) |
|
Scatter Plots and Bubble Charts |
|
|
199 | (1) |
|
|
|
200 | (1) |
|
|
|
201 | (1) |
|
Tool Choices, with Examples |
|
|
202 | (1) |
|
PerformancePoint Services (PPS) |
|
|
202 | (3) |
|
SQL Server Reporting Services (SSRS) |
|
|
205 | (3) |
|
|
|
208 | (2) |
|
|
|
210 | (4) |
|
|
|
214 | (1) |
|
Power View Animated Scatter Plot |
|
|
214 | (4) |
|
Combining Lines and Columns in Excel |
|
|
218 | (4) |
|
A Drillable Line Chart in PPS |
|
|
222 | (1) |
|
A Data-Driven Timeline Using SSRS and Data Bars |
|
|
223 | (3) |
|
|
|
226 | (1) |
|
|
|
227 | (42) |
|
Overview of Point-in-Time Comparisons |
|
|
227 | (2) |
|
Explaining Perspective and Perceiving Comparisons |
|
|
229 | (1) |
|
Pie Charts Versus Bar Charts |
|
|
230 | (1) |
|
|
|
231 | (1) |
|
|
|
232 | (1) |
|
|
|
233 | (3) |
|
|
|
236 | (1) |
|
Tool Choices, with Examples |
|
|
237 | (1) |
|
PerformancePoint Services |
|
|
237 | (1) |
|
|
|
238 | (1) |
|
|
|
238 | (2) |
|
|
|
240 | (1) |
|
|
|
241 | (1) |
|
|
|
242 | (1) |
|
PerformancePoint: Column Graphs |
|
|
242 | (2) |
|
Excel: Multiple Axes and Scale Breaks |
|
|
244 | (8) |
|
|
|
252 | (2) |
|
|
|
254 | (7) |
|
|
|
261 | (6) |
|
|
|
267 | (2) |
|
13 Slice and Dice: Ad Hoc Analytics |
|
|
269 | (30) |
|
|
|
270 | (1) |
|
|
|
270 | (1) |
|
|
|
271 | (1) |
|
|
|
272 | (6) |
|
Tool Choices with Examples |
|
|
278 | (1) |
|
PerformancePoint: Analytic Charts |
|
|
278 | (2) |
|
PerformancePoint: Drill Across |
|
|
280 | (1) |
|
|
|
281 | (1) |
|
SSRS Drill Down and Drill Through |
|
|
282 | (1) |
|
|
|
283 | (1) |
|
|
|
284 | (1) |
|
|
|
284 | (6) |
|
Integrating PPS and SSRS on a Single Page |
|
|
290 | (5) |
|
Power View: Exploring Data |
|
|
295 | (3) |
|
|
|
298 | (1) |
|
|
|
299 | (22) |
|
Visualizing Relationships: Nodes, Trees, and Leaves |
|
|
299 | (2) |
|
|
|
301 | (1) |
|
|
|
302 | (3) |
|
Tree Structures: Organization Charts and Other Hierarchies |
|
|
305 | (1) |
|
|
|
306 | (1) |
|
|
|
307 | (1) |
|
|
|
307 | (1) |
|
|
|
308 | (1) |
|
PerformancePoint Services (PPS) Strategy Maps |
|
|
309 | (1) |
|
|
|
310 | (1) |
|
|
|
311 | (1) |
|
Building an Organization Chart in PerformancePoint |
|
|
311 | (5) |
|
Building a Network Map in HTML5 |
|
|
316 | (1) |
|
|
|
317 | (3) |
|
|
|
320 | (1) |
|
15 Embedded Visualizations |
|
|
321 | (20) |
|
Tabular Data: Adding Visual Acuity |
|
|
322 | (1) |
|
Embedded Charts: Sparklines and Bars |
|
|
323 | (2) |
|
|
|
325 | (1) |
|
|
|
326 | (1) |
|
|
|
327 | (2) |
|
Tool Choices with Examples |
|
|
329 | (1) |
|
|
|
329 | (1) |
|
SQL Server Reporting Services (SSRS) |
|
|
330 | (1) |
|
|
|
331 | (1) |
|
|
|
331 | (1) |
|
Embedding Visualizations on a Pivot Table |
|
|
331 | (8) |
|
|
|
339 | (2) |
|
|
|
341 | (16) |
|
|
|
341 | (1) |
|
|
|
342 | (2) |
|
|
|
344 | (1) |
|
|
|
344 | (3) |
|
|
|
347 | (1) |
|
|
|
347 | (1) |
|
|
|
348 | (1) |
|
|
|
349 | (1) |
|
|
|
349 | (1) |
|
|
|
350 | (2) |
|
Geographic Information System Maps |
|
|
352 | (3) |
|
|
|
355 | (1) |
|
|
|
355 | (2) |
|
A Choosing a Microsoft Tool |
|
|
357 | (12) |
|
Strengths and Weaknesses of Each Tool |
|
|
357 | (1) |
|
|
|
357 | (1) |
|
|
|
358 | (1) |
|
|
|
359 | (1) |
|
|
|
360 | (1) |
|
|
|
361 | (1) |
|
Matching a Visualization to a Tool |
|
|
362 | (7) |
|
|
|
369 | (16) |
|
|
|
369 | (2) |
|
|
|
371 | (1) |
|
|
|
372 | (1) |
|
|
|
373 | (1) |
|
|
|
373 | (1) |
|
|
|
374 | (1) |
|
|
|
375 | (3) |
|
|
|
378 | (1) |
|
|
|
379 | (2) |
|
Time Intelligence Functions |
|
|
381 | (4) |
| Index |
|
385 | |