Platinum Sponsor

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.
Presented by Stephan Stoltze at SQLBits X
Tags (no tags)
  • Downloads
    Slide deck available Slide Deck 2.1 MB
    Samples available Demo Code 191 KB
    Video available MP4 Video Med 111 MB
    Video available MP4 Video HD 472 MB
  • SpeakerBIO
    sst_small.jpg
    Stephan has more than 10 years experience with Microsoft BI Consultancy and Training and works as a Principal Consultant at Stoltze IT. He is the founder and coordinator of the Danish Microsoft BI Community and has been a speaker at various Microsoft BI events and webcasts. You can follow Stephan at @sstoltze or read his blog http://sstoltze.wordpress.com
    http://sstoltze.wordpress.com/ http://sstoltze.wordpress.com/feed/
  • Video
    The video is not available to view online.
  • Session Files Explorer
    •  Business_Intelligence_with_Excel_2010
    Could not find a part of the path '\\sqlbits01\DENALI\SQLBitsFiles\'.