BI capabilities in Excel, SharePoint Online, and Power BI for Office 365

 

 

 

Excel 2013 offers lots of business intelligence (BI) capabilities to help you explore and analyze data. Basic features are supported in SharePoint Online, and advanced capabilities are available in Power BI for Office 365. Read this article for an overview of the BI features that you can use in Power BI for Office 365, Excel, and SharePoint Online.

 

BI capabilities in Power BI for Office 365

Power BI for Office 365 is a self-service BI solution for Office 365 customers. By using Power BI for Office 365, people can easily discover, analyze, and share data through Excel and SharePoint Online, and across different devices. Key capabilities in Power BI for Office 365 include the following:

 

Feature Name	Description	Resources
Power Query	This is a new add-in for Excel that you can use to find and connect to data sources. You can use Power Query to combine data from different data sources, clean and transform the data, and then create custom views.	Introduction to Microsoft Power Query for Excel
Power Pivot	Power Pivot makes it easy to create a powerful but efficient Data Model in Excel. The Data Model can serve as a data source for charts, tables, and Power View sheets.	PowerPivot: Powerful data analysis and data modeling in Excel
Power View	You can use Power View to create interactive views, reports, scorecards, and dashboards.	Power View: Explore, visualize, and present your data
Power Map	This is a new add-in for Excel that makes it easy to create interactive visualizations on a three-dimensional (3D) globe.	Power Map documentation
Power BI for Office 365 sites	This is an application that transforms a basic SharePoint site into a robust, dynamic way to view and share Excel workbooks. Power BI sites on Power BI for Office 365 also provides people with an easy way to access all the BI capabilities that are included in Power BI for Office 365.	Power BI for Office 365 sites
Power BI for Windows mobile application	This is an application that lets people view and interact with Excel workbooks on a Windows tablet.	Power BI for Windows mobile application
Support for larger workbooks	Certain file size limits apply to workbooks in Office 365 that affect whether a workbook can be viewed in a browser window. Power BI for Office 365 supports larger workbooks than what’s available in SharePoint Online alone. For more information, see File size limits for workbooks in SharePoint Online.	File size limits for workbooks in SharePoint Online

These are just some of the great, new features in Power BI for Office 365. Additional BI capabilities are included. For a more detailed overview, see Getting Started with Power BI for Office 365.

 

Copy Right:  http://technet.microsoft.com/es-es/library/dn198235.aspx