![]() ![]() The feature matrix makes it very easy to filter Office 365 features by workload so you only see the BI-related ones:Īs you can see, the short answer is that you need either Office 365 E3 or E4, or SharePoint Online Plan 2 to get BI functionality. Although feature support information for Office 365 is on Technet here, the best place to start is Andrew Connell’s blog post and corresponding feature matrix that is viewable through (appropriately enough) the Excel Web App. Moving on to 2013 functionality in Office 365, and specifically BI in Sharepoint Online, things get more complicated. Luckily, Kasper has summarised what it does do in a blog post here, so I won’t repeat what he says. Office RT, which runs on Windows RT, has several limitations on its BI functionality: there’s no PowerPivot, Power View or Excel Data Model. On the server, the only edition of Sharepoint 2013 that has any BI functionality is Enterprise Edition there’s no BI functionality in Foundation or Standard Editions. So even if you’re not using Professional Plus you can still do some quite impressive BI stuff with PivotTables etc. You only need the PowerPivot addin, and therefore Professional Plus, if you want to use the PowerPivot Window to modify and extend your model (for example by adding calculated columns or KPIs). However there’s an important distinction to make: the xVelocity engine is now natively integrated into Excel 2013, and this functionality is called the Excel Data Model and is available in all desktop editions of Excel. ![]() ![]() But which editions of Office 2013 and Office 365 include the BI functionality, and how does Office 365 match up to plain old non-subscription Office 2013 for BI? It’s surprisingly hard to find out the answers…įor regular, non-subscription, Office 2013 on the desktop you need Office Professional Plus to use the PowerPivot addin or to use Power View in Excel. You’ve probably also read lots of blog posts by me and other writers talking about the cool new BI functionality in Office 2013 and Office 365. By now you’re probably aware that Office 2013 is in the process of being officially released, and that Office 365 is a very hot topic. ![]()
0 Comments
Leave a Reply. |