Professionals always have their preferences but ultimately it must be determined what fits the needs of the system. While a snowflake schema to a small degree can be more efficient. Ultimately, it boils down to the size of the fact tables but as many professionals would agree that this alone is not a significant argument. Star schema's simplicity is able to accommodate many designs due to the fact that it typically requires fewer joins to build and maintain the system. It just comes down to determining what fits your schema the best.

So how would you approach with method works best for your organization?