Give everyone in your organization a powerful new way to work with data.
Empower users with a complete self-service business intelligence (BI) solution delivered through Excel and Power BI for Office 365. Excel provides data discovery, analysis, and visualization capabilities that help users identify deeper business insights from their data. Power BI for Office 365 provides an easy-to-deploy cloud-based BI environment for users to share, collaborate, and access data and reports from anywhere.
Power Query in Excel enables business users to more easily search, discover, combine and transform data from multiple data sources that are both inside and outside the company.
Power Pivot in Excel enables business users to create powerful analytical models, and in-memory capabilities allow users to manipulate and work with large volumes of data quickly.
Power View and Power Map in Excel provide visual data exploration with ad-hoc interactive reporting and geospatial analysis to enable users to uncover insights and present findings.
Power BI for Office 365 allows business users to quickly create BI sites for teams to share reports and data sets. Larger workbook viewing is now supported (up to 250MB) which allows users to view and interact with larger reports through their browser.
With the data catalog in Power BI for Office 365, business users can share not only their workbooks, but also the original data queries they created in Excel, to maintain data views for colleagues to consume in their own reports.
With Q&A, users type ad-hoc questions and the system responds with answers in the form of interactive charts and graphs. The experience is immediate and uses natural language query to help interpret the semantics of questions being asked.
With Power BI for Office 365, IT departments can register corporate data with the Data Catalog search engine, making corporate data available in Power Query for Excel, and provide an easier data search experience for business users.
Mobile BI access to reports in Power BI for Office 365 is provided through new HTML5 support and a native mobile application for Windows 8 tablets.