Words mean (to you) whatever you think they mean. Just go with the "meaning" that suits you best.
Or look up "nerd" on Google, and go with their definition of the term.
I think, Nigel, that we could go with "someone who was 'great', but also a 'nerd'". I don't see why not.