Exploring Manhattan with Excel Power Map • ©[blogs.office.com]
New York is an iconic city with a rich history of innovation. I have a lot of family in New York and grew up visiting the city. Now that I’m living in Seattle, thousands of miles away, I don’t get to visit very often. However, I thought it might be fun to see if I could explore New York from the comfort of my desk using Excel. Through a little Internet searching, I discovered New York City’s “PLUTO” dataset. Created by the Department of City Planning, the PLUTO dataset includes information on every building in the city—more than 500,000 in total. I downloaded the dataset as CSV files and using Power Query for Excel, imported the data directly into Excel. I focused on the data file containing the borough of Manhattan as I’m most familiar with it. The dataset has a separate row for each building complex in the city and about 80 columns of information for each one.