Power BI is a set of programs from Microsoft in the Business Intelligence family that help you create interactive reports based on data.
What is Power BI
As with any representative of Business Intelligence technology, the purpose of Power BI is to present information in an easy-to-decide form, through consistent work:
Connecting to data sources
Structuring information and analytics
Visualization in dashboards
The entire sequence of work can be done in a desktop builder – Power BI Desktop
The software contains:
The data sources when may be different
Power Query allows you to connect easily and without a code - with drag and drop
You link disparate information from different sources in the Link Editor
All analytics are written in DAX language, which is very similar to formulas in Excel
Data vizualization – the most interesting and exciting part of report editor
After you have everything ready use the cloud service Power BI Service and mobile app Power BI Mobile
for publication, distribution, and collaboration
The cloud service has free and paid licensing options
You construct a report on Power BI only once, and then all updates happen automatically according to the schedule