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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s