There are many functions to help you slice-and-dice your data and obtain the views of the data and associated analyses that you require.
Pivoting your data enables you to examine different influences. You can hide portions of data, manipulate a smaller data set, and then show all data again. You can also drill down through the data to transaction level. The Breakback function enables you to try various values to see the effect of changing, say, a projected sales figure. Those values can be held, using the Hold function. And, of course, you can Filter and Sort your data.
These links explain each function in detail alongside explanations of common tools such as Move, Search, etc.