How would you handle a practical scenario involving Query Optimization in SQL Server?

A dashboard query scans millions of rows; explain how you would investigate filters, indexes, aggregation strategy, and whether precomputation is warranted.