As the whole tool, it has the objective to be extremely easy to use.
Series values are ideal for labeling data.
As shown in the image, users can select numerical values and series values.
The interface is simple, go to the Dashboards section at the left pane, and press the plus (+) symbol.
Users create a New Dashboard where the data will be imported and the Dashboard created. The next step takes place at the Power BI interface.Power BI Excel data sources are absorbed automatically from Excel Tables, so in order to take advantage of this semi automatic process, we just edited our Excel File from One Drive, using Excel Online Web App, and created one table for each table Google Analytics exported from our Traffic Channels Data. We uploaded this CSV file into our One Drive account, to make it easily available for Power BI.For that we extracted Google Analytics Data from our site and exported it to Excel through a CSV file.In order to analyze the power of the tool, we decided that our example will be based on real data we use in our daily analysis. This means users will be able to extract data from any data source their organization provides. For sure, this data sources will match most users needs, but Microsoft also provides the ability to create your own data source through REST API’s interaction with the Power BI Engine. At preview mode, there are ten (10) pre-built data sources. Power BI makes it extremely easy to create datasets providing several data sources and visualization widgets. Where To Start ?Īny Dashboard starts with defining the datasets, that means, which is the information to analyze and present in a summarized view. The tool is incredibly simple, incredible powerful and the interface usability is great for browser based tablets to notebooks.įor this post we have created an example just to showcase how simple and powerful this tool is right now and how it might become a game changer in the near future. Power BI was created with Microsoft’s Strategy “Mobile first, Cloud first” in mind and is part of the Office 365 productivity suite. Originally created as a complementary set of tools for Excel, the concept evolved into a Power toolkit aimed not only to Business Intelligence Analysis but also for Big Data Analysis and Data Science. The BI acronym states for Business Intelligence.
Microsoft has launched, in preview mode, their most innovative tool till now, for creating Professional Dashboards and Data visualizations.