Joining together

Location data, such as the street, city, zip code, and state, dominate the information that DataCo has sent you regarding their customers. This data is all contained in different columns. Although some more specific fields, like street and zip code, would be useful for marketing or billing, it doesn't necessarily need to be split out. Would you conduct an analysis involving the customer's zip code or street name? There is more work to do on the Customers sheet!

If you lost progress, close any open reports and load 2_2_joining_together.xlsx from the Workbooks folder. If a message appears saying "Security Warning - External Data Connections have been disabled", click on Enable Content and continue.