Official News from Microsoft’s Information Platform
In Microsoft SQL Server 2008 R2 we introduced PowerPivot: A self-service Business Intelligence experience that enables information workers to create their own self-service BI solutions and facilitating sharing and collaboration within the familiar environment of Excel and SharePoint. With the release of Microsoft SQL Server code-named “Denali” we bring the simplicity and power of the PowerPivot technologies to corporate BI, greatly expanding the reach of the Microsoft BI semantic model. As of CTP3 of Denali we are delivering a wealth of new modeling features to the Microsoft BI semantic model, which will surface in both in PowerPivot and the Tabular Project type within the BI Development Studio. The video below gives you a brief overview of 3 key features that we have introduced with the CTP3: The new Diagram View, user defined hierarchies and perspectives.
In addition to the 3 features discussed above you will find a significant number of other new features to explore if you go download the CTP3 of PowerPivot for Excel. Other features include:
Other features delivered with previous CTPs include: KPI’s, ability to mark a table as a date table, multiple DAX functions, change of data type for calculated columns, persistence of measure formatting, descriptions, alphabetical display of fields in the Field List.
Download SQL Server Code Name “Denali” CTP3 from: www.microsoft.com/denali Download SQL Server "Denali" PowerPivot for Excel at: http://www.microsoft.com/download/en/details.aspx?id=26721 Enjoy your modeling using CTP3! Julie Strauss Senior Program Manager Analysis Services Team