Data Science Series | Generating dashboards using Power BI

Step to step guide to creating dashboards in Power BI

Dashboards

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. In fact, 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

Continuing from the previous blog about reports, we will now generate a dashboard. Firstly, we need to publish the reports from our local machine to Power BI

Select Publish option from the ribbon

Now, once it is published, visit the app.powerbi.com, log in to your Office 365 account, and next open your workspace where you published your reports.

Now, select the dashboard option and select the tiles you want to display on the dashboard. Here, I have selected the cost_per_square_foot by city, budgeted_employees by city, retail_square_footage by city, and sales_revenue by city and department to display information related to shopping within different cities. The output was:

Dashboard generated related to information about Store present in the dataset

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