PowerPivot for SharePoint is the new BI engine from Microsoft and opens the gates for Self-Service BI, i.e. the capability, for users, to create their own BI data models. Users can generate their own reports with PowerPivot for Excel 2010 and then upload them to the SharePoint server where, if installed, the server version of PowerPivot for SharePoint takes care of all processing and rendering of the report.

During the SharePoint conference Alberto Ferrari, one of the authors of Microsoft PowerPivot for Excel 2010: give your data meaning will provide a session showing what kind of reports users will be able to develop using some advanced DAX techniques, taking examples from real world scenarios and looking at different DAX solutions.

Many other examples of DAX usage, to better understand PowerPivot capabilities can be found on the speaker's blog.