• Christopher Adamson's Star Schema: The Complete Reference is really good. It's database agnostic, but he does a really good job of explaining concepts like Slowly Changing Dimensions and how to model them correctly. (I have Kimball's book, too, but I liked the description in Adamson's book better.)

    Then you just have to practice, practice, practice.