POWER BI is a data analysis tool [ Software] which can help us to analyze the data in the lightening speed.
We already learnt the basic procedure of importing data into POWER BI through an example taken for the
Now we will learn to import the data from WEB which is of immense help for us and most of the information is available on the web.
This options is so easy and useful that we can directly import the data from web, clean it and analyze it.
In this article , we would fetch data from the web and create a visual.
First of all, we should have the link to the page where the data exist.
We should remember that we can fetch the tabular data into power bi from the given link.
Let us find out the record about the cricket world cups since the start.
We could find https://en.wikipedia.org/wiki/Cricket_World_Cup this link for the record. Let us try to fetch the data and see what analysis we can do with this data.
1. Let us find out the number of times any country has HOSTED the world cup.
2. The number of times any country has won the world cup in descending order.
THE FIRST STEP IS TO CREATE CONNECTION IN POWER BI.
We have the following tasks in the data loaded into power query. [CLICK HERE FOR IN DEPTH DETAILS OF THE FOLLOWING OPERATIONS.]
The data after cleaning looks like in the following picture.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE