The phrase can be used for both significant and small positive events. Its usage depends on the context and the level of excitement the speaker wants to convey.