Download - Power pivot in Sharepoint Introduction
PowerPivot in Sharepoint
Jen Stirrup [email protected] / copperblueconsulting.com
Agenda
• PowerPivot – What is it?• Getting the best out of PowerPivot in
Sharepoint• Using PowerPivot as a source to
visualise your data– Tips and Tricks!
PowerPivot Sample Visualisation
PowerPivot Services in Sharepoint
PowerPivot Services in Sharepoint
PowerPivot Services in Sharepoint
PowerPivot Mash Up Data Sources
Text
PowerPivot as a Source
PowerPivot as a Source
PowerPivot as a Source
PerformancePoint
PowerPivot Demos
• Arbitrary Time Intelligence – Some Gotchas!
• More detail on Mash Up• Useful DAX– Replace– Bypassing Filters with CALCULATE– Dates Examples – potential pitfalls
Advertising Excel goodness!
• RSS Feeds• Alert Me on document library• Sent a link
PowerPivot
• Any questions?