Power BI is a cloud based data analysis, which can be used for reporting and data analysis from wide range of data source. Power BI is simple and user friendly enough that business analysts and power users can work with it and get benefits of it. On the other hand Power BI is powerful and mature enough that can be used in enterprise systems by BI developers for complex data mash-up and modelling scenarios. Power BI offers basic data wrangling capabilities similar to Excel's Power Query. It also lets you create interactive visualizations, reports and dashboards with a few clicks or drag-and-drops; type natural-language questions about your data on a dashboard; and handle files that are too large for Excel.
Power BI, this big umbrella is not just a visualization tool such as Tableau, it is not just a self-service data analysis tool such as PivotTable and PivotChart in Excel, it is not just a cloud based tool for data analysis. Power BI is combination of all of those, and it is much more. With Power BI you can connect to many data sources (wide range of data sources supported, and more data sources add to the list every month). You can mash up the data as you want with a very powerful data mash up engine. You can model the data, build your star schema, or add measures and calculated columns with an In-Memory super fast engine. You can visualize data with great range of data visualization elements and customize it to tell the story behind the data. You can publish your dashboard and visualization tool in cloud and share it to those who you want. You can work with On-premises as well as Azure/cloud based data sources. and believe me there are much more things that you can do with Power BI which you can’t do with other products easily.
Hybrid deployment support - This feature provides built-in connectors that allow Power BI tools to connect with a number of different data sources from Microsoft, Salesforceand other vendors.
Quick Insights - This feature allows users to create subsets of data and automatically apply analytics to that information.
Cortana integration - This feature, which is especially popular on mobile devices, allows users to verbally query data using natural language and access results, using Cortana, Microsoft's digital assistant.
Customization - This feature allows developers to change the appearance of default visualization and reporting tools and import new tools into the platform.
APIs for integration - This feature provides developers with sample code and APIs for embedding the Power BI dashboard in other software products.