Excel 2013 Analytics

Excel is “The” analytical tool in Microsoft suite for advanced analysts. You can use it as a SQL Server Analysis Services client or as a standalone analytical engine. With Excel, you can analyze both, relational and unstructured big data. With PowerPivot, Excel becomes a single-user Analysis Services in tabular mode. The performance of your analytical processing is amazing. With Power View inside Excel, you can create ad-hoc reports on the tabular model with minimal effort. With Data Mining Add-in, you can perform even the most advanced analyzes on your Excel data. This session introduces Excel 2013 and 2010 business intelligence capabilities.
Presented by Dejan Sarka at SQLBits XI
  • Downloads
  • SpeakerBIO

    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 thirteen 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