Skip to Main Content
Data Analysis Using SQL and Excel, 2nd Edition
book

Data Analysis Using SQL and Excel, 2nd Edition

by Gordon S. Linoff
December 2015
Beginner to intermediate content levelBeginner to intermediate
792 pages
20h 55m
English
Wiley
Content preview from Data Analysis Using SQL and Excel, 2nd Edition

CHAPTER 4 Where Is It All Happening? Location, Location, Location

From foreign policy to politics to real estate and retailing, many would agree with Napoleon’s sentiment that “geography is destiny.” Where customers reside and the attributes of that area are among customers’ most informative characteristics: east coast, west coast, or in-between? Red state or blue state? Urban, rural, or suburban? Sunbelt or snowbelt? Good school district or retirement community? Geography is important.

Incorporating this rich source of information into data analysis poses some challenges. One is geocoding, the process of identifying the names of physically locations. This includes latitude and longitude, as well as the identification of multiple geographic areas, such as zip code, county, state, and country. This information makes it possible to determine who are neighbors and who are not.

Another challenge is incorporating the wealth of information about geographic areas. In the United States, the Census Bureau provides demographic and economic information about various levels of geography. The Bureau divides the country into very specific geographic pieces, such as census tracts and block groups and zip code tabulation areas (ZCTAs), which correspond closely but not exactly to zip codes. The Bureau then summarizes information for these areas, information such as the number of households, the median household income, and the percent of housing units that use solar heat. The best thing about ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Data Analysis Using SQL and Excel

Data Analysis Using SQL and Excel

Gordon S. Linoff
SQL for Data Analysis

SQL for Data Analysis

Cathy Tanimura

Publisher Resources

ISBN: 9781119021438Purchase book