KPI in Power BI | How to Create and Use a KPI in Power BI


What is KPI

KPI is nothing but a measurable value, which shows the best ways for organizations to achieve their essential goals of the business with efficiency. Companies take the help of KPIs at various levels for their successful evolution to reach targets. The concentration of high-level KPIs is on the entire business performance, and the focus of low-level KPIs is on departments processes like HR, marketing, sales, support, etc. we can say it simply as a set of value measures, which is used by organizations to evaluate its entire performance.

 Become a Power BI Certified professional by learning this HKR Power BI Training !

When to use a KPI

It is the best choice when we decide to use KPI. We can use KPIs in the given situations.

  • We can use KPI for progress measurement and to answer the questions like “where am I in front or behind”.
  • We can also use KPIs for distance measuring for companies’ business objectives, and we can answer the questions like “how much distance is there behind or ahead.

Power BI Training

  • Master Your Craft
  • Lifetime LMS & Faculty Access
  • 24/7 online expert support
  • Real-world & Project Based Learning

KPI requirements

The visuals of KPIs are based on particular measures, the main intention of these KPIs is to help us in present value evaluation and the defined target metrics. Base measures are essential for the visuals of KPIs, which helps in value evaluation, target measurement, and target measurement. Its dataset requires maintaining the goal values for KPI, in the case when there are no goal values with our database, then we may design them by combining an excel sheet with our model of data goals and the file of PBIX. 

Prerequisites to use KPI in Power BI

There are two main prerequisites to use KPIs in power bi, the given below are those prerequisites.

  • To use KPIs in power bi we need to install a power bi desktop in our system.
  • We have to maintain the data source and the relevant existing report for KPI which we designed.

Requirements for creating KPI in Power BI

To build KPI in power bi there are some essential requirements, they are like threshold value, trend, target value, measure value, etc. for value evaluation we must require the base measure. For our power bi report generation, we need to choose the goal and base value from the database, which you are working on currently. With the help of these values added to our database, in later sections we are permitted to create a KPI. 

 Top 50 frequently asked Power BI Interview Questions !

How to create KPI

Let us see the process of KPI creation in the Power BI desktop with simple steps.

  • First, we need to open the report editor then choose the required report. On the right side there is a visualization pane, click on the KPI visual.
  • After the KPI visual selection three blank spaces appear on the field section, they are target measure, trend axis, and indicator.
  • The field panel contains all the fields of imported tables, we take the values from them to put in the indicator column.
  • In the next step, we fill the columns of the trend axis with the fiscal month and the target measure column with the goals field.
  • As shown in the given diagram, KPI is ready with our selected values. Now we need to format this KPI by choosing the paint roller icon in the format section. Then we are allowed to fix the properties for title background, title, color coding, trend axis, etc.
  • Finally after the completion of the KPI formatting process according to our preferences, the output came as shown below.
Business Intelligence & Analytics, power-bi-kpi-description-0, Business Intelligence & Analytics, power-bi-kpi-description-1

Subscribe to our YouTube channel to get new updates..!

KPI elements in Power BI

We can classify KPI in Power BI into three elements They are thresholds status, target value, and base value.

  • Base value: It is a measured value, that is an average of sales and gross profit.
  • Target value: It is also the absolute measure value, it is a bunch of goals the evaluated target value. We can fix the target up to 200 units per month for a while, then our base value will be recorded for the month. Either it may be less than 200, 200 or more than 200.
  • Thresholds status: Thresholds status offers a range for base and target values evaluation, the visual also provides low and high end of the range between the values fall of base and target.

Advantages of KPI in Power BI

KPI is simple to use, we may utilize them to expose the complex information equally. The given below are the two main advantages of KPIs in Power BI.

  • We can utilize KPIs for progress measures, they are like negative and positive changes. We can know if we are gaining proper results or not, about meeting targets, and lagging.
  • KPIs are also used for distance measures for the target, we can analyze the distance like how far we have with the achievement of our target.

Want to know more about Power BI,visit here Power BI Tutorial !

KPI custom visualizations

