Defining key performance indicators

You can define a KPI within the SSDT tab called KPIs by specifying the value, goal, status, and trend expressions along with optional properties. A KPI's value is a measure, its goal is the ideal value of the calculation, the status shows the relative condition of the measure compared to the goal, and the trend indicates whether the business is moving closer to the target. For example, the Adventure Works sample database has a KPI called Growth in Customer Base. This KPI is built upon the [measures].[growth in customer base] measure which compares the current time span's customer count with that of the previous time span: the current year is compared to last year, the current quarter is compared to last quarter, and so on. The goal is arbitrarily set to 30 percent increase for each fiscal year, 15 percent for semesters, 7.5 percent for quarters, and 2.5 percent for months. The KPI's status is shown as a green check mark if the goal is met or with a red...