The following presentation goes over how you can automate the data collection for benchmarking wait statistics, disk latency, performance counters and do analytics with PowerPivot.
LINKS
Dallas BI Edition SQL Saturday (Free conference just on PowerBI and other BI features)
https://www.sqlsaturday.com/396/eventhome.aspx
Channel 9 PowerPivot Free Videos -> https://channel9.msdn.com/Search?term=PowerPivot#ch9Search
Channel 9 PowerBI Free Videos -> https://channel9.msdn.com/Search?term=PowerBI#ch9Search&lang-en=en
SQLPASS Virtual Chapters -> http://www.sqlpass.org/PASSChapters/VirtualChapters.aspx
Business Analytics Virtual Chapter -> http://bavc.sqlpass.org/
Business Intelligence Virtual Chapter -> http://bi.sqlpass.org/
Austin SQL Server User Group -> http://cactuss.org/
San Antonio SQL Server User Group -> http://www.salssa.com/