when do you start thinking about a data warehouse?

hey everyone, i've been thinking about our growing data needs. we're currently relying on our production databases for all reporting, and it's starting to impact performance during peak hours. i've seen data warehouses mentioned as a solution, but when is it really the right time to invest in setting one up? is it purely about query performance, or are there other factors like data volume, complexity, or specific analytical needs that signal it's time to make the switch