Advanced Business Intelligence Solutions Using Microsoft Excel + Excel Services

Almost everyone is using Excel 2010 so it looks like Weston is bit behind in this area.

Interesting Things in Excel 2010:
Name sets in Pivot Table options.
MDX is the query language for BI or cubes.
What if analysis
Slicers - get a much richer analysis. These are enhanced filters and can
Can use VLOOKUP in formulas
Have added more features to Pivot tables.
Spark Lines are small trend lines that can be added to cells in Excel.

Excel Services:
You can create dashboards that are workbooks and can be exported to SharePoint and have the data be live against the warehouse or cube.
Can use Web Parts to help with dashboard and you might need to add code.

Bottom-line, there needs to be more research to learn how to perform this function. My guess is that Srikanth and Bob already have some knowledge of how to do some of this. Main point is that these dashboards could need a more technical asset to do more of the advanced BI features, but there does seem to be many things a less technical resource could do. Might be the solution for the Jerry Strub's of the world??

Location:TechEd 2011