4. Maps

4.1.  Startwith basic map of every facility’s location

First, move the latitude and longitude measures (the onesthat’re part of the dataset, NOT the generated fields) up to dimensions. Thesecolumns are really geographic ID variables, so they’re dimensions. Create a new worksheet.

Then, put the latitude and longitude dimensions onto theRows and Columns shelves. We'll also need to add Facility Name to Marks -> Detail for the facilities to show up.


We'll want to exclude those null values, as well.

4.2.  Addcolor to distinguish between industry groups 

Then, let’s drag the industry groups dimension to MarkColor, so that we can determine the facility type:


4.3.  Addsize to indicate total GHG emissions

Finally, drag the “reported CO2e emissions” measure to MarkSize. That’s a pretty cool graph. Can you describe what each point is?[placement = individual facility in database. Color = industry type. Mark size= amount of emissions]

This is a cool map, but what if we only want to view oneindustry type, or one state, or only facilities above X number of GHGemissions? We’d need to filter the data. Let’s start playing with the Filtersshelf.

1.1.  Addsome filters, so we can look at only one industry, only one region, only onestate. [7 minutes]



First, let’s drag our Regions dimension to the Filtersshelf:




We’ll get this popup box, asking for our initial filter.Let’s go ahead and include everything, so the map won’t change at first.



Nothing has changed quite yet, we have one more step.


Now click on regions in the Filters shelf, and select “Show Filter”







This gives us a box on the right of the map that allows us todynamically filter data.


We can also click on the drop-down arrow on that header tochange how the filter is displayed. Let's change it to a dropdown menu  (multiple selection):

Using the same procedure, add filters for “State” and“Industry Group”, and edit the State filter to “only show relevant values”.That means that, say only the Northwest region is chosen. Then, only stateswithin that region will show up as options within the “state” filter.


We’ve finally got a good map to play with. And we can dothings like look at the Power plant industry type, in the Southeast, in onlyFlorida and South Carolina:


Next, we can start looking into power plants more closely.

SUBPAGES (10): 1. INTRODUCTION 2. CREATING 2-D GRAPHS 3. 3-D GRAPHS AND MORE! 4. MAPS 5. MERGE IN EIA POWER PLANT DATA 6. DOES THE AMOUNT OF ELECTRICITY GENERATED INFLUENCE GHG EMISSIONS? 7. CALCULATED FIELDS 7. CALCULATED FIELDS 8. TRI DATASET & TABLE CALCULATIONS 9. DASHBOARDS