Along with built-in KPIs, which we created there are various visualizations. Those visualizations are related to KPI, which we can install from the marketplace of Power BI. We can add them by clicking on the icon from the marketplace, the given below are various visualizations.

  • Bullet charts: It works as a representative for measure value and target value evolution, it also offers the evaluation of context performance through marketers’ performance.
  • Dual KPI: Two visuals of KPI are exposed by a dual KPI that are next to each other, those visuals are dynamic and they can change the information in KPI. They are informative but there is no need for huge space for Dual KPI. 
  • KPI indicator: The visuals of the KPI indicator display the status with a cloured background. It displays the base value and the percentage is used to indicate the variations between the values of base and target.
  • Power KPI: It is a kind of multi-lined chart, which displays the base value in lines format with various colors. 

Power BI Training

Weekday / Weekend Batches

Conclusion:

KPIs are simple in looks, but at the same time they are complex and while creating we may face problems. We require our KPI to be up to mark when we are new to using KPIs. As this is complex we must be careful and get a complete idea of these KPIs, then only we utilize it properly in power bi. We thought this blog may help you as much as you require. If you had any queries or questions that need to be answered please do comments below, to get your question answered quickly by our HKR expert trainers.

Related Article:

Power BI Resume

Power BI Matrix



Source link

Leave a Reply

Subscribe to Our Newsletter

Get our latest articles delivered straight to your inbox. No spam, we promise.

Recent Reviews


Anaplan Dashboard – Table of Content

Introduction to Anaplan

Anaplan is the best business planning software company located in San Francisco, United States of America. Anaplan software sells subscriptions for cloud-based business planning software and also offers the data for decision-making tasks. The main purpose to develop Anaplan software is to build a platform to connect people around the world, data, and create an effective business plan. Anaplan software also delivers a unified real-time, cloud-based environment to optimize the planning, and also facilitate the decision-making capabilities to a different operational level.

To gain in-depth knowledge with practical experience, then explore HKR’S Anaplan Training!

Anaplan Dashboard

Anaplan dashboard is a combination of the grids, and charts used to design models, or business planning designs. This dashboard allows users to include n number of elements depending on their requirement. It’s very user-friendly and easy to use. The below diagram gives a simple glimpse of the Anaplan dashboard. 

Types of Anaplan dashboards

Below are the important dashboard types that are designed to direct a particular user guide. They are;

  • Landing dashboard: this is the first set of Anaplan dashboards, which is visible when you log in to the Software. This type of dashboard is very simple, concise, and also directs users about the tasks they need to undertake, and provides relevant information related to actions. 
  • Operational dashboards: this type of dashboard displays the data which illustrate the day-to-day business activities. The operational dashboard also allows users to include real-time data to perform business operations smoothly.
  • Strategic or executive dashboard: this type of Anaplan dashboard provide the executive with a high-level overview of the various business functions along with opportunities and ideas.
  • Analytical dashboard: this type of dashboard displays operational or strategic data in the form of drill-down and also helps users to explore slice and dice to reveal various data insights.

Get ahead in your career with our Anaplan Tutorial!

Anaplan Training

  • Master Your Craft
  • Lifetime LMS & Faculty Access
  • 24/7 online expert support
  • Real-world & Project Based Learning

Dashboard framework

There are three parts that are important to build a framework, they are;

Let us discuss them one by one:

    • The Header: this framework building block mainly focuses on navigation and global page sectors such as time, version, geographic locations, etc. With the help of the header section, you can also place the most used dimensions to the top left of the screen. The header enables you to read a screen in much the way they read a book.
    • The body: this body section contains grids and charts, also sometimes images. Always remember one thing: try not to add many elements on the dashboard and make sure that the grip elements are consistent for all the elements, keep column width consistent, brief the label width wherever it is required. The “simplicity” is a key to creating a dashboard and trying to create it by using four-quadrant approaches in the body of the dashboard.
    • The footer: this is an optional step and also offers pointers to the next activity or buttons to trigger the actions.

Dashboard layout

