Muutke küpsiste eelistusi

E-raamat: Visual Intelligence: Microsoft Tools and Techniques for Visualizing Data [Wiley Online]

  • Formaat: 400 pages
  • Ilmumisaeg: 29-Apr-2013
  • Kirjastus: John Wiley & Sons Inc
  • ISBN-10: 1118987179
  • ISBN-13: 9781118987179
Teised raamatud teemal:
  • Wiley Online
  • Hind: 52,85 €*
  • * hind, mis tagab piiramatu üheaegsete kasutajate arvuga ligipääsu piiramatuks ajaks
  • Formaat: 400 pages
  • Ilmumisaeg: 29-Apr-2013
  • Kirjastus: John Wiley & Sons Inc
  • ISBN-10: 1118987179
  • ISBN-13: 9781118987179
Teised raamatud teemal:

Go beyond design concepts and learn to build state-of-the-art visualizations

The visualization experts at Microsoft's Pragmatic Works have created a full-color, step-by-step guide to building specific types of visualizations. The book thoroughly covers the Microsoft toolset for data analysis and visualization, including Excel, and explores best practices for choosing a data visualization design, selecting tools from the Microsoft stack, and building a dynamic data visualization from start to finish. You'll examine different types of visualizations, their strengths and weaknesses, and when to use each one.

  • Data visualization tools unlock the stories within the data, enabling you to present it in a way that is useful for making business decisions
  • This full-color guide introduces data visualization design concepts, then explains the various Microsoft tools used to store and display data
  • Features a detailed discussion of various classes of visualizations, their uses, and the appropriate tools for each
  • Includes practical implementations of various visualizations and best practices for using them
  • Covers out-of-the-box Microsoft tools, custom-developed illustrations and implementations, and code examples

