SQL Server 2012 database Engine has so many business intelligence improvements that it might become your primary analytical database system. However, in order to get the maximum out of these features, you need to learn how to properly use them. This in-depth session shows some extremely efficient statistical queries that use the new Window functions and are optimized through proper algorithm. In the session, the formulas and usage of those statistical procedures are explained as well. This session is useful not only for BI developers; database and other developers can successfully learn how to write efficient queries as well.Finally, it is worth mentioning that the Data Scientist role is the big IT role in the 21st century. A data scientist should know statistics and programming. This session prepares you for that role.

(no tags)