Visual intelligence: Microsoft tools and techniques for visualizing data
Gespeichert in:
Hauptverfasser: | , , |
---|---|
Format: | Buch |
Sprache: | English |
Veröffentlicht: |
Indianapolis, Ind.
Wiley
2013
|
Schlagworte: | |
Online-Zugang: | Cover Inhaltsverzeichnis |
Beschreibung: | XXIX, 400 S. Ill. |
ISBN: | 9781118388037 |
Internformat
MARC
LEADER | 00000nam a22000002c 4500 | ||
---|---|---|---|
001 | BV041021712 | ||
003 | DE-604 | ||
005 | 20130923 | ||
007 | t | ||
008 | 130517s2013 a||| |||| 00||| eng d | ||
020 | |a 9781118388037 |c pbk |9 978-1-118-38803-7 | ||
035 | |a (OCoLC)854710766 | ||
035 | |a (DE-599)BSZ377547336 | ||
040 | |a DE-604 |b ger | ||
041 | 0 | |a eng | |
049 | |a DE-473 |a DE-Aug4 |a DE-863 |a DE-92 |a DE-573 | ||
084 | |a ST 320 |0 (DE-625)143657: |2 rvk | ||
084 | |a ST 515 |0 (DE-625)143677: |2 rvk | ||
100 | 1 | |a Stacey, Mark |e Verfasser |4 aut | |
245 | 1 | 0 | |a Visual intelligence |b Microsoft tools and techniques for visualizing data |c Mark, Stacey ; Joe Salvatore ; Adam Jorgensen |
264 | 1 | |a Indianapolis, Ind. |b Wiley |c 2013 | |
300 | |a XXIX, 400 S. |b Ill. | ||
336 | |b txt |2 rdacontent | ||
337 | |b n |2 rdamedia | ||
338 | |b nc |2 rdacarrier | ||
650 | 0 | 7 | |a Visualisierung |0 (DE-588)4188417-6 |2 gnd |9 rswk-swf |
650 | 0 | 7 | |a Microsoft |0 (DE-588)4362438-8 |2 gnd |9 rswk-swf |
689 | 0 | 0 | |a Visualisierung |0 (DE-588)4188417-6 |D s |
689 | 0 | 1 | |a Microsoft |0 (DE-588)4362438-8 |D s |
689 | 0 | |5 DE-604 | |
700 | 1 | |a Salvatore, Joe |e Verfasser |4 aut | |
700 | 1 | |a Jorgensen, Adam |e Verfasser |4 aut | |
776 | 0 | 8 | |i Erscheint auch als |n Online-Ausgabe |z 978-1-118-41752-2 |
776 | 0 | 8 | |i Erscheint auch als |n Online-Ausgabe |z 978-1-118-43936-4 |
776 | 0 | 8 | |i Erscheint auch als |n Online-Ausgabe |z 978-1-118-70750-0 |
856 | 4 | 2 | |m V:DE-576;X:wiley |q image/jpeg |u http://swbplus.bsz-bw.de/bsz377547336cov.htm |3 Cover |
856 | 4 | 2 | |m Digitalisierung UB Bamberg |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025999276&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
999 | |a oai:aleph.bib-bvb.de:BVB01-025999276 |
Datensatz im Suchindex
DE-BY-863_location | 1340 |
---|---|
DE-BY-FWS_call_number | 1340/ST 515 S775st |
DE-BY-FWS_katkey | 490301 |
DE-BY-FWS_media_number | 083101302166 |
_version_ | 1806176502076669952 |
adam_text | Contents
Introduction
................................................xxiii
Parti
Fundamentals of Visualization
3
Data Visualization versus Artistic Visualization
.................4
The Place of
Infographies
......................................7
Using
3D
Effectively
...........................................7
The Illusion of Depth
.........................................
S
Additional Dimensions
.......................................9
A Description of the Problem and a Proposed Solution
......
W
Summary
....................................................11
Designing a Visualization
13
Goals of Visualization
.........................................13
Human Perceptual Abilities
...................................15
Strategic, Tactical, and Operational Views
.....................18
Glance and Go versus Data Exploration
.......................21
Using Color in Visualizations
..................................23
Use of Perspective and Shape
................................28
Summary
....................................................31
Part II
The Microsoft Toolset
35
A Brief History
...............................................35
Database Tools
...............................................40
The Place of Each Front-End Tool
.............................44
Installing the Sample Databases
..............................46
Summary
....................................................51
xvi CONTENTS
Building Data
Sets to
Support
Visualization
53
What
Data Sets Are...........................................53
Why We Need Them
........................................53
How Data Sets Are Created.
.................................54
Why Data Sets Are Important
...............................54
Common Data Set Elements
..................................54
Data Quality
................................................55
Metadata
...................................................55
Formatting
.................................................56
Data Volume
................................................56
Automated Data
............................................57
Types of Data Sets and Sources
...............................57
Data in the Internet Age
....................................58
Spreadsheets
...............................................58
When to Store Data in a Spreadsheet
........................58
SQL Tables
..................................................59
OLAP
and Tabular Models
...................................60
Reports and Data Feeds
.....................................60
Hadoop and Other Nonrelational Sources
...................61
Creating Data Sets for Visualization
...........................62
Copy and Paste
.............................................62
Exporting Data from Systems
...............................62
Import Techniques and Tools
................................62
Getting Started
..............................................63
Your First Data Set
..........................................63
Your First Data Set
...........................................63
Getting Data
................................................64
Cleaning Your Data
.........................................65
Moving Your Data into a Good Format for Visualization
.....66
Verifying Your Data by Prototyping
..........................67
Summary
....................................................68
Excel and PowerPivot
69
What are Excel and PowerPivot?
..............................69
PowerPivot versus BISM versus Analysis Services
.............69
Column Stores
..............................................73
Multidimensional versus In Memory Models
.................75
Creating Your First PowerPivot Model
.........................75
Step
1:
Understand Your Data
...............................76
Step
2:
Create Your First Model
..............................76
Step
3:
Does Your Model Work?
..............................81
What Does Excel Do for Me?
..................................82
Pivot Charts and Tables
.....................................82
Summary
....................................................86
CONTENTS
Power View 87
What Is
Power View?.........................................87
BISM: The First
Requirement for
Power View.................90
Creating
a
Power View Report................................91
Creating a Data Source.....................................
91
Creating a New Power View Report in Excel
.................91
Enhancing Data Models for Power View
.......................97
Cleaning Up Your Data Model
...............................97
Adding Metadata for Power View
...........................98
Sharing Power View Reports
................................ 100
Publish in SharePoint
......................................707
Exporting to PowerPoint
...................................703
Installing the Power View Samples
...........................103
Summary
.................................................. 104
PerformancePoint
105
Tabular versus Multidimensional Sources
....................105
Requirements for Running PerformancePoint
................106
SharePoint Requirements
..................................706
Authentication Issues when Using Secure Store Service
......108
KPIs, Scorecards, Filters, Reports, and Dashboards
............110
Creating a Data Source
....................................770
Mapping the Time Dimension
..............................7 72
KPIs
........................................................118
Scorecards
.................................................720
Filters
......................................................727
Analytic Reports
...........................................122
Dashboards
................................................123
Combining Visualizations in PerformancePoint
...............124
Embedding an SSRS Report
................................725
Embedding Excel Reports
..................................725
Creating Web Part Pages in SharePoint
......................126
Adding Web Parts
..........................................727
PerformancePoint Connections
.............................728
Installing the PerformancePoint Samples
....................130
Summary
...................................................132
Reporting Services
133
Native versus Integrated Mode
..............................133
Native Mode
...............................................734
SharePoint Integrated Mode
...............................734
Shared and Embedded Data Sources
........................136
CONTENTS
Part III
Authentication: A Better Solution
............................137
The Double Hop Problem
................................../38
Sef
Execution Context: Requirements and Setup
............738
Expressions in Reporting Services
...........................140
Business Intelligence Development Studio and
Visual Studio versus Report Builder
........................141
Installing the Reporting Services Samples
....................145
Summary
...................................................146
Custom Code
147
Silverlight, WPF, XAML, and HTML5
..........................147
The Future of Silverlight
.....................................150
Accessing Data from HTML5
.................................151
Installing the HTML5 samples
...............................152
A Web Service Sample in C#
.................................154
Summary
...................................................167
Scorecards and Indicators
171
A Quick Understanding: Glance and Go
......................172
KPIs
........................................................172
Drill Down
.................................................773
Drill Through
..............................................174
Drill Across
.................................................174
Tool Choices, with Examples
.................................175
PerformancePoint
..........................................175
Excel
.......................................................177
Implementation Examples
...................................179
Implementing a Scorecard in Excel
.........................179
PerformancePoint Services
(PPS)
Scorecard: Traffic Lights
... 182
Custom Indicators in PerformancePoint
....................187
Summary
...................................................189
Timelines
191
Types of Temporal Analysis Visualization
.....................192
Timelines
..................................................794
Line Charts
................................................795
Bar and Column Charts
....................................797
Combined Charting
........................................798
Scatter Plots and Bubble Charts
............................799
CONTENTS
Tiling
......................................................200
Animation.................................................207
Tool
Choices, with Examples
.................................202
PerformancePoint Services
(PPS)
...........................202
SQL Server Reporting Services (SSRS)
.......................205
Excel
.......................................................208
Power View
................................................210
Implementation Examples
...................................214
Power View Animated Scatter Plot
.........................214
Combining Lines and Columns in Excel
.....................218
A Drillable Line Chart in
PPS
...............................222
A Data-Driven Timeline Using SSRS and Data Bars
.........223
Summary
..................................................226
Comparison Visuals
227
Overview of Point-in-Time Comparisons
.....................227
Explaining Perspective and Perceiving Comparisons
........229
Pie Charts Versus Bar Charts
...............................230
Bullet Charts
...............................................231
Radar Charts
..............................................232
Matrices
...................................................233
Custom Comparisons
......................................236
Tool Choices, with Examples
.................................237
PerformancePoint Services
.................................237
SSRS
.......................................................238
Excel
.......................................................238
Power View
................................................240
HTML5
.....................................................241
Implementation Examples
...................................242
PerformancePoint: Column Graphs
.........................242
Excel: Multiple Axes and Scale Breaks
......................244
Excel: Radar Charts
........................................252
SSRS: A Bullet Chart
........................................254
HTML5
.....................................................261
Summary
...................................................267
Slice and Dice: Ad Hoc Analytics
269
Explanation of Terms
........................................270
Self-Service Bl
..............................................270
The Place of PowerPivot
....................................271
Definitions
.................................................272
CONTENTS
Tool Choices with Examples
.................................278
PerformancePoint: Analytic Charts
.........................278
PerformancePoint: Drill Across
.............................280
Excel Pivot Tables
..........................................281
SSRS Drill Down and Drill Through
.........................282
Power View
................................................283
Implementation Examples
..................................284
SSRS: Dynamic Measures
...................................284
Integrating
PPS
and SSRS on a Single Page
.................290
Power View: Exploring Data
................................295
Summary
..................................................298
Relationship Analysis
299
Visualizing Relationships: Nodes, Trees, and Leaves
.........299
Network Maps
.............................................301
Color Wheel
................................................302
Tree Structures: Organization Charts and Other Hierarchies
305
Strategy Maps
.............................................306
Tool Choices
................................................307
PPS
Decomposition Tree
...................................307
Excel and NodeXL
..........................................308
PerformancePoint Services
(PPS)
Strategy Maps
............309
HTML5 Structure Maps
.....................................310
Implementation Examples
...................................311
Building an Organization Chart in PerformancePoint
.......311
Building a Network Map in HTML5
.........................316
Color Wheel in HTML5
.....................................377
Summary
...................................................320
Embedded Visualizations
321
Tabular Data: Adding Visual Acuity
..........................322
Embedded Charts: Sparklines and Bars
.....................323
Conditional Formatting
....................................325
Indicators
..................................................326
Bullet Graphs
..............................................327
Tool Choices with Examples
.................................329
Excel
.......................................................329
SQL Server Reporting Services (SSRS)
.......................330
PerformancePoint
..........................................331
Implementation Examples
...................................331
Embedding Visualizations on a Pivot Table
.................331
Summary
...................................................339
CONTENTS
Other Visualizations
341
Traditional
Infographies.....................................
341
Periodic Tables
.............................................342
Swim Lanes
................................................344
Transportation Maps
.......................................344
Mind Maps
..................................................347
Venn Diagram
...............................................347
CAD Drawings
.............................................348
3D
Modeling
...............................................349
Funnels
....................................................349
Flow Diagrams
..............................................350
Geographic Information System Maps
.......................352
Heatmaps
...................................................355
Summary
...................................................355
Choosing a Microsoft Tool
357
Strengths and Weaknesses of Each Tool
.....................357
PerformancePoint
..........................................357
Reporting Services
..........................................358
Excel/Excel Services
.........................................359
Power View
................................................360
HTML5
......................................................361
Matching a Visualization to a Tool
..........................362
DAX
Function Reference
369
Date and Time Functions
...................................369
Filter Functions
.............................................371
Information Functions
.......................................372
Lookup Functions
...........................................373
Parent-Child Functions
......................................373
Logical Functions
...........................................374
Text Functions
..............................................375
Statistical Functions
.........................................378
Math and Trig Functions
.....................................379
Time Intelligence Functions
.................................381
Index
.......................................................385
|
any_adam_object | 1 |
author | Stacey, Mark Salvatore, Joe Jorgensen, Adam |
author_facet | Stacey, Mark Salvatore, Joe Jorgensen, Adam |
author_role | aut aut aut |
author_sort | Stacey, Mark |
author_variant | m s ms j s js a j aj |
building | Verbundindex |
bvnumber | BV041021712 |
classification_rvk | ST 320 ST 515 |
ctrlnum | (OCoLC)854710766 (DE-599)BSZ377547336 |
discipline | Informatik |
format | Book |
fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01795nam a22004212c 4500</leader><controlfield tag="001">BV041021712</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20130923 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">130517s2013 a||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781118388037</subfield><subfield code="c">pbk</subfield><subfield code="9">978-1-118-38803-7</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)854710766</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BSZ377547336</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-473</subfield><subfield code="a">DE-Aug4</subfield><subfield code="a">DE-863</subfield><subfield code="a">DE-92</subfield><subfield code="a">DE-573</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 320</subfield><subfield code="0">(DE-625)143657:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 515</subfield><subfield code="0">(DE-625)143677:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Stacey, Mark</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Visual intelligence</subfield><subfield code="b">Microsoft tools and techniques for visualizing data</subfield><subfield code="c">Mark, Stacey ; Joe Salvatore ; Adam Jorgensen</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Indianapolis, Ind.</subfield><subfield code="b">Wiley</subfield><subfield code="c">2013</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXIX, 400 S.</subfield><subfield code="b">Ill.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Visualisierung</subfield><subfield code="0">(DE-588)4188417-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Microsoft</subfield><subfield code="0">(DE-588)4362438-8</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Visualisierung</subfield><subfield code="0">(DE-588)4188417-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Microsoft</subfield><subfield code="0">(DE-588)4362438-8</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Salvatore, Joe</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Jorgensen, Adam</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Online-Ausgabe</subfield><subfield code="z">978-1-118-41752-2</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Online-Ausgabe</subfield><subfield code="z">978-1-118-43936-4</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Online-Ausgabe</subfield><subfield code="z">978-1-118-70750-0</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">V:DE-576;X:wiley</subfield><subfield code="q">image/jpeg</subfield><subfield code="u">http://swbplus.bsz-bw.de/bsz377547336cov.htm</subfield><subfield code="3">Cover</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Bamberg</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025999276&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-025999276</subfield></datafield></record></collection> |
id | DE-604.BV041021712 |
illustrated | Illustrated |
indexdate | 2024-08-01T11:22:19Z |
institution | BVB |
isbn | 9781118388037 |
language | English |
oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-025999276 |
oclc_num | 854710766 |
open_access_boolean | |
owner | DE-473 DE-BY-UBG DE-Aug4 DE-863 DE-BY-FWS DE-92 DE-573 |
owner_facet | DE-473 DE-BY-UBG DE-Aug4 DE-863 DE-BY-FWS DE-92 DE-573 |
physical | XXIX, 400 S. Ill. |
publishDate | 2013 |
publishDateSearch | 2013 |
publishDateSort | 2013 |
publisher | Wiley |
record_format | marc |
spellingShingle | Stacey, Mark Salvatore, Joe Jorgensen, Adam Visual intelligence Microsoft tools and techniques for visualizing data Visualisierung (DE-588)4188417-6 gnd Microsoft (DE-588)4362438-8 gnd |
subject_GND | (DE-588)4188417-6 (DE-588)4362438-8 |
title | Visual intelligence Microsoft tools and techniques for visualizing data |
title_auth | Visual intelligence Microsoft tools and techniques for visualizing data |
title_exact_search | Visual intelligence Microsoft tools and techniques for visualizing data |
title_full | Visual intelligence Microsoft tools and techniques for visualizing data Mark, Stacey ; Joe Salvatore ; Adam Jorgensen |
title_fullStr | Visual intelligence Microsoft tools and techniques for visualizing data Mark, Stacey ; Joe Salvatore ; Adam Jorgensen |
title_full_unstemmed | Visual intelligence Microsoft tools and techniques for visualizing data Mark, Stacey ; Joe Salvatore ; Adam Jorgensen |
title_short | Visual intelligence |
title_sort | visual intelligence microsoft tools and techniques for visualizing data |
title_sub | Microsoft tools and techniques for visualizing data |
topic | Visualisierung (DE-588)4188417-6 gnd Microsoft (DE-588)4362438-8 gnd |
topic_facet | Visualisierung Microsoft |
url | http://swbplus.bsz-bw.de/bsz377547336cov.htm http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025999276&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
work_keys_str_mv | AT staceymark visualintelligencemicrosofttoolsandtechniquesforvisualizingdata AT salvatorejoe visualintelligencemicrosofttoolsandtechniquesforvisualizingdata AT jorgensenadam visualintelligencemicrosofttoolsandtechniquesforvisualizingdata |
Inhaltsverzeichnis
Würzburg Teilbibliothek SHL, Raum I.2.11
Signatur: |
1340 ST 515 S775st |
---|---|
Exemplar 1 | nicht ausleihbar Verfügbar |