Who’s is a contraction for who is or who has.
Whose is a possessive form of who that’s used as an adjective.
Who’s (who is) going to the concert?
Who’s (who has) been to this venue before?
Whose car are we taking?
I wonder whose coat this is.