Following on from our recent blog post on Power BI within Office 365 Education, we have had a number of questions via both the blog and Twitter seeking some additional information on how Power BI can help you take advantage of the data within your institution, big and small.
For those that missed our previous post, Power BI for Office 365 is a collection of features and services that enable you to visualise data, share discoveries and collaborate in intuitive new ways. Power BI works seamlessly with Excel and allows you to create compelling content, data models and visualisations and then share and collaborate around those insights with your colleagues, teams and study groups.
More specifically, features within Power BI that extend the data-specific capabilities of Excel 2013 include the following:
Analyse data with Excel: Easily discover and access public and corporate data
Power Query, a feature of Excel, enables you to more easily discover, combine, and transform data from multiple data sources with the familiarity of Excel
Visualize and explore
Power View and Power Map, features of Excel, allow you to create interactive data visualizations to explore and uncover insights and present findings.
Create powerful data models
Power Pivot, a feature of Excel, provides powerful analytical modelling. Data is processed in-memory allowing you to work quickly with data volumes in excess of 100 million rows, in split second times.
Share and Collaborate with Power BI for Office 365
Enable anyone to quickly create a collaborative BI site to share data and insights with Power BI.
Keep reports up to date with data refresh
Keep your reports up to date by scheduling when the data should refresh. The Data Management Gateway allows reports that have been saved to the cloud to connect back to on-premises data sources to refresh data.
Manage data queries for the team
With Power BI people can share not only workbooks but also the queries they create using Power Query in Excel. This allows members of the team to build and manage data queries for others to use when creating their own reports.
Maintain a Data Catalog of searchable data
Your IT departments can now use the Data Catalog feature of Power BI to make it easier for everyone to find and connect to corporate data. Searching for data with Power Query in Excel will return accessible corporate data.
Ask questions of your data in natural language
With the Q&A feature of Power BI people can type questions they have of the data in natural language. The system will interpret the question and present answers in the form of interactive visualizations.
Stay connected with mobile access to your reports
Mobile access to reports in Power BI is provided through new HTML5 support and through the Power BI mobile app.
To learn more, and request a free trial, visit out Power BI microsite for more information.
Additionally, if you are looking to get up and running our 'Getting Started Guide' can be viewed/downloaded below.