Changing the way you learn

USING EXCEL TO MEASURE THE SUCCESS OF STRATEGIC INITIATIVES

KEY TERMS:
1. KEY PERFORMANCE INDICATORS (KPIS)
2. EFFICIENCY
  Annotations:
  - Comparing inputs to output
3. BENCHMARKS/BENCHMARKING
4. TYPES OF METRICS
  1. IT
  2. SUPPLY CHAIN
  3. CRM
5. BALANCED SCORECARD
6. UNITS OF MEASURE
7. PRECISION/MATERIALITY
8. SAMPLING
9. TYPES OF MEASURES (COUNTS, RATIOS, AVGS, ETC)
10. PATTERNS/TRENDS
11. MATERIALITY
  Annotations:
  - The relevance of precision
CONCEPTS
1. CHARACTERISTICS OF IDEAL MEASURES
  1. SIMPLE
    Annotations:
    - Straightforward and understandable
  2. PRECISELY DEFINABLE
    Annotations:
    - clearly defined so that can appy and evaluate them
  3. OBJECTIVE
  4. VALID
    Annotations:
    - Measures precisely what is intended
  5. ROBUST
    Annotations:
    - Not sensitive to changes in process of product
2. WHAT'S THE IMPORTANCE OF MEASUREMENT?
3. HOW DO YOU DEVISE AND CONSTRUCT PERFORMANCE MEASURES?
4. HOW TO EXAMINE MEASURES TO UNCOVER PATTERNS AND TRENDS
5. BASIC MEASUREMENT CALCULATIONS
  1. COUNTS, RATIOS, AVGS, AND VARIANCES
6. In your freshman year at BYU, you earned a 3.47 GPA. Your sophomore year, you earned a 3.61 GPA. What is the percentage difference between the GPAs you earned your freshman year and your sophomore year?
  Annotations:
  - find out the difference between the two and then divide that by the starting amount and multiply by 100
7. In your freshman year at BYU, you earned a 3.47 GPA. Your sophomore year, you earned a 3.61 GPA. Assuming you took 10 credits your freshman year and 18 credits your sophomore year, what is your cumulative GPA?
  Annotations:
  - 3.56

Next up

USING EXCEL TO MEASURE THE SUCCESS OF STRATEGIC INITIATIVES

Description

Resource summary

Similar

	Created by erocespinel over 10 years ago