Advanced Business Intelligence with Microsoft Excel and Excel Services
Play Advanced Business Intelligence with Microsoft Excel and Excel Services
This session covers the new advanced capabilities in Microsoft Excel 2010 to help you create detailed analytical reports. We cover new capabilities, such as how to use dynamic sets leveraging the content in Analysis Services, using write-back to provide closed loop analysis, and taking advantage of the new calc-member filtering and slicers with cube functions. We also show you how to share this in Excel Services to create a real-time view and use the new REST API to empower your users.