Visual Intelligence
(Sprache: Englisch)
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...
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...
Leider schon ausverkauft
versandkostenfrei
Buch
50.99 €
- Lastschrift, Kreditkarte, Paypal, Rechnung
- Kostenlose Rücksendung
Produktdetails
Produktinformationen zu „Visual Intelligence “
Klappentext zu „Visual Intelligence “
Go beyond design concepts and learn to build state-of-the-art visualizationsThe 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.
Inhaltsverzeichnis zu „Visual Intelligence “
Introduction xxiiiPart I Introduction to Data Visualization 11 Fundamentals of Visualization 3Data Visualization versus Artistic Visualization 4The Place of Infographics 7Using 3D Effectively 7The Illusion of Depth 8Additional Dimensions 9A Description of the Problem and a Proposed Solution 10Summary 112 Designing a Visualization 13Goals of Visualization 13Human Perceptual Abilities 15Strategic, Tactical, and Operational Views 18Glance and Go versus Data Exploration 21Using Color in Visualizations 23Use of Perspective and Shape 28Summary 31Part II Microsoft's Toolset for Visualizing Data 333 The Microsoft Toolset 35A Brief History 35Database Tools 40The Place of Each Front-End Tool 44Installing the Sample Databases 46Summary 514 Building Data Sets to Support Visualization 53What Data Sets Are 53Why We Need Them 53How Data Sets Are Created 54Why Data Sets Are Important 54Common Data Set Elements 54Data Quality 55Metadata 55Formatting 56Data Volume 56Automated Data 57Types of Data Sets and Sources 57Data in the Internet Age 58Spreadsheets 58When to Store Data in a Spreadsheet 58SQL Tables 59OLAP and Tabular Models 60Reports and Data Feeds 60Hadoop and Other Nonrelational Sources 61Creating Data Sets for Visualization 62Copy and Paste 62Exporting Data from Systems 62Import Techniques and Tools 62Getting Started 63Your First Data Set 63Your First Data Set 63Getting Data 64Cleaning Your Data 65Moving Your Data into a Good Format for Visualization 66Verifying Your Data by Prototyping 67Summary 685 Excel and PowerPivot 69What are Excel and PowerPivot? 69PowerPivot versus BISM versus Analysis Services 69Column Stores 73Multidimensional versus In Memory Models 75Creating Your First PowerPivot Model 75Step 1: Understand Your Data 76Step 2: Create Your First Model 76Step 3: Does Your Model Work? 81What Does Excel Do for Me? 82Pivot Charts and Tables 82Summary 866 Power View 87What Is Power View? 87BISM: The First Requirement for Power View 90Creating a Power View Report
... mehr
91Creating a Data Source 91Creating a New Power View Report in Excel 91Enhancing Data Models for Power View 97Cleaning Up Your Data Model 97Adding Metadata for Power View 98Sharing Power View Reports 100Publish in SharePoint 101Exporting to PowerPoint 103Installing the Power View Samples 103Summary 1047 PerformancePoint 105Tabular versus Multidimensional Sources 105Requirements for Running PerformancePoint 106SharePoint Requirements 106Authentication Issues when Using Secure Store Service 108KPIs, Scorecards, Filters, Reports, and Dashboards 110Creating a Data Source 110Mapping the Time Dimension 112KPIs 118Scorecards 120Filters 121Analytic Reports 122Dashboards 123Combining Visualizations in PerformancePoint 124Embedding an SSRS Report 125Embedding Excel Reports 125Creating Web Part Pages in SharePoint 126Adding Web Parts 127PerformancePoint Connections 128Installing the PerformancePoint Samples 130Summary 1328 Reporting Services 133Native versus Integrated Mode 133Native Mode 134SharePoint Integrated Mode 134Shared and Embedded Data Sources 136Authentication: A Better Solution 137The Double Hop Problem 138Set Execution Context: Requirements and Setup 138Expressions in Reporting Services 140Business Intelligence Development Studio andVisual Studio versus Report Builder 141Installing the Reporting Services Samples 145Summary 1469 Custom Code 147Silverlight, WPF, XAML, and HTML5 147The Future of Silverlight 150Accessing Data from HTML5 151Installing the HTML5 samples 152A Web Service Sample in C# 154Summary 167Part III Visual Analytics in Practice 16910 Scorecards and Indicators 171A Quick Understanding: Glance and Go 172KPIs 172Drill Down 173Drill Through 174Drill Across 174Tool Choices, with Examples 175PerformancePoint 175Excel 177Implementation Examples 179Implementing a Scorecard in Excel 179PerformancePoint Services (PPS) Scorecard: Traffic Lights 182Custom Indicators in PerformancePoint 187Summary 18911 Timelines 191Types of Temporal Analysis Visualization 192Timelines 194Line Charts 195Bar and Column Charts 197Combined Charting 198Scatter Plots and Bubble Charts 199Tiling 200Animation 201Tool Choices, with Examples 202PerformancePoint Services (PPS) 202SQL Server Reporting Services (SSRS) 205Excel 208Power View 210Implementation Examples 214Power View Animated Scatter Plot 214Combining Lines and Columns in Excel 218A Drillable Line Chart in PPS 222A Data-Driven Timeline Using SSRS and Data Bars 223Summary 22612 Comparison Visuals 227Overview of Point-in-Time Comparisons 227Explaining Perspective and Perceiving Comparisons 229Pie Charts Versus Bar Charts 230Bullet Charts 231Radar Charts 232Matrices 233Custom Comparisons 236Tool Choices, with Examples 237PerformancePoint Services 237SSRS 238Excel 238Power View 240HTML5 241Implementation Examples 242PerformancePoint: Column Graphs 242Excel: Multiple Axes and Scale Breaks 244Excel: Radar Charts 252SSRS: A Bullet Chart 254HTML5 261Summary 26713 Slice and Dice: Ad Hoc Analytics 269Explanation of Terms 270Self-Service BI 270The Place of PowerPivot 271Definitions 272Tool Choices with Examples 278PerformancePoint: Analytic Charts 278PerformancePoint: Drill Across 280Excel Pivot Tables 281SSRS Drill Down and Drill Through 282Power View 283Implementation Examples 284SSRS: Dynamic Measures 284Integrating PPS and SSRS on a Single Page 290Power View: Exploring Data 295Summary 29814 Relationship Analysis 299Visualizing Relationships: Nodes, Trees, and Leaves 299Network Maps 301Color Wheel 302Tree Structures: Organization Charts and Other Hierarchies 305Strategy Maps 306Tool Choices 307PPS Decomposition Tree 307Excel and NodeXL 308PerformancePoint Services (PPS) Strategy Maps 309HTML5 Structure Maps 310Implementation Examples 311Building an Organization Chart in PerformancePoint 311Building a Network Map in HTML5 316Color Wheel in HTML5 317Summary 32015 Embedded Visualizations 321Tabular Data: Adding Visual Acuity 322Embedded Charts: Sparklines and Bars 323Conditional Formatting 325Indicators 326Bullet Graphs 327Tool Choices with Examples 329Excel 329SQL Server Reporting Services (SSRS) 330PerformancePoint 331Implementation Examples 331Embedding Visualizations on a Pivot Table 331Summary 33916 Other Visualizations 341Traditional Infographics 341Periodic Tables 342Swim Lanes 344Transportation Maps 344Mind Maps 347Venn Diagram 347CAD Drawings 3483D Modeling 349Funnels 349Flow Diagrams 350Geographic Information System Maps 352Heatmaps 355Summary 355A Choosing a Microsoft Tool 357Strengths and Weaknesses of Each Tool 357PerformancePoint 357Reporting Services 358Excel/Excel Services 359Power View 360HTML5 361Matching a Visualization to a Tool 362B DAX Function Reference 369Date and Time Functions 369Filter Functions 371Information Functions 372Lookup Functions 373Parent-Child Functions 373Logical Functions 374Text Functions 375Statistical Functions 378Math and Trig Functions 379Time Intelligence Functions 381Index 385
... weniger
Autoren-Porträt von Mark Stacey
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.
Bibliographische Angaben
- Autor: Mark Stacey
- 2013, 1. Auflage., 400 Seiten, mit Abbildungen, Maße: 18,4 x 23,8 cm, Kartoniert (TB), Englisch
- Verlag: Wiley & Sons
- ISBN-10: 1118388038
- ISBN-13: 9781118388037
- Erscheinungsdatum: 29.04.2013
Sprache:
Englisch
Kommentar zu "Visual Intelligence"
0 Gebrauchte Artikel zu „Visual Intelligence“
| Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
|---|
Schreiben Sie einen Kommentar zu "Visual Intelligence".
Kommentar verfassen