If there is one product in the MS BI stack that is worth upgrading as soon as possible then it is PowerPivot. The 2012 version offers lots of new features such as: Lots of new features:Diagram View (at last)More date intelligenceBetter sortingHierarchy supportBinary ColumnsReporting properties to help PowerView describe dataKPI supportPerspectivesAbility to Import into full … Continue reading Gotchas on PowerPivot for SharePoint to 2012 RC0
Tag: PowerPivot
By Bob Duffy6. April 2011 11:43 As mentioned previously (http://blogs.prodata.ie/post/Using-MAP-Tool-and-Excel-to-Analyse-IO-for-SQL-Consolidation-Part-I-e28093-basic-distribution.aspx), the MAP tool has a nice database containing all your disk IOPS data and this is nicely contained in a single table called “performance_disk” We can use PowerPivot to analyse the IOPs form different perspective and start to apply some logic such as: excluding non-business hours, … Continue reading Using MAP Tool to Analyse IO for SQL Consolidation. Part II – Using Power Pivot