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!
Similarly, Power View enables users to create rapid and quick visualizations of data using charts and graphs that are cohesively linked and tied together.
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.
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.
To learn more about this great Microsoft Power BI Suite, go here: http://www.office.com/powerbi