In Shakespeare, Hamlet's fatal flaw?

I know that Hamlet's fatal flaw is that he over thinks many situation, but what makes him a tragic hero? Like what does he do to remind us all that while he had his flaws he also had potential for greatness?