It really started to come together for me when I used my own data too. The data in AW and Contoso is a little too perfect. That data is great for getting used SSAS but that is about it.

I also found that it helps to have a typical business question in mind when designing your cube. You want it flexible enough that you can answer the typical business questions plus some value added points (This way you can justify the need for the cube). If you try to pull in your entire universe of data and then filter it down, you will end up creating a huge mess. A lot of BI projects fail because the tool doesn't answer the important questions. it sounds like you already have an idea of what you want your cube to do though. +