SQLBits 2012

Business Intelligence with Excel 2010

Most of us use Excel in our Daily work, but are you familiar with the Business Intelligence features in Excel? In this session we'll look at some of the most common and useful BI features in Excel 2010 and discuss limitations and best practices.
Most of us use Excel in our Daily work, but are you familiar with the Business Intelligence features in Excel? In this session we'll have a look at some of the most common BI features in Excel 2010 like: Pivot Tables and Pivot Graphs, combining these with Slicers, Dimension Search, Conditional Formatting and financial reporting with asymmetric Sets. You will learn about the limitations and best practices when it comes to use Excel as a BI analysis tool. And finally we'll see how you can build advanced free-format Excel reports using Cube functions.