Combined Performance Index

BPM-combIn order to limit the number of Key performance Indicators (KPIs), and maintain clarity and conciseness of a dashboard, sometimes it might be useful, to combine a set of performance indicators into one single key performance indicator. This latest episode of my podcast will show, step-by-step, how you can build up a combined performance index. using

  • a target value,
  • a base value and
  • a weighting

for each individual indicator. It also gives an example how to implement this concept in an Excel spreadsheet.

BPMSG Podcast on Feedburner

 

Value Driven Leadership

  • Succession planning for leadership positions plays an important role for the future business of any company. Leaders have not only to have a strategic view, good management skills and the necessary technical knowledge. With their behavior they also determine the motivation of their teams and employees, and with that finally the productivity and profitability of the whole organization.
  • Leaders have to give an example, they need to show initiative and have to be efficient. In a continuously changing business environment leaders need also to be open to new experiences, and they must show willingness to change. Emotional intelligence and critical self reflection combined with integrity will yield to mutual respect of their people, and result in a high acceptance for necessary business decisions.

Only with the right values behind people driving their behavior, the most important pre-condition for a successful leadership is met.

But how to assess these values?

NEO-select personality test is a tool to get a better insight in the different strengths of individuals. The test is developed based on the model of the big five dimensions of personality, and is conducted as a self-reporting assessment. Using a combination of selected facets in these dimensions, a ranking of leadership values is derived. It will give the person a better insight in his or her behavior, and the driving forces behind it.

  • The test is not equivalent to the commercial inventory on which it is based, the NEO PI-R™, but it is constructed from the public domain IPIP items, assembled by Dr. Lewis R. Goldberg.
  • The inventory does not reveal hidden, secret information. The five dimensions (broad domains) cover normal differences in personality that should be obvious to people who know the person well. NEO-select is designed to complement other assessments of job suitability, as for example the Harrison Innerview or others.

Interested?

Conjoint Analysis – Example in Excel

Conjoint analysis or stated preference analysis is used in many of the social sciences and applied sciences including marketing, product management, and operations research.

Here you find an simple example, how you can calculate part-worth utilities and relative preferences in Excel using multi-variable linear regression. (4 attributes, 2 level, fractional design)

PLEASE READ before DOWNLOAD
The template is free. So I would really appreciate, if you could – at least – rate the template at the bottom of this post. Thank you!

Download Conjoint Analysis Example in Excel (zip):  download

Download Slides (pdf) of my Youtube video: “Conjoint Analysis in ten minutes“.

Conjoint analysis onlineConjoint.ly

Please feel free to leave a comment on my feedback page.
Contact

Incoming search terms:

  • conjoint analysis excel