power bi指标呈现_在Power BI中使用关键绩效指标

power bi指标呈现

In this article, we will learn Key Performance Indicators usage in Power BI and solve a business case problem through Power BI.

在本文中，我们将学习Power BI中的关键绩效指标用法，并通过Power BI解决业务案例问题。

Key Performance Indicators also known as KPI are very efficient indicators that compare any organization target and real performance. Through the KPIs, organizations can evaluate their success at reaching the target. In fact, the main idea of KPI is very simple that is “If you don’t measure it, you can’t manage it”. According to this idea, KPI are crucial metrics for organizations, at the same time we need to track KPI for effective management capability. Such as, if you manage a sales team you have to track monthly sales growth. This KPI measures the sales revenue according to the sales target or compares with the same prior month. With help of these monthly sales Key Performance Indicators, you can get an idea about your sales trend so that you can decide the product prices or campaigns.

关键绩效指标（也称为KPI）是非常有效的指标，用于比较任何组织目标和实际绩效。 通过KPI，组织可以评估其在达到目标方面的成功。 实际上，KPI的主要思想很简单，即“ 如果不进行度量，就无法管理 ”。 根据此想法，KPI是组织的关键指标，与此同时，我们需要跟踪KPI以实现有效的管理能力。 例如，如果您管理销售团队，则必须跟踪每月的销售增长。 该KPI根据销售目标衡量销售收入或与上个月相同。 借助这些月度销售关键绩效指标，您可以了解您的销售趋势，从而可以确定产品价格或广告系列。

On the other hand, business intelligence solutions play key-role for organizations to make decisions about business so we need to virtualize KPIs in business intelligence reports. If we place KPIs in our BI reports or dashboards that offer to track KPIs regularly and assists to take proper decision.

另一方面，商业智能解决方案对于组织做出业务决策具有关键作用，因此我们需要虚拟化商业智能报告中的KPI。 如果我们将KPI放在我们的BI报告或仪表板中，以定期跟踪KPI并有助于做出正确的决定。

After this main description of Key Performance Indicators and getting through the importance of interaction with business intelligence solutions, we can start to talk about how to use KPIs in Power BI. In this article, we will create the demonstration over a production case scenario.

在对关键绩效指标进行了主要描述并了解了与商业智能解决方案进行交互的重要性之后，我们可以开始讨论如何在Power BI中使用KPI。 在本文中，我们将在生产案例场景中创建演示。

Business Case: Assume that you are report writer of a production company and there is a production line which is the vital part of the factory. This production line oil pressure value has to be 80 and this value indicates the optimum performance of the production line. Also, this value is collected one an hour and store into Azure SQL. Production engineers’ wants to track this production line oil pressure in their mobile phones and they also want to observe the last value of selected month and weekly Key Performance Indicators of this production line oil pressure values. After a little meeting with production engineers, you deal a draft design whi