Data Visualization Toolkit: Using JavaScript,Rails,and Postgres to Present Data and Geospatial Information

Data Visualization Toolkit: Using JavaScript,Rails,and Postgres to Present Data and Geospatial Information (Addison-Wesley Professional Ruby Series)
by Barrett Clark
pages 页数: 256 pages
Publisher Finelybook 出版社: Addison Wesley; 01 edition (18 Aug. 2016)
Language 语言: English
ISBN-10 书号: 0134464435
ISBN-13 书号: 9780134464435
B01JP91OQK
Create Beautiful Visualizations that Free Your Data to Tell Powerful Truths
“The depth of Barrett Clark’s knowledge shines through in his writing: clear,concise,and confident. Barrett has been practicing all of this stuff in his day job for many years–Postgres,D3,GIS,all of it. The knowledge in this book is real-world and hard-earned!”
–From the Foreword by Obie Fernandez
Data Visualization Toolkit is your hands-on,practical,and holistic guide to the art of visualizing data. You’ll learn how to use Rails,jQuery,D3,Leaflet,PostgreSQL,and PostGIS together,creating beautiful visualizations and maps that give your data a voice and to make it “dance.”
Barrett Clark teaches through real-world problems and examples developed specifically to illuminate every technique you need to generate stunningly effective visualizations. You’ll move from the absolute basics toward deep dives,mastering diverse visualizations and discovering when to use each. Along the way,you’ll build three start-to-finish visualization applications,using actual real estate,weather,and travel datasets.
Clark addresses every component of data visualization: your data,database,application server,visualization libraries,and more. He explains data transformations; presents expert techniques in JavaScript,Ruby,and SQL; and illuminates key concepts associated with both descriptive statistics and geospatial data. Throughout,everything is aimed at one goal: to help you cut through the clutter and let your data tell all it can.
This guide will help you
Explore and understand the data visualization technology stack
Master the thought process and steps involved in importing data
Extract,transform,and load data in usable,reliable form
Handle spotty data,or data that doesn’t line up with what your chart expects
Use D3 to build pie and bar charts,scatter and box plots,and more
Work effectively with time-series data
Tweak Ruby and SQL to optimize performance with large datasets
Use raw SQL in Rails: window functions,subqueries,and common table expressions
Build chord diagrams and time-series aggregates
Use separate databases or schema for reporting databases
Integrate geographical data via geospatial SQL queries
Construct maps with Leaflet and Rails
Query geospatial data the “Rails way” and the “raw SQL way”
Contents
Part I ActiveRecord and D3
Chapter 1 D3 and Rails
Chapter 2 Transforming Data with ActiveRecord and D3
Chapter 3 Working with Time Series Data
Chapter 4 Working with Large Datasets
Part II Using SQL in Rails
Chapter 5 Window Functions,Subqueries,and Common Table Expression
Chapter 6 The Chord Diagram
Chapter 7 Time Series Aggregates in Postgres
Chapter 8 Using a Separate Reporting Database
Part III Geospatial Rails
Chapter 9 Working with Geospatial Data in Rails
Chapter 10 Making Maps with Leaflet and Rails
Chapter 11 Querying Geospatial Data
Appendix A Ruby and Rails Setup
Appendix B Brief Postgres Overview
Appendix C SQL Join Overview
创建美丽的可视化，使您的数据免遭强大的真相
“巴雷特·克拉克（Barrett Clark）的深刻知识在他的写作中发现: 清晰，简洁和自信。巴雷特已经在他的日常工作中练习了所有这些东西多年 - Postgres，D3，GIS，所有这一切。这本书的知识是现实世界，辛苦赚来的！“
- 从前言Obie Fernandez
数据可视化工具包是您可视化数据的动手实用且全面的指导。您将学习如何使用Rails，jQuery，D3，Leaflet，PostgreSQL和PostGIS，创建美丽的可视化和地图，使您的数据成为一个声音，并使其“跳舞”。
Barrett Clark通过现实世界的问题和专门开发的示例来讲解您所需要的各种技术，以产生令人惊叹的有效可视化效果。您将从绝对基础转向深度潜水，掌握各种可视化，并发现何时使用它们。一路上，您将使用实际的房地产，天气和旅游数据集构建三个始于终点的可视化应用程序。
Clark解决数据可视化的每个组件: 您的数据，数据库，应用程序服务器，可视化库等。他解释数据转换;在JavaScript，Ruby和SQL中提供专家技术;并阐述与描述性统计和地理空间数据相关的关键概念。在整个过程中，一切都是针对一个目标: 帮助您切断杂乱，让您的数据告诉所有可能的事情。
本指南将帮助您
探索并了解数据可视化技术栈
掌握导入数据的思考过程和步骤
以可用，可靠的形式提取，转换和加载数据
处理斑点数据或不符合图表所期望的数据
使用D3构建饼图和条形图，散点图和箱子图等
有效地处理时间序列数据
调整Ruby和SQL以优化大型数据集的性能
在Rails中使用原始SQL: 窗口函数，子查询和公用表表达式
构建和弦图和时间序列聚合
使用单独的数据库或模式来报告数据库
通过地理空间SQL查询集成地理数据
用Leaflet和Rails构建地图
查询地理空间数据“Rails方式”和“原始SQL方式”
目录
第一部分ActiveRecord和D3
第1章D3和Rails
第2章使用ActiveRecord和D3转换数据
第3章使用时间序列数据
第4章使用大型数据集
第二部分在Rails中使用SQL
第5章窗口函数，子查询和公用表表达式
第六章和弦图
第7章Postgres中的时间序列聚合
第8章使用单独的报告数据库
第三部分地理空间轨道
第9章使用Rails中的地理空间数据
第10章使用传单和轨迹制作地图
第11章查询地理空间数据
附录A Ruby和Rails设置
附录B简介Postgres概述
附录C SQL Join概述