Power BI is the combination of “software-as-a-service” and “desktop app”. The desktop app is used to explore your data and build reports; but it’s the combination of app and cloud service which makes it more popular.
In other words it’s a reporting tool which turns out the resulting report into a live dashboard on the cloud service, connected to live data and giving near-real-time analytics report with all the graphical indications and effects.
Components of Power BI
- Power BI Desktop: Power BI Desktop is used to create reports and data visualizations on the dataset.
- Power BI Gateway: Gateway uses Power BI on-premises gateway to keep your data up-to-date by connecting to your on-premises data sources without the need to move the data. It allows you to query large datasets and benefit from the existing investments.
- Power BI Mobile Apps: Using this you can stay connected to their data from anywhere and these are available on various platforms like Windows, iOS, and Android platform.
- Power BI Service: This is a cloud service and is used to publish Power BI reports and data visualizations.
In Power BI various data source are supported. Below is the list for all supported data source.
- Flat Files
- SQL Database
- OData Feed
- Blank Query
- Azure Cloud platform
- Online Services
- Blank Query
- Other data sources such as Hadoop, Exchange, or Active Directory
Data modeling features is used to connect multiple data sources in BI tool using a relationship. A relationship defines how data sources are connected with each other.
With this feature, you can build custom calculations on the existing tables and these columns can be directly presented into Power BI visualizations.
Visualizations are used to represent your data and are the basic building blocks of any Business Intelligence tool. Power BI contains various data visualization components which contain simple bar charts to pie charts to maps, and it also contains complex models such as waterfalls, funnels, gauges, and many other components.
Report Duplication is also easy in Power BI tool, you just need to Copy one and paste and it will created a duplicate visualization.
The visualization report we have created can be shared in many different ways.
- Publish reports using Power BI Service
- Content Packs combine dashboard, report, and datasets obtained in BI desktop tool
- Create Groups and assign specific rights to different users for report sharing
- Use Power BI mobile apps to access share dashboards and reports
In the Recent update Power BI has also provide a new way to publish the report on your web Application with the help of API and its provide the more secured way to access your reports in your web applications.