کتاب تجسم داده عملی

انتخاب ابزارها برای روایت داستان شما

Start Sketching Your Data Story • Ten Factors When Considering Tools • 1. Easy to Learn • 2. Free or Affordable • 3. Powerful • 4. Supported • 5. Portable • 6. Secure and Private • 7. Collaborative • 8. Cross-Platform • 9. Open Source • 10. Accessible for Visually Impaired Readers • Our Recommended Tools • Use a Password Manager

تقویت مهارت‌های صفحه گسترده شما

Select Your Spreadsheet Tools • Download to CSV or ODS Format • Make a Copy of a Google Sheet • Share Your Google Sheets • Upload and Convert to Google Sheets • Geocode Addresses in Google Sheets • Collect Data with Google Forms • Sort and Filter Data • Calculate with Formulas • Summarize Data with Pivot Tables • Match Columns with VLOOKUP • Spreadsheet Versus Relational Database

یافتن و پرسش از داده‌های شما

Guiding Questions for Your Search • Public and Private Data • Mask or Aggregate Sensitive Data • Open Data Repositories • Source Your Data • Recognize Bad Data • Question Your Data

پاکسازی داده‌های نامرتب

Smart Cleanup with Google Sheets • Find and Replace with Blank • Transpose Rows and Columns • Split Data into Separate Columns • Example 1: Simple Splitting • Example 2: Complex Splitting • Combine Data into One Column • Extract Tables from PDFs with Tabula • Clean Data with OpenRefine • Set Up OpenRefine • Load Data and Start a New Project • Convert Dollar Amounts from Text to Numbers • Cluster Similar Spellings

انجام مقایسه‌های معنادار

Precisely Describe Comparisons • Normalize Your Data • Beware of Biased Comparisons

نمودار کردن داده‌های شما

Chart Design Principles • Deconstruct a Chart • Some Rules Are More Important Than Others • Chart Aesthetics • Google Sheets Charts • Bar and Column Charts • Grouped Bar and Column Charts • Split Bar and Column Charts • Stacked Bar and Column Charts • Histograms • Quick Histograms with Google Sheets Column Stats • Regular Histograms with Google Sheets Charts • Pie, Line, and Area Charts • Pie Charts • Line Charts • Stacked Area Charts • Datawrapper Charts • Annotated Charts • Range Charts • Scatter and Bubble Charts • Scatter Charts with Google Sheets • Bubble Charts • Tableau Public Charts • Scatter Charts with Tableau Public • Install Tableau Public and Connect Data • Create Scatter Chart in the Worksheet • Add Title and Caption, and Publish • Filtered Line Chart • Connect Data to Tableau Public • Build and Publish a Filtered Line Chart

نقشه‌کشی داده‌های شما

Map Design Principles • Deconstructing a Map • Clarify Point-Versus-Polygon Data • Map One Variable, Not Two • Choose Smaller Geographies for Choropleth Maps • Design Choropleth Colors and Intervals • Choose Choropleth Palettes to Match Your Data • Choose Color Intervals to Group Choropleth Map Data • Normalize Choropleth Map Data • Point Map with Google My Maps • Symbol Point Map with Datawrapper • Choropleth Map with Datawrapper • Choropleth Map with Tableau Public • Current Map with Socrata Open Data

جدول‌بندی داده‌های شما

Table Design Principles • Datawrapper Table with Sparklines • Other Table-Making Tools

جاسازی در وب

Static Image Versus Interactive iframe • Get the Embed Code or iframe Tag • From Google Sheets • From Datawrapper • From Tableau Public • Paste Code or iframe to a Website • To WordPress.com Sites • To Self-Hosted WordPress Sites • For Squarespace, Wix, Weebly, or Other Web-Building Sites

ویرایش و میزبانی کد با گیت‌هاب

Copy, Edit, and Host a Simple Leaflet Map Template • Convert GitHub Pages Link to iframe • Create a New Repo and Upload Files on GitHub • GitHub Desktop and Atom Text Editor to Code Efficiently

قالب‌های Chart.js و Highcharts

Bar or Column Chart with Chart.js • Error Bars with Chart.js • Line Chart with Chart.js • Annotated Line Chart with Highcharts • Scatter Chart with Chart.js • Bubble Chart with Chart.js

قالب‌های نقشه Leaflet

Leaflet Maps with Google Sheets • Tutorial Requirements and Overview • Leaflet Storymaps with Google Sheets • Tutorial Requirements and Overview • Get Your Google Sheets API Key • Leaflet Maps with CSV Data • Leaflet Heatmap Points with CSV Data • Leaflet Searchable Point Map • Step 1: Prepare Your Data • Step 2: Download and Edit This Template • Step 3: Publish Your Map • Leaflet Maps with Open Data APIs

تبدیل داده‌های نقشه شما

Geospatial Data and GeoJSON • GeoJSON • Shapefiles • GPS Exchange Format • Keyhole Markup Language • MapInfo TAB • Find GeoJSON Boundary Files • Draw and Edit with GeoJson.io • Convert KML, GPX, and Other Formats into GeoJSON • Create GeoJSON from a CSV File • Create New GeoJSON Data with Drawing Tools • Edit and Join with Mapshaper • Import, Convert, and Export Map Boundary Files • Edit Data for Specific Polygons • Rename Data Fields • Remove Unwanted Data Fields • Simplify Map Boundaries to Reduce File Size • Dissolve Internal Polygons to Create an Outline Map • Clip a Map to Match an Outline Layer • Join Spreadsheet Data With Polygon Map • Count Points in Polygons with Mapshaper • More About Joins • Merge Selected Polygons with Join and Dissolve Commands • Convert Compressed KMZ to KML • Georeference with Map Warper • Bulk Geocode with US Census • Pivot Points into Polygon Data

شناسایی دروغ‌ها و کاهش سوگیری

How to Lie with Charts • Exaggerate Change in Charts • Diminish Change in Charts • How to Lie with Maps • Examine Data and Upload to Datawrapper • Modify the Map Color Ranges • Recognize and Reduce Data Bias • Recognize and Reduce Spatial Bias

گفتن و نمایش داستان داده شما

Build a Narrative on a Storyboard • Draw Attention to Meaning • Acknowledge Sources and Uncertainty • Decide on Your Data Story Format