High Performance Statistical Queries

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.
Presented by Dejan Sarka at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    dejan_sarka.jpg

    Dejan Sarka, MCT and SQL Server MVP, is an independent trainer and consultant that focuses on development of database & business intelligence applications.  Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or coauthor of twelve books about databases and SQL Server. Dejan Sarka also developed many courses and seminars for Microsoft, SolidQ and Pluralsight.

    http://sqlblog.com/blogs/dejan_sarka/default.aspx http://sqlblog.com/blogs/dejan_sarka/rss.aspx
  • Video
    The video is not available to view online.