Data Science: Build a Power BI Report
This blog is part helps you learn how to generate various reports in power bi using the dataset we have. It describes how to import data from an excel datasheet into Power BI, do data analyses, and build reports with various visuals.
What is a Power BI Report?
A Power BI report is a multi-perspective view of a dataset that includes visualizations that illustrate various discoveries and insights from the dataset. A report can contain a single visualization or multiple visualizations across multiple pages. A report’s visualizations are similar to those on a dashboard, but they serve a distinct purpose.
These aren’t static visualizations. In fact, with extremely interactive and customizable representations that update as the underlying data changes, it’s far from the case. To discover insights and find solutions, you can add and remove data, alter visualization kinds, and apply filters to your model.
Before you can create any reports in Power BI, you need a dataset. Here I am Going to use Supermarket Sales Dataset.
After successfully adding the dataset, Click on your dataset to create a new report. Now you can see a blank canvas.
Now you have to add visuals to your report. And there are two ways to achieve that you can either:
Select the fields first then visualizations after
Or if you have the specific visualization in mind, select the type of visual first then the fields after
We’ll go with the first method.
Select appropriate fields, While clicking those fields, a visual will appear on the canvas.
In order to change the type of visual, just head over to the visualizations pane and click the clustered chart icon.
Now you got your report in the visual type you preferred.
Similarly add different visuals and save your report.
This is how you can create a simple Microsoft Power BI report.