It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

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

Your browser does not support HTML5 and the Video tag. Please use the download links above.

About

SQL Bits was started by a group of individuals that are passionate about the SQL Server product suite.
There is a breadth of knowledge in the SQL Community that will benefit everyone in the community.
We want to spread that knowledge.

We all work with the SQL community, some of us for many years and have all been given the MVP award by Microsoft