Visual Intelligence: Microsoft Tools and Techniques for Visualizing Data arms you with best practices and the knowledge to choose and build dynamic data visualizations.

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)
Using 3D Effectively
7(1)
The Illusion of Depth
8(1)
Additional Dimensions
9(1)
A Description of the Problem and a Proposed Solution
10(1)
Summary
11(2)
2 Designing a Visualization
13(20)
Goals of Visualization
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)
Summary
31(2)
PART II Microsoft's Toolset for Visualizing Data
33(136)
3 The Microsoft Toolset
35(18)
A Brief History
35(5)
Database Tools
40(4)
The Place of Each Front-End Tool
44(2)
Installing the Sample Databases
46(5)
Summary
51(2)
4 Building Data Sets to Support Visualization
53(16)
What Data Sets Are
53(1)
Why We Need Them
53(1)
How Data Sets Are Created
54(1)
Why Data Sets Are Important
54(1)
Common Data Set Elements
54(1)
Data Quality
55(1)
Metadata
55(1)
Formatting
56(1)
Data Volume
56(1)
Automated Data
57(1)
Types of Data Sets and Sources
57(1)
Data in the Internet Age
58(1)
Spreadsheets
58(1)
When to Store Data in a Spreadsheet
58(1)
SQL Tables
59(1)
OLAP and Tabular Models
60(1)
Reports and Data Feeds
60(1)
Hadoop and Other Nonrelational Sources
61(1)
Creating Data Sets for Visualization
62(1)
Copy and Paste
62(1)
Exporting Data from Systems
62(1)
Import Techniques and Tools
62(1)
Getting Started
63(1)
Your First Data Set
63(1)
Your First Data Set
63(1)
Getting Data
64(1)
Cleaning Your Data
65(1)
Moving Your Data into a Good Format for Visualization
66(1)
Verifying Your Data by Prototyping
67(1)
Summary
68(1)
5 Excel and PowerPivot
69(18)
What are Excel and PowerPivot?
69(1)
PowerPivot versus BISM versus Analysis Services
69(4)
Column Stores
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)
Pivot Charts and Tables
82(4)
Summary
86(1)
6 Power View
87(18)
What Is Power View?
87(3)
BISM: The First Requirement for Power View
90(1)
Creating a Power View Report
91(1)
Creating a Data Source
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)
Publish in SharePoint
101(2)
Exporting to PowerPoint
103(1)
Installing the Power View Samples
103(1)
Summary
104(1)
7 PerformancePoint
105(28)
Tabular versus Multidimensional Sources
105(1)
Requirements for Running PerformancePoint
106(1)
SharePoint Requirements
106(2)
Authentication Issues when Using Secure Store Service
108(2)
KPIs, Scorecards, Filters, Reports, and Dashboards
110(1)
Creating a Data Source
110(2)
Mapping the Time Dimension
112(6)
KPIs
118(2)
Scorecards
120(1)
Filters
121(1)
Analytic Reports
122(1)
Dashboards
123(1)
Combining Visualizations in PerformancePoint
124(1)
Embedding an SSRS Report
125(1)
Embedding Excel Reports
125(1)
Creating Web Part Pages in SharePoint
126(1)
Adding Web Parts
127(1)
PerformancePoint Connections
128(2)
Installing the PerformancePoint Samples
130(2)
Summary
132(1)
8 Reporting Services
133(14)
Native versus Integrated Mode
133(1)
Native Mode
134(1)
SharePoint Integrated Mode
134(2)
Shared and Embedded Data Sources
136(1)
Authentication: A Better Solution
137(1)
The Double Hop Problem
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)
Summary
146(1)
9 Custom Code
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)
Summary
167(2)
PART III Visual Analytics in Practice
169(188)
10 Scorecards and Indicators
171(20)
A Quick Understanding: Glance and Go
172(1)
KPIs
172(1)
Drill Down
173(1)
Drill Through
174(1)
Drill Across
174(1)
Tool Choices, with Examples
175(1)
PerformancePoint
175(2)
Excel
177(2)
Implementation Examples
179(1)
Implementing a Scorecard in Excel
179(3)
PerformancePoint Services (PPS) Scorecard: Traffic Lights
182(5)
Custom Indicators in PerformancePoint
187(2)
Summary
189(2)
11 Timelines
191(36)
Types of Temporal Analysis Visualization
192(2)
Timelines
194(1)
Line Charts
195(2)
Bar and Column Charts
197(1)
Combined Charting
198(1)
Scatter Plots and Bubble Charts
199(1)
Tiling
200(1)
Animation
201(1)
Tool Choices, with Examples
202(1)
PerformancePoint Services (PPS)
202(3)
SQL Server Reporting Services (SSRS)
205(3)
Excel
208(2)
Power View
210(4)
Implementation Examples
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)
Summary
226(1)
12 Comparison Visuals
227(42)
Overview of Point-in-Time Comparisons
227(2)
Explaining Perspective and Perceiving Comparisons
229(1)
Pie Charts Versus Bar Charts
230(1)
Bullet Charts
231(1)
Radar Charts
232(1)
Matrices
233(3)
Custom Comparisons
236(1)
Tool Choices, with Examples
237(1)
PerformancePoint Services
237(1)
SSRS
238(1)
Excel
238(2)
Power View
240(1)
HTML5
241(1)
Implementation Examples
242(1)
PerformancePoint: Column Graphs
242(2)
Excel: Multiple Axes and Scale Breaks
244(8)
Excel: Radar Charts
252(2)
SSRS: A Bullet Chart
254(7)
HTML5
261(6)
Summary
267(2)
13 Slice and Dice: Ad Hoc Analytics
269(30)
Explanation of Terms
270(1)
Self-Service BI
270(1)
The Place of PowerPivot
271(1)
Definitions
272(6)
Tool Choices with Examples
278(1)
PerformancePoint: Analytic Charts
278(2)
PerformancePoint: Drill Across
280(1)
Excel Pivot Tables
281(1)
SSRS Drill Down and Drill Through
282(1)
Power View
283(1)
Implementation Examples
284(1)
SSRS: Dynamic Measures
284(6)
Integrating PPS and SSRS on a Single Page
290(5)
Power View: Exploring Data
295(3)
Summary
298(1)
14 Relationship Analysis
299(22)
Visualizing Relationships: Nodes, Trees, and Leaves
299(2)
Network Maps
301(1)
Color Wheel
302(3)
Tree Structures: Organization Charts and Other Hierarchies
305(1)
Strategy Maps
306(1)
Tool Choices
307(1)
PPS Decomposition Tree
307(1)
Excel and NodeXL
308(1)
PerformancePoint Services (PPS) Strategy Maps
309(1)
HTML5 Structure Maps
310(1)
Implementation Examples
311(1)
Building an Organization Chart in PerformancePoint
311(5)
Building a Network Map in HTML5
316(1)
Color Wheel in HTML5
317(3)
Summary
320(1)
15 Embedded Visualizations
321(20)
Tabular Data: Adding Visual Acuity
322(1)
Embedded Charts: Sparklines and Bars
323(2)
Conditional Formatting
325(1)
Indicators
326(1)
Bullet Graphs
327(2)
Tool Choices with Examples
329(1)
Excel
329(1)
SQL Server Reporting Services (SSRS)
330(1)
PerformancePoint
331(1)
Implementation Examples
331(1)
Embedding Visualizations on a Pivot Table
331(8)
Summary
339(2)
16 Other Visualizations
341(16)
Traditional Infographics
341(1)
Periodic Tables
342(2)
Swim Lanes
344(1)
Transportation Maps
344(3)
Mind Maps
347(1)
Venn Diagram
347(1)
CAD Drawings
348(1)
3D Modeling
349(1)
Funnels
349(1)
Flow Diagrams
350(2)
Geographic Information System Maps
352(3)
Heatmaps
355(1)
Summary
355(2)
A Choosing a Microsoft Tool
357(12)
Strengths and Weaknesses of Each Tool
357(1)
PerformancePoint
357(1)
Reporting Services
358(1)
Excel/Excel Services
359(1)
Power View
360(1)
HTML5
361(1)
Matching a Visualization to a Tool
362(7)
B DAX Function Reference
369(16)
Date and Time Functions
369(2)
Filter Functions
371(1)
Information Functions
372(1)
Lookup Functions
373(1)
Parent-Child Functions
373(1)
Logical Functions
374(1)
Text Functions
375(3)
Statistical Functions
378(1)
Math and Trig Functions
379(2)
Time Intelligence Functions
381(4)
Index 385
Mark Stacey founded Pragmatic Works South Africa (a company specializing in data management and presentation) and Aphelion Software (software for visualization). He has developed visualizations for major corporations and the South African government. Joe Salvatore is a Business Intelligence Architect with Pragmatic Works. He has been a database architect, business intelligence developer, and application developer for more than 15 years. Adam Jorgensen is President of Pragmatic Works, Director at Large for the Professional Association of SQL Server, and a Microsoft SQL Server MVP. He regularly speaks at industry events.