To improve the dashboard usability, follow the below guidelines or layout design.

  • The language which you select on the dashboard must reflect the language that includes jargon, or errors. More importantly, it should feel like an easy to use customized environment.
  • Decide on how you are going to access the dashboard using desktop, tablet, or mobile? While customizing the dashboard, you should have a clear idea of how you are going to use it, it’s good to use a screen resolution. 
  • Last but not least, think about how wide your audience is? Are they need any special requirements? Any color blindness?

As a designer, you must keep all these things in mind while designing a dashboard.

Important factors about Dashboard layout:

  • Don’t ever clutter the dashboard, try to keep it simple and more effective.
  • Consider building a landing dashboard in the four quadrants. This is one of the simplest layouts to create and is also quick to comprehend.
  • Think about splitting the models into inputs, calculations, and outputs. The more important thing is that the dashboard should effectively display the outputs.
  • Always try to build a dashboard in a top-down approach that should contain a dashboard summary at the top and a description at the bottom.
  • Set the height and width pixel settings to -1 to ensure that all the elements must automatically adjust to the screen size.

Using Anaplan features in the dashboard:

  • This enables synchronization where users can make use of real-time data.
  • Most importantly if there any conditional formatting statements need to be added to the data before any item will be added to the dashboard.
  • Make use of the dashboard element menu to narrow the focus on the data model, or filter the view of the grid. These modifications should reflect on the dashboard.
  • For a chart, users need to list out the multiple elements, and they need to reduce the view of the chart by clicking on a chart series to hide that series and rescale the chart axis.
  • Use the drill-down method to view important formulas and the grid details,( the navigation to add this option is as shown below:  go to the context menu -> right click then click on “drill-down”).
  • You should be aware of the currency format, and dont forget to define them if the dashboard refers to a single currency.
  • Are you using any decimal number, and be sure to define appropriate fixed numbers.
  • Remind your users about the search function with the help of two options, 

They are;      

a.context menu 

b.dashboard menu element.                                                                     

  Top 30 Anaplan Interview question & answers for 2020

HKR Trainings Logo
Subscribe to our YouTube channel to get new updates..!

Dashboard and data access

In contents, users view the modules and dashboard they have been using to access. These modules and dashboards are organized into functional areas (that means meaningful groups that are easy to navigate).
Assigning data access to a specific role, and also limiting access to particular modules and dashboards. To make this process robust, follow these steps to robust data access:

  • When creating roles, employ a need-to-know approach to the data processor. This ensures that the roles realistically represent the activities of user groups.
  • You need to dashboard that is targeted directly to the requirement of the role. It’s always good to have three simple dashboards, which are directed to three different roles, rather than one dashboard that displays the data with an appropriate user.

Dashboards -Selective access:

This is nothing but a combination of both selective access and menu option that offers an administrative workspace with a fine level of granularity to control user access to the dashboard.

 First, let’s start with selective access:

Anaplan dashboard respects the selective access set across model:

The navigation to follow:

  • Roles -> version dashboard elements only display the versions to which the user has access.
  • Roles -> Modules dashboard that is available to the user if they have read or write access to all of the module elements are published from.
  • Selective access on lists dashboard elements that only display list items to which the users have access.

Dashboard- menu option:

  • The administrator can set up user access for each dashboard grid element individually.  When an administrator selects a grid or chart element, the menu options are displayed in the dashboard designer properties panel.
  • The menu that is accessed from the dashboard element menu option provides the basis for the organization of menu options. For example, you can choose the pivot function from the view menu (this is also known as view-Pivot).
  • Similarly from the menu option, you can control whether the user can use the import function (this can be done using data-import).
  • The open source module controls whether a user can open the module that is the source of the grid or chart element.
  • To access the menu option, you can select the option that you want to make available to the end-users and clear the option that you want to hide from them.
Anaplan Training

Weekday / Weekend Batches

Final Words

There are a lot of different dashboards available on the market, but choosing the best one takes time and you can think that it is a big challenge. Anaplan dashboard has not only been developed to help IT people but also non-IT and business analyst professionals. The main purpose to use the Anaplan dashboard is to offer a subscription service for the cloud application/ software and also helps designers to create a business plan or customize the dashboard according to their requirements. In this Anaplan dashboard post, we have explained you the dashboard types, overview, framework, selective access, and menu options.

 

Related Article:



Source link