Extracting Netflix Data using PowerPivot

Today I played around with Netflix data after extracting it using PowerPivot for Excel addin.

I wasn't able to create a relationship between the entities Titles, Genres, People, TitleAudioFormats etc. The Titles data apparently contains duplicates in its TitleId column and the entities were missing the key attributes required for setting up a relationship.