It depends in part on your sets, but here are some general ideas I tend to use.
I'll go uptempo if I think I have a noteworthy advantage in both ATH and SPD, if I feel I have a bigger advantage in the second string than I do with the starting 5 when comparing myself to my opponent, or if I run my team 12 deep and my opponent has 2 or more players who will be redshirted/academically ineligible/walk ons/injured on his roster to try and gain a fatigue/foul advantage in the second half. And you can pretty much reverse those to see when I'll run a slowdown.
On a more broad level, you want to run uptempo when you think you have the superior team in an effort to get more possessions (which will minimize the variance of the random number generations) and to slow down when you think you're at a disadvantage (in the hope you catch a few breaks and the RNG's go your way...).