Demo to Model and Analyse data in Excel using Power BI (Movie Ratings)

Use case: To Analyse data collected in survey conducted for movie ratings

Part 1: Pulling, cleaning data from source files using Power Query




Part 2: Creating model and visualizations using Power Pivot and Power View

Microsoft Adds Connectivity for SAP BusinessObjects to Power BI for Office 365

Microsoft added SAP BusinessObjects as new dataSource!!!

With this new solution, users can now seamlessly connect to SAP BusinessObjects BI Universes as another supported data source in Power Query for Excel, enabling them to access and analyze data across the enterprise and share their data and insights in the cloud and any device through Power BI.

Source: Power BI MSDN Blog.

More Details to come soon!!!!

Introduction to Power BI

Power BI for Office 365 is Microsoft's cloud-based business intelligence (BI) solution that works from within Excel and Office 365 to analyse and visualize data in a self-service way

Components of Power BI:

Excel 2013:

    •Power Query – easily connect to data from public and corporate                                         datasources, transform data and share queries

    •Power Pivot  – create a sophisticated Data Model directly in Excel

    •Power View – create reports and analytical views with interactive data                                visualizations

    •Power Map – visual tool for geospatially based data analysis

   

Office 365:

    •Power BI Sites – share, view, and interact with reports

    •Power BI Q&A – use queries to find, explore, and report over your data

    •Power BI Windows APP– view reports on the go, with the Power BI app