In the previous article I told you why an analysts needs SQL. Obviously it is too hard to make high-grade data analysis only with the help of SQL. We always want to keep some temporary data and previous results. Also to work with them. So, main appropriation of the SQL is data aggregation at the large scale of data.

Lately, some people said that SQL has nothing common with the analysis. Are they right? Nope.

One of the groundbreaking innovations in the last version of Microsoft Excel 2010/2013 is the possibility of using sparklines – minicharts placed within cells and demonstrating the dynamics of numeric data.

We are going to see how the regression analysis can help you to develop a predictive model.