My Power Pivot data model consists of a number of linked Excel tables, of which tblEvents is the main one. It has the following columns:
Location, related to the column "LocationName" in tblLocations
EventType, related to the column "EventType" in tblEventTypes
Client, related to...