which algorithm to apply, that is depending on your goal and also the data type(Continuous or discrete)
There are many statistical concepts involved, it is different from BI. Modeling can be used to project and so on.
But you can use SQL to do some pre-process data.