Ralph Kimball's methodology stands the test of time because it aligns the data model with how the business thinks. Facts represent events, dimensions represent context.
The most important decision
Define the grain of the fact table before anything else. Always choosing the most atomic level available avoids costly rebuilds later.
Denormalized dimensions, surrogate keys and a complete date table round out the foundation of a solid model.
