Data Visualization Toolkit

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 stackMaster the thought process and steps involved in importing dataExtract, transform, and load data in usable, reliable formHandle spotty data, or data that doesn't line up with what your chart expectsUse D3 to build pie and bar charts, scatter and box plots, and moreWork effectively with time-series dataTweak Ruby and SQL to optimize performance with large datasetsUse raw SQL in Rails: window functions, subqueries, and common table expressionsBuild chord diagrams and time-series aggregatesUse separate databases or schema for reporting databasesIntegrate geographical data via geospatial SQL queriesConstruct maps with Leaflet and RailsQuery geospatial data the "Rails way" and the "raw SQL way"