What is Power BI?
Power BI is a Data Visualization and Business Intelligence tool that converts data from different data sources to interactive dashboards and BI reports. Power BI suite provides multiple software, connector, and services – Power BI desktop, Power BI service based on Saas, and mobile Power BI apps available for different platforms. These set of services are used by business users to consume data and build BI reports.
The flow of work in Power BI
A common flow of work in Power BI begins in Power BI Desktop, where a report is created. That report is then published to the Power BI service, and then shared so users of Power BI can consume the information.
Power BI can be simple and fast – capable of creating quick insights from an Excel spreadsheet or a local database. But Power BI is also robust and enterprise-grade, ready for extensive modeling and real-time analytics, as well as custom development. So it can be your personal report and visualization tool, and can also serve as the analytics and decision engine behind group projects, divisions, or entire corporations.
Data types are organized in the following categories:
The All category includes all data connection types from all categories.
The File category provides the following data connections:
The Database category provides the following data connections:
SQL Server Database
SQL Server Analysis Services Database
IBM DB2 Database
IBM Informix database (Beta)
SAP HANA Database
SAP Business Warehouse Application Server
SAP Business Warehouse Message Server (Beta)
Google BigQuery (Beta)