Atnaujinkite slapukų nuostatas

Hands-On Data Visualization: Interactive Storytelling From Spreadsheets to Code [Minkštas viršelis]

  • Formatas: Paperback / softback, 275 pages, aukštis x plotis: 233x178 mm
  • Išleidimo metai: 31-May-2021
  • Leidėjas: O'Reilly Media
  • ISBN-10: 1492086002
  • ISBN-13: 9781492086000
Kitos knygos pagal šią temą:
  • Formatas: Paperback / softback, 275 pages, aukštis x plotis: 233x178 mm
  • Išleidimo metai: 31-May-2021
  • Leidėjas: O'Reilly Media
  • ISBN-10: 1492086002
  • ISBN-13: 9781492086000
Kitos knygos pagal šią temą:

Tell your story and show it with data, using free and easy-to-learn tools on the web. This introductory book teaches you how to design interactive charts and customized maps for your website, beginning with simple drag-and-drop tools such as Google Sheets, Datawrapper, and Tableau Public. You'll also gradually learn how to edit open source code templates like Chart.js, Highcharts, and Leaflet on GitHub.

Hands-On Data Visualization takes you step-by-step through tutorials, real-world examples, and online resources. This practical guide is ideal for students, nonprofit organizations, small business owners, local governments, journalists, academics, and anyone who wants to take data out of spreadsheets and turn it into lively interactive stories. No coding experience is required.

  • Build interactive charts and maps and embed them in your website
  • Understand the principles for designing effective charts and maps
  • Learn key data visualization concepts to help you choose the right tools
  • Convert and transform tabular and spatial data to tell your data story
  • Edit and host Chart.js, Highcharts, and Leaflet map code templates on GitHub
  • Learn how to detect bias in charts and maps produced by others
Preface vii
Introduction xiii
Part I Foundational Skills
1 Choose Tools to Tell Your Story
1(12)
Start Sketching Your Data Story
1(3)
Ten Factors When Considering Tools
4(5)
Our Recommended Tools
9(2)
Use a Password Manager
11(2)
2 Strengthen Your Spreadsheet Skills
13(34)
Select Your Spreadsheet Tools
15(2)
Download to CSV or ODS Format
17(2)
Make a Copy of a Google Sheet
19(1)
Share Your Google Sheets
20(1)
Upload and Convert to Google Sheets
21(2)
Geocode Addresses in Google Sheets
23(3)
Collect Data with Google Forms
26(2)
Sort and Filter Data
28(3)
Calculate with Formulas
31(2)
Summarize Data with Pivot Tables
33(5)
Match Columns with VLOOKUP
38(4)
Spreadsheet Versus Relational Database
42(5)
3 Find and Question Your Data
47(20)
Guiding Questions for Your Search
48(4)
Public and Private Data
52(4)
Mask or Aggregate Sensitive Data
56(1)
Open Data Repositories
57(2)
Source Your Data
59(2)
Recognize Bad Data
61(3)
Question Your Data
64(3)
4 Clean Up Messy Data
67(20)
Smart Cleanup with Google Sheets
68(1)
Find and Replace with Blank
69(2)
Transpose Rows and Columns
71(1)
Split Data into Separate Columns
72(3)
Combine Data into One Column
75(1)
Extract Tables from PDFs with Tabula
76(3)
Clean Data with OpenRefine
79(8)
5 Make Meaningful Comparisons
87(12)
Precisely Describe Comparisons
87(3)
Normalize Your Data
90(3)
Beware of Biased Comparisons
93(6)
Part II Building Visualizations
6 Chart Your Data
99(58)
Chart Design Principles
103(10)
Google Sheets Charts
113(1)
Bar and Column Charts
114(7)
Histograms
121(5)
Pie, Line, and Area Charts
126(5)
Datawrapper Charts
131(1)
Annotated Charts
132(5)
Range Charts
137(2)
Scatter and Bubble Charts
139(7)
Tableau Public Charts
146(1)
Scatter Charts with Tableau Public
147(5)
Filtered Line Chart
152(5)
7 Map Your Data
157(58)
Map Design Principles
160(7)
Design Choropleth Colors and Intervals
167(9)
Normalize Choropleth Map Data
176(1)
Point Map with Google My Maps
177(8)
Symbol Point Map with Datawrapper
185(6)
Choropleth Map with Datawrapper
191(9)
Choropleth Map with Tableau Public
200(7)
Current Map with Socrata Open Data
207(8)
8 Table Your Data
215(12)
Table Design Principles
216(2)
Datawrapper Table with Sparklines
218(7)
Other Table-Making Tools
225(2)
9 Embed on the Web
227(18)
Static Image Versus Interactive iframe
228(3)
Get the Embed Code or iframe Tag
231(7)
Paste Code or iframe to a Website
238(7)
Part III Code Templates and Advanced Tools
10 Edit and Host Code with GitHub
245(30)
Copy, Edit, and Host a Simple Leaflet Map Template
247(8)
Convert GitHub Pages Link to iframe
255(1)
Create a New Repo and Upload Files on GitHub
256(5)
GitHub Desktop and Atom Text Editor to Code Efficiently
261(14)
11 Chart.js and Highcharts Templates
275(16)
Bar or Column Chart with Chart.js
277(3)
Error Bars with Chart.js
280(1)
Line Chart with Chartjs
281(2)
Annotated Line Chart with Highcharts
283(2)
Scatter Chart with Chart.js
285(2)
Bubble Chart with Chart.js
287(4)
12 Leaflet Map Templates
291(44)
Leaflet Maps with Google Sheets
294(14)
Leaflet Storymaps with Google Sheets
308(13)
Get Your Google Sheets API Key
321(5)
Leaflet Maps with CSV Data
326(1)
Leaflet Heatmap Points with CSV Data
327(2)
Leaflet Searchable Point Map
329(2)
Leaflet Maps with Open Data APIs
331(4)
13 Transform Your Map Data
335(34)
Geospatial Data and GeoJSON
336(4)
Find GeoJSON Boundary Files
340(1)
Draw and Edit with Geojson.io
341(5)
Edit and Join with Mapshaper
346(12)
Convert Compressed KMZ to KML
358(2)
Georeference with Map Warper
360(1)
Bulk Geocode with US Census
361(2)
Pivot Points into Polygon Data
363(6)
Part IV Telling True, Meaningful Stories
14 Detect Lies and Reduce Bias
369(28)
How to Lie with Charts
371(11)
How to Lie with Maps
382(6)
Recognize and Reduce Data Bias
388(4)
Recognize and Reduce Spatial Bias
392(5)
15 Tell and Show Your Data Story
397(12)
Build a Narrative on a Storyboard
398(4)
Draw Attention to Meaning
402(3)
Acknowledge Sources and Uncertainty
405(1)
Decide on Your Data Story Format
406(3)
Appendix. Fix Common Problems 409(12)
Index 421
Jack Dougherty is a Professor of Educational Studies at Trinity College in Hartford, Connecticut. Professor Dougherty has taught data visualization to undergraduates at Trinity College and to thousands of participants in a global online course. He and his students have partnered with dozens of non-profit organizations, journalists, and researchers to help tell their data stories on the web. Ilya Ilyankou is an Independent Technologist. Ilya has been working with CTData Collaborative to build data visualization and data exploration tools for Connecticut for two years. He studied Computer Science and Studio Arts at Trinity College, Hartford.