Insight can only be raised by picking the best/most insightful option in certain conversations. It is the most tricksy stat. <3
It can be raised several ways: picking specific dialogue options, receiving gifts from others, and under your Free time to-do list - select Ask someone for skill advice - and then select Practice dancing with Jasper.
Most other skills can be raised through exploring the castle, asking someone for skill advice, or self improvement.