Excel is a very useful tool for professionals who manage data to study information and evaluate results day by day. Many people use Excel for specific tasks while other request from IT to draw tables with fields that require measuring. In both cases, a set of dynamic tables must be generated to analyse the data, that is, adding fields with some calculations, adding some columns or formatting, and then loading different dynamic tables to carry out the analysis, in some cases this is a careful process that relates some results from various tables to obtain the information with the desired structure which allows to make the right decisions required by the intended objective. These tasks are now performed by Power BI automatically and through this article we will show you how do it with Power BI in such a way that your analysis tables or graphs will be available with the latest information ready for decision making.
Comparing in a table the results of one period with respect to another is an impossible task to perform with Excel; this task requires independent tables and then combine them to obtain the variations and participations. This is because Excel calculates a table or filter data with the same information for all cells. So this leads to the need of an advanced Excel user to obtain a number of different tables and consolidate the information, a situation that generates a heavy workload and hours invested in keeping the information updated.
Power BI arrives to solve this issue, to obtain within the same table the results of various periods or partial consolidated attributes. This shall allow users to have their tables and graphs with the latest information and available in the cloud to be consulted by their colleagues with the latest information and with the possibility of analysing the data of a table by filtering the attributes of the model interactively, reports that will also be available on their mobile teams.
Power BI is the Microsoft tool that allows you to have online, updated and interactive reports.
Let’s take a general look at how Power BI works.
With Power BI, each cell is calculated independently, allowing to compare values that correspond to different periods or to compare the figures against consolidated values, a situation that facilitates obtaining participations and variations on the same table, without the need to combine results from different tables. With the added benefit that the calculated values are portable, that is, we can use different filters or attributes without having to perform new calculations, because the calculations in Power BI are made for each cell after reviewing the filter context. This task is simply not possible with Excel.
The following figure shows a table with an example of the above mentioned.
Power BI has the connectors to get information from different sources and provides the Query Editor to access and transform the data into the model to which you want to apply business intelligence. This is complemented by the service with the connector that provides the service in the cloud managed by Azure, so it is possible to update the data of each model online, and the user will be able to visualise his reports with the latest data, as well as to schedule each report as the user wishes from one hour onwards.
Power BI provides all sort of tools to prepare tables and graphs with interesting options to import specialised graphs on R language or from the graphics gallery. Preparing the graphs is very similar to the way of preparing dynamic tables on Excel. This allows users to quickly master the tool.
Power BI includes a version to download and install on hardware, called Power BI Desktop, which allows to perform calculations from the most basic to the most complex of business intelligence.
In this way, Power BI has come to revolutionize and empower all Excel users, with cutting edge technology and no competition cost. The most economical and practical way to get into the world of Business Intelligence.