Power BI Dashboard – Creating Dashboard In Power BI From A Report

Welcome to the second blog in this Power BI blog series. This blog will focus on Power BI Dashboard. I would be talking about how to create a dashboard and and use it for better data insights. In case you people are new to Power BI and want to get some insights on Power BI, you may go through my previous blog which would help you to understand and get started with Power BI. 

If you’re wondering what does it actually takes to become a BI Developer? Well, you can check out the Power BI Course Syllabus curated by Industry Experts before going ahead with the blog.

So let us get started with this Power BI dashboard blog in the following sequence:

1. What Is Power BI?
2. Reports In Power BI
3. Power BI Dashboard
4. Dashboards Vs Reports
5. Creating Dashboard In Power BI

What Is Power BI?

Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service BI capabilities. End users can create reports and dashboards by themselves. This means they don’t have to depend on information technology staff or database administrators.

Power BI also gives you cloud-based BI services, known as “Power BI Services”, along with a desktop-based interface called “Power BI desktop”. It offers data warehouse capabilities including data preparation, data discovery and interactive dashboards. In March 2016, Microsoft released an additional service called Power BI Embedded on its Azure cloud platform. Using it, one can deliver reports, analyze data easily and perform various ETL operations with Power BI.

Power BI gateways let you connect SQL Server databases, Analytical Services, and many other data sources to your dashboards. Reporting portals embed Power BI reports and dashboards to give you a unified experience.

All this while I have used the terms ‘reports’ and ‘dashboards’ quite a few times. Let us try to understand these terms one by one in the next section of this Power BI dashboard blog.

Find out our Power BI Training Course in Top Cities

Reports In Power BI

A Power BI report is nothing but a multi-perspective view into a data set with visualizations that represent different findings and insights from that data set. A report may be a single visualization or pages full of visualizations.

Visualizations can be pinned to dashboards and if you select the pinned visualization, it will open the report from where it was pinned. One important point to remember is that reports are based on a single data set.

The visualizations in a report represent a nugget of information. These visualizations aren’t static, you have an option to add and remove data, change visualization types, and apply filters in your quest to discover insights and look for answers. Like a dashboard, a report is highly interactive, highly customizable and the visualizations update as the underlying data changes.

The image below represents how a sample report looks.

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.

Dashboards are a wonderful way to monitor your business, to look for answers, and to see your most-important metrics at a glance. The visualizations on a dashboard may come from one underlying data set or many, and from one underlying report or many. A dashboard combines on-premises and cloud-born data, providing a consolidated view regardless of where the data lies.

A dashboard isn’t just a pretty picture, it is highly interactive and highly customizable. The tiles update as the underlying data changes.

People often confuse dashboards with reports since these are also canvases filled with visualizations. But there are some major differences. Let us take a look at these differences with the help of following table.

This Edureka video discusses the ” How to build Power BI Dashboards ” that helps you to understand how we are creating reports and making dashboard from it using online Power BI Service

Dashboards vs Reports

Creating Dashboard In Power BI

The use of Power BI dashboard can be best understood with an example where the data set has different data types, each of which has the potential to reveal valuable business insights. Let us consider a use-case of a retail superstore where you unlock insights from data around regional sales, individual store transactions, product categories, consumer segments, sales figures, discount margins and profit.

If you consider the above use case from a business perspective, you would want answers for the following points:

• Which region is more lucrative than others
• Which customer segments to focus on
• Finding segments to reduce investments.

In order to achieve insights for above mentioned points you will be required to process data in a different way, the aim is to improve business productivity & profitability. Let’s now try to understand what insights we can get using superstore data set:-

1. Overall sales and performance of the superstore: The first logical step is to get an idea of the performance of the superstore over time. For this, we need data around sales from different regions on a quarterly basis. We also need to understand which region is more profitable or loss-making compared to other regions.
2. The performance of different states: Having got region-wise insights on profits and losses, we can create a scatter-plot of ‘sales vs profits’ at a state and region level with sales and profit as X and Y axis respectively. These states can be mapped to understand different scenarios. For instance, a business can take a decision to invest more in a state that has lesser sales but higher profits. Another state may end up raising a red flag if sales are higher but profits are declining.
3. The performance of different customer segments: It is also essential for the business to know which customer segment is driving sales and profits in different regions. For example, a pie chart with a view of customer segments and sales/ profits can help the business formulate future strategies– which segment should be the primary focus area, for example B2B consumer segment might be driving the maximum profit with very less sales number– clearly, there is a huge opportunity to expand the B2B segment in this particular region.
4. Revenue generation by category: Within specific regions and customer segments, we can get the data around specific product categories and how they compare (in terms of sales and profits) with one another. If kitchen appliances are yielding better profits than cleaning equipment, it is a valuable insight that can influence future plans.

So let us go ahead and see if we can visualize this data better using Power BI dashboard. But before that I would be creating a report with all the visualizations, so I can pin those visualizations on the dashboard. If you wish to create these reports with me, you can click on this link to download Power BI desktop, an interface which we are going to use for visualization.

So let us get started then, shall we?

The image below, shows how the Power BI desktop interface looks like. We have three tabs on the left hand corner of the interface. The first tab is the report tab, which is visible by default and we are going to use it to create reports. Next is the data tab which is used to see the imported data sets. The last tab is the relations tab which gives you you relationship between different variables in a data set, if they are well defined.

You can easily import data sets into Power BI. This can be done by clicking on the Get Data tab. We have the Visualizations tab on the right hand corner of the screen. All the different kinds of visualizations that are listed under it can be used to meet your requirements. There is a Fields tab next to the Visualizations tab which gives you all the fields that your data set has.

