Data Science: Generating Dashboard using Power BI

Power BI Dashboard

A Power BI dashboard is a single page, often called a canvas, that uses visualizations to tell a story. Because it is limited to one page, a well-designed dashboard contains only the most important elements of that story.

The visualizations visible on the dashboard are known as tiles. These tiles are pinned to the dashboard from reports. The visualizations on a dashboard come from reports and each report is based on one data set. One way to look at a dashboard is to consider it as an entry point into the underlying reports and data sets. Selecting a visualization takes you to the report (and data set) which was used to create it.

Dashboard Generation in Power BI

This dashboard will be created using various visualizations for different fields and it will be shown in the reports tab of Power BI. To start with we will be creating a visualization that shows the representation of sales revenue by product category. For creating this visualization we have to select a category from the Product and sales_revenue from the Sales_Facts table respectively and choose the visualization from the visualization tab.

This is how a chart is created using different fields or columns from the data tables. Now, by combining these charts on one page we can have our whole dashboard as shown in the below image.

Similarly, you can add all the needed fields into the dashboard to make it more knowledgeable.