Power BI – as a Microsoft Business Intelligence tool – enables detailed analysis and visualization of databases. With this widely used tool we mostly analyze the data available within the company.
From now on – by Precognox’s TAS Data Collector solution – it is also possible to use web-based data within Power BI.
We show this process with a step-by-step guide.
1. Selecting and downloading a particular web page (as a data source)
In the first step, we download the selected web data (in our example, the content of the Keresővilág Blog website) using the Data Collector service. However, in the case of unstructured data (text content) on the web, downloading is accompanied by a number of tasks (data cleaning, validation) that are accomplished by our data specialists. As a result of these workflows, a structured database is created, which will be continuously updated in the future, so that the data is always available and usable.
The user gets access (server data, user name and password) to the structured database through a secured, password-protected channel.
2. Loading data in Power BI interface choose Get Data / More… and click MySQL database and then click to Connect
3. Enter the Server and Database data you received from us, then click OK
Here you can enter the User name and Password that you have received from us and then click on the Connect button
Select the database and then load it by clicking on the Load button
4. After loading the data, it could be managed and visualized as usual
Example of completed visualization
In addition to providing insight into the content of the web-based data source (chosen website), the visualization is a great business asset as it can be a part of presentations, business reports, evaluations, or even competitive analyzes. In this way, the potential of huge amounts of data on the Internet can be exploited.
Are you also a Power BI user? Do you want to know more about our text analytics solutions?
Structured databases provided by TAS Data Collector – thanks to integration – can be visualized with most known business intelligence and statistical tools (Tableau, RapidMiner, Google Data Studio, IBM SPSS).
Pictures: Microsoft Power BI interface and visualization