Analyzing SSAS Data with Excel [BID-211]

Stephan Stoltze
75 minutes
Analyze
BI Information Delivery
Analyst, BI/Analytics Practitioner
200
Are 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.
General knowledge of Excel 2010.

cage-aids
cage-aids
cage-aids
cage-aids