Verfügbarkeit: Visual intelligence | Technische Universität München

Visual intelligence: Microsoft tools and techniques for visualizing data

Gespeichert in:

Bibliographische Detailangaben
Beteiligte Personen:	Stacey, Mark (VerfasserIn), Salvatore, Joe (VerfasserIn), Jorgensen, Adam (VerfasserIn)
Format:	Buch
Sprache:	Englisch
Veröffentlicht:	Indianapolis, Ind. Wiley 2013
Schlagwörter:	Visualisierung Microsoft
Links:	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
Umfang:	XXIX, 400 S. Ill.
ISBN:	9781118388037

Internformat

MARC


LEADER	00000nam a22000002c 4500
001	BV041021712
003	DE-604
005	20130923
007	t\|
008	130517s2013 xx 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
943	1		\|a oai:aleph.bib-bvb.de:BVB01-025999276

Datensatz im Suchindex

_version_	1819344222665310208
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>01796nam 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 xx 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="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-025999276</subfield></datafield></record></collection>
id	DE-604.BV041021712
illustrated	Illustrated
indexdate	2024-12-20T16:29:07Z
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

Verfügbarkeit

‌

Per Fernleihe bestellen Inhaltsverzeichnis