Open In App

Power BI – Dashboard Introduction

Improve
Improve
Like Article
Like
Save
Share
Report

Power BI is a Powerful Data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale with security. Microsoft revealed that Power BI is now used by 97% of Fortune 500 companies at Microsoft Business Application Summit in 2021. Let’s Dive into the blog to know about the Core feature of PowerBI.

PowerBI Dashboard

A PowerBI dashboard is a single page that contains a collection of visuals built for a deep level of interactivity. In simple words, It is a page with multiple charts and graphs that help to derive useful information from a number of data.

Advantages of PowerBI Dashboards

  • Embedded Attributes
  • Rich Features
  • Easy Implementation
  • Drag and Drop
  • No Upfront class
  • Allows Collaboration
  • Continuous Updates
  • Publish reports Securely

Power BI Dashboards vs Reports

Dashboards Reports
The dashboard is an effective business data view from where navigation to reports originates. Reports are built based on datasets where each dataset can be viewed from different points of view.
It is a single page that displays the summary of the whole data. You can create a Multi page in a single Report.
The dashboard is allowed only in Power BI Service. The report is allowed in both Desktop & Power BI Services.
One or more datasets/reports can able to use per dashboard. A single dataset is used per report.
Email Data Alerts are possible. Email Data alerts are not possible.
It supports only Bookmarks. Report support many filter options like Bookmarks, Filters & Slicers.

Which is more Effective?

Promptly, you can’t separate Power BI dashboards and reports. They’re the North and South of Microsoft’s business intelligence: they organize each other. Both are high-powered, flexible, and booming tools that can give a comprehensive wider picture or a comprehensive look at the minutiae and finer details

As a whole, A good IT manager or business user can best leverage the tools at their disposal according to the needs and demands of the situation. So, Both Dashboards and Reports are Effective in their own way.

How to Create a Simple Dashboard?

Step 1: Importing data.

Dataset used here: https://www.kaggle.com/datasets/rhuebner/human-resources-data-set

The first step after opening the Power BI application is to gain access to your data. You can easily import your dataset from any format. Then click on the Get Data button located at the middle left corner of the screen.

Importing-data

 

The navigation pane shows the option of Files. Click on Files and browse to the location where your Excel Workbook or any other format is located. Choose your file and then click on the Connect button. 

Connecting-file

 

It takes a little time to process which depends on the file size. Make sure the data is extracted and load the data by clicking the Load button.

Loading-data

 

Step 2: Explore Your Data.

From the Data tab, you can view the tabular form of data. On the right, you’ll find a list of fields within those tables. 

Exploring-data

 

You can select a table or field to perform formatting actions on them. If you have fields such as date, time, city, state, percentage value, currency, etc. you can change the datatype or format from the Modeling tab.

Step 3: Choose the Right Chart.

So, for our dashboard, we decided to work on five fields: Hiredyear, RecruitmentSource, Position, EmployerId, and male-female employment. The first visualization that we’ll make is a Card. Select Card from the visualizations section.

Choosing-charts

 

Select the columns you want to add to the visual from the Fields section. You can also drag and drop the fields into respective columns indicated by the image below.  

Adding-columns-from-field

 

You can select columns, apply filters, and format the visual from the Format icon. The first card we prepared shows the Total number of Employers.

Card-obtained

 

The Same procedures were followed for the remaining cards. The second, third, and fourth cards show the Number of Recruitment Sources, Positions, and Maximum Salary respectively.

more-cards-added

 

Next, we’ll create a Pie Chart and a Donut chart which is going to show the Count of positions and Male – female rate respectively. Add this chart from the Visualizations.

Pie-and-donut-charts-created

 

Finally, add Funnel and Stacked Bar Chart to show the Number of Hired yearly and Recruitment source proportionally. Format the title, data labels, legend, axes, plot area, data colors, etc. As you can see in the below image.

Funnel-and-stacked-bar-chart-added

 

Note: Add some interactive colors to attract more)

Best Practices to make an Effective Dashboard

  • Know your Audience.
  • Tell the story at first glance.
  • Make use of Full Screen.
  • Highlight the most relevant information.
  • Place the most important information in the upper left.
  • Use the right visualization.
  • Use limited slicers and filters.
  • Reduces the number too small. i.e., Round off the numbers.

Common Mistakes to Avoid

  • Improper labeling in the Dashboard.
  • Overuse of Colors.
  • A large number of Slicer.
  • Importing the Entire Data.
  • Eliminate non-essential interactions between visuals.

Last Updated : 05 Feb, 2023
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads