Power BI as Self Service Tool….
Some time ago I was invited to participate in writing articles for the magazine CompartiMOSS , through @FabianImaz SharePoint MVP and one of the directors of that publication.
I leave the following article I wrote a while back ago. They can be directly accessed through the link to the magazine, and they can also see other articles by various authors that allow be updated on various technologies such as Office 365, SharePoint Online, among others.
Within the range of Microsoft solutions, came a perfecting what Excel previously generated through various accessories: Power BI. The tool generates reports and interactive displays, linked, with Dashboards that provide vital business information instantly, dynamic update, with the ease of performing drill down for more detail of the data collected.
Power BI also enables data connection with multiple sources simultaneously, and information modeling (cleaning and data transformation). Is added to turn on the tool the ability to perform natural language questions (Q & A) for the system to quickly generate reports using charts and graphs variables that comprise the model.
There are 2 versions: desktop and web, using a browser and a login / user. They are simply downloadable from the Power BI site ( https://powerbi.microsoft.com) . It also has native applications available for mobile devices with iOS, Android system.
Evolution of Power BI
The world BI (Business Intelligence for its acronym in English) has been working for years on the Self Service BI concept, which aims to provide the analyst with tools business which not only generate its own business model, but also exploit reportability using variety data sources (online and on premises), as well as displays with high impact for the user. Microsoft also began working on various supplements that provided Excel to incorporate BI tools that allow, initially, develop a data model but also adding value to the business generating calculated columns, measures and KPI’s.
On the other hand, it was supplemented with PowerView, a tool that allows you to add a dynamic graphic style connecting to the data model and obtaining information from a practical, agile and with great visual impact of the end user.
With Power Map, complementing Excel, we sought to add layers that have allowed data visualization in a given geographical area. Regarding Power Query, in addition, Web queries were added to incorporate information to the data model.
The tool is none other than the development of an instrument whose purpose is to run the full life cycle analysis.
With focus on various projects with vertical in the world of Finance, Forestry and Energy Dashboards can be developed that allow customers to have an overview based on key business (measures, KPIs, indicators at the macro level) parameters. From this Dashboard they have the ability to receive alerts when there are changes, share this information with colleagues in your organization, disponibilizar them on mobile devices (iOS, Android, Windows) and comment on business questions that may arise.
With this slogan the suite allows us to have a pool of different links to data sources such as those that can be displayed in the image below.
These data sources are being updated in a timely manner in the tool and changes that are being incorporated into a weekly basis by Microsoft.
On Premises Data Access – Gateway
Power BI Gateway acts as a bridge that allows the transfer of data between data sources and local services that support Power BI Data Update On Premises servers.
The Gateway is installed and runs as a service on the computer. As a service, it runs with the Windows account that you specify during setup. In some cases, the gateway runs as an application.
When Power BI updated data from a local data source, the gateway ensures that the account Power BI has the appropriate permissions to connect to and query data from the source.
Data transfer between Power BI and the gateway is protected through the Azure service. The bus service creates a secure channel between the Power BI service and equipment. Since the gateway provides this secure connection, typically you do not need to open a port in the firewall.
According to the previous image we can see a connection generated against an on-premises environment to extract information from an SSAS cube (Analysis Services) to generate Dashboards and Reports. Once the configuration and the connection is established either web version or the desktop tool can be used to generate reports as shown in the following image: