Business Intelligence with Excel 2010SQLBits X – 2012 – _LondonMost 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.Se session her

Analyzing SSAS Data with Excel (PASS membership is required)PASS Summit 2012 – SeattleAre you familiar with all the Business Intelligence features in Excel that you can use when analyzing data from an Analysis Services cube? In this session, we’ll look at some of the most common BI features in Excel 2010, including Pivot Tables and Pivot Graphs, combining these with Slicers, Dimension Search, Conditional Formatting, and financial reporting with asymmetric sets. You will also learn about the limitations and best practices when it comes to using Excel as a BI analysis tool. And finally we’ll see how you can build advanced free-format Excel reports using Cube functions.Se session her

Writeback-Here Comes the SunSQLBits 9 – 2011 – LiverpoolWith Excel 2010 it is finally possible to modify data in a SSAS cube, without using any macros or third party add-ins. This opens for a lot of common business scenarios like budgeting and planning directly from Excel 2010.Se session her