Generate Business Intelligence Reports From Wikipedia Using Power BI

Go to the table page as shown below. We can see the loaded data within PowerBI.

Go back to the visualization page so as to create reports based on the loaded data.

From the visualization section, we will select bar chart as the choice of report generation option for the time being. To the right of the page, we can see the entire table columns that we can use for creating bar charts.

We will use only the required columns. As we are plotting Mountain versus Mountain height, let's drag Moutain Cloum to the X Axis and the Height Column to the Y axis (Values) section.

This will generate the bar chart report. Since we have not restricted the data, the entire mountain range within the table will be plotted in the bar chart making it congested.

To get meaningful data, we can apply filter so that only the required data will be plotted in the bar chart. Now, we have applied the filter such that only mountain with a height above 8400 metres are taken up for plotting in the bar chart.

We can customize the already created bar chart by adding colors, changing the font size, and so on from the customization section as shown below.

Publish to Power BI Online

Finally, we can publish the report to Power BI online.

Specify the credentials and click on Sign in.

Select "My workspac"e as the destination to publish the report.

Clicking on select will start the publishing of the report to Power BI online.

Finally, we have received the success message as shown below.

Heading over to Power BI Online, we can view the recently created report.

We can also change the filters directly from the online report.

Summary

Thus, we saw how we can make use of Wikipedia data and generate business intelligence reports using Power BI.