I have gone ahead and imported the Superstore data set. You may use this link to download the data set. Once you import the data set, the interface will give you an option to load or edit the data as it is visible in the image below.

Once we have imported the data set, you are good to go ahead and visualize data. With Power BI, all you have to do is select the visualizations and drag the required fields and drop them on visualization template to view them. Please refer the image below. I have selected a map representation and have dragged the state field and dropped it on the map.

My aim was to make you understand these basics about Power BI’s interface. I believe they were fairly simple to understand. So let us continue with our use case and try and visualize data as discussed previously.

Overall Sales And Profits

As you can see in the screenshot below, I have used the map representation and given it ‘state’ and ‘profit’ fields as inputs. The visualization gives us state wise ‘profit leaders’, which are represented by bigger bubbles.

You can go ahead and save this visualization or even publish it right away. I would instead be adding an extra page for all individual visualizations and then publish the complete report. This will make it easy to pin these visualizations to the Power BI dashboard and also prevent you from crowding a single page with multiple visualizations.

This can be done easily, just click on the plus sign on the left hand side at the bottom of the screen and your new page is added. I would do that and also create the next visualization.

I have selected a line graph to visualize ‘profits’, ‘sales’ and ‘order date’ fields. Once the visualization was created, I changed representation’s timeline from ‘yearly’ to ‘quarterly’ which can be done by clicking on the navigation available on top right corner of the screen. Refer the image below for the same.

It is visible in the above image that the sales have gone up after second quarter. These visualizations are interactive. If you move the mouse pointer on the graph, it will display stats as it is visible in the image above.

Performance Of Different States

In the following visualization, I have created a scatter-plot with X-axis as sales and Y-axis as profit. I have selected sum as an aggregate for both sales and profit axis.

This visualization can help us divide the states in three business strategic focus areas – Retain, Develop and Divest. The states on the top right corner with high sales and profit are currently at a good position and business would want to retain this in the coming future. States to the right of median line can be looked upon as opportunity by the business wherein the increase in sales would help increasing the business profits – Develop strategy. And finally the states with low sales and low profits or higher sales but low profits are definitely not the areas where the business should focus on divesting the money. This helps heavily in formulating business investment strategy.

The image below shows the scatter-plot.

Performance Of Different Customer Segments

With a visibility at a region and state level, we can now look at which consumer segment is driving the sales and profits and identify which segment to focus on(among Customer, Corporate and Home Office).

For example, we can see that in Central region, although the consumer segment is contributing to 50% of sales, it has a low profits share. However, the Corporate segment has a much higher profit share with lower sales contribution. Definitely, the business should focus on increasing the Corporate sales contribution which can impact the profitability for the business.

Revenue Generation by Category

The next logical step is to derive insights at a product category level. We can understand which product has higher sales and profits in a particular region and consumer segment. Or how the various product categories have performed in terms of sales and profits.

In Power BI, you can add multiple filters to your data to get the exact insight you desire. You can click on the drill down option available on the top left corner of the visualization to change representation of data. For our superstore data set you can use the drill down option to view sales by state, category and sub category to meet your needs.

By now, we have covered the basics of data visualization with Power BI. There are so many more insights that can be unlocked from the data we have. I urge you to go ahead and try other visualizations, this may help to unlock those insights which I may have missed.

As far as this Power BI dashboard blog is concerned, let us now save this file and create a dashboard. The first step is to save our work as a report. I have done exactly that in the next image.

Once you have saved the file, you should go ahead and publish your report. The publish option is available on the top right corner of the screen.Please refer the image below.

Once you have published the blog, you will get a pop up with a link, if you click on the link, it will redirect you to a webpage with your report published to web.

The image below shows a published report.

You can pin visuals from your report to a dashboard. First you need to select a visual. Once you have done that you click on the pin visual symbol to pin the visual to your dashboard. Please refer the image below.

Once you click on the pin visual option, the following tab will open. You can pin the visual to an existing dashboard or can create a new dashboard. I have created a new dashboard and then pinned the visual to it.

The image below shows how a visualization looks on a dashboard once you have pinned it.

Now I will go ahead and add all the visuals we have created to the dashboard. Please refer the image below. You can resize and adjust the visuals on the dashboard to meet your requirements.

A Power BI dashboard gives you the following functionalities:

• Add tile
• Usage metrics
• View related content
• Set as featured
• Subscribe 
• Share 
• View
• Use Power BI Q&A to ask a question.

Let us see these functionalities of Power BI dashboard one by one:

You can add a tile to your existing dashboard. The tile can be an image, web content, textbox or a video. 

The Dashboard Usage Metrics gives you information like views per day, total shares, etc. Refer the image below.

You can set your dashboard as featured, subscribe to related dashboards for updates and even share your dashboard. In order to share your dashboard you can click on share option and enter the recipient’s email Id. I have gone ahead and shared the dashboard. Please refer the image below.

With Power BI Q & A (Question & Answer), you can ask questions and get immediate answers with natural language query. Just type your question or keyword in ‘Ask a question about your data’ tab in the top left corner and you will get the answer. However the keyword you type should be present in the data set. The image below shows sales in Chicago by profit.

So this brings us to the end of this blog. I hope you liked this Power BI dashboard blog. If you wish to know the basic concepts of Power BI, you can refer my blog on Power BI Tutorial.

Got a question for us? Please mention it in the comments section and we will get back to you.