Build a simple dashboard in Power BI

In continuation with my previous blog, here I will create dashboards in Power BI for the model we generated before. A dashboard is a visual display of all of your data. It usually sits on its own page and receives information from a linked database. In many cases it’s configurable, allowing you the ability to choose which data you want to see and whether you want to include charts or graphs to visualize the numbers.

Below is the model of the database I had loaded in Power BI for my previous blog. Let’s generate dashboards for the same.

Creating a Dashboard in PowerBI

For generating dashboard and reports, move to the reports tab of Power BI. To analyse data for specific attributes from different tables, we create reports from those specific chosen attributes. In this dashboard, I will be creating various visualizations for different fields and it will be shown in the reports tab of Power BI.

Let’s start by creating a visualization which shows the representation of quantity sold by product key and the product category. For creating this visualization, I chose category from Product table and product_key and quantity_sold from the Sales_Facts table. Once you have selected the fields you are suppose to select a proper representation for it, so choose the pie chart visualization from the visualization tab.

Another visualization of pie chart which shows the representation of quantity sold by brand and the product category.

In this case, I have used a clustered column chart from the visualizations section. And selected the necessary fields for this quality_sold by brand and city visualization.

Next, I have generated chart which will compare cost per square feet per city. For visualizing this report, select the cost_per_square_foot and city from the Store table.

Now, comparing the returned quantity and sold quantity for each product. For that, we will use ribbon graph and select the product_key and returned_quantity from return_facts and quantity_sold from sales_facts table.

Next, I have created a pie chart representation which depicts the sales revenue representation for all the cities. The chart represents the percentage sales revenue with total amount of revenue for individual cities. To create this visualization choose sales_revenue and city attributes from Sales_Facts and Store table respectively.

Lastly, created this report represented in the tabular form which shows details about the brand, category, product key, actual sales price, sales revenue earned and the total quantity of sold products.

That’s all for this blog!