With both Excel and Power BI for Office 365, you can give everyone in your organization a powerful new way to work with data. In Excel, you can now discover, analyze, and visualize data like never before to find valuable business insights. With Power BI for Office 365 you can easily deploy a cloud-based BI environment for users to share insights, collaborate and access reports, from anywhere on any device.
Using Excel and Power BI, we help you take the next step to discover, analyze and visualize your data effectively. We enhance your already built excel reports with strong features making your reports interactive and dynamic.
These features are part of the familiar Excel environment, and extend its functionality to all sorts of cool data-specific capabilities. We help you to create content (such as workbooks, data models, and visualizations) that can be published and shared in Power BI for Office 365. Some of these BI features in Excel have been available before, some are new, but each is now integrated into Excel.
These client tools are:
We help you discover and connect to data from public and corporate data sources. This includes new data search capabilities, as well as capabilities to easily transform and merge data from multiple data sources so that you can continue to analyze it in Excel.
We help you create sophisticated data models with that data in Excel by creating relationships, custom measures, hierarchies, and KPIs. Power Pivot models run in-memory so that users can analyze 100s of millions of rows of data with lightning fast performance.
We create reports and analytical views through interactive charts and graphs that help you explore and present your data visually in Excel.
We provide you with geo-reports where you can explore and navigate geospatial data on a 3D map experience in Excel.
Insights and visualizations are better when shared. Through Power BI sites, we make insights available to everyone in your organization in a secured fashion, enabling your users to access the reports anywhere anytime:
This is the heart of your collaborative Power BI experience. We create Power BI sites for your team to share and view reports. Larger workbook viewing is also supported (up to 250MB) so that users can view and interact with larger workbooks through the browser.
With the data management features of Power BI, not only can you share your own query-creating genius, you can find other queries easily, too. Youre collaborating from within Excel, and sharing it online.
See the latest reports posted to your Power BI site from a rich, immersive app on your mobile device.