New self-service features with Power BI for Office 365 #WPC13 #BI

Yesterday, we talked about the bundled and rebranded suite of Power BI Office 365 and Excel 2013 tools that was announced at the Microsoft Worldwide Partner Conference 2013. This suite provides self-service Business Intelligence in the Enterprise. Today, we’ll discuss some of the new features that further simplify self-service Data Mining.

The most exciting new Power BI feature is the new Q&A query functionality, which enables natural language processing.  Any non-technical, non-power user can ask simple questions and get immediate results in the form of easy-to-understand charts or graphs.  Non-technical users don’t have to learn structured SQL (T-SQL), chase down an analyst or data scientist, or even require knowledge of the great new Power BI tools, Power Query or Power Pivot to get their results. They can simply ask, “What was my sales volume this year?”  or, “How did my sales do last quarter?” A table or chart pops up showing the data they need to see to get their questions answered.

Power BI

Mobile is all the RAGE!!  Another new Power BI feature that we’re really excited about is the Connected (Mobile) BI experience.  Until now, Power View created very dynamic and rich visualizations using Silverlight, which was only available on Intel-based Windows and Mac OS platforms. With Power BI on Office 365 and SharePoint, Power View now renders charts, graphs and visualizations with HTML5. That means where ever you go, as long as you have a smartphone, tablet or any of the variety of other mobile devices, you can get to your enterprise KPIs.  On vacation in Maui without your laptop? Not a problem with Power BI!

Source: http://blogs.office.com/b/office-news/archive/2013/07/08/announcing-power-bi-for-office-365.aspx

And last, but not least, featuring Business Intelligence in the cloud!  Power BI Sites is a new Business Intelligence collaboration platform in the cloud, which utilizes Office 365 and SharePoint.  With Power BI Sites, you’ll get workspaces in Office 365 that enable sharing and collaboration of data and insights with your customers, colleagues and employees.  Easily keep your team up to date with the latest charts and graphs as data refreshes from multiple data sources.

To learn more about Power BI for Office 365, register for the preview at Microsoft: http://www.office.com/powerbi

Microsoft Announces Power BI for Office 365 at #WPC13

wpc

Big Data and self-service Business Intelligence are all the rage at the Microsoft 2013 Worldwide Partner Conference (WPC).  The big announcement to come out of the WPC is a suite of self-service Business Intelligence tools for Office 365 and Excel 2013 called Power BI. The suite of tools includes the following:

  • Power Pivot – rapid deployment of reporting data models.
  • Power View – enables interactive and dynamic visualization of data through charts and graphics.
  • Power Map (formerly “GeoFlow”) – a tool for rich visualization of geographical location data on a map.
  • Power Query (formerly “Data Explorer”) – enables the quick import of data into Excel for transformation, analyzing and reporting.

Working together, these tools further enhance Excel to be one of the best and easiest to use self-service Business Intelligence tools in the marketplace today.

With Power Pivot, users can quickly build reporting data models without having to understand the deep intricacies of building data warehouses or KPI cubes. Power Pivot does it all for the user with a just few clicks of the mouse. Love that!

Power Pivot

Similarly, Power View enables users to create rapid and quick visualizations of data using charts and graphs that are cohesively linked and tied together.

Power View

With the increased use of smartphones and GPS data, more and more data points are geographic location-centric. Want to plot counts and metrics against a map? Not a problem with Power Map. Select your Excel table, identify your latitude and longitudinal data (or address, city, state, zip) and let Power Map do the heavy lifting.

Power Map

Do you have organization data that needs to be transformed and manipulated? Or do you not have data at all to chart or map? Not a problem with Power Query, which enables you to do quick online searches for publicly available data sets to load into Excel for transforming, analyzing and/or reporting.

Power Query

To learn more about this great Microsoft Power BI Suite, go here: http://www.office.com/powerbi