I think one of the closest end to end examples you're going to find is probably the AdventureWorks databases and cubes that can be downloaded from Microsoft.
A lot of the learning material uses these databases.
Can't think of any other examples that are as "complete"
I will try and find some links for you