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
MP4 Video Low 104 MB