My father asked me who had visited yesterday.

Literal

Father [topic-は] me [to-に], yesterday visited [topic-は] who [question-なのか] asked.

昨日訪ねてきたのは誰なのか — an embedded wh-question ('who was it that came yesterday?'). The のは...なのか construction frames the question.