INSEDE Institute for Sustainable Economic Development

kpisquare and vector profiles - this is how correlations now become visible and communicable

On this page you can see different templates that visualize two indicators (monetary, non-monetary, subjective, objective) for different clusters (markets, departments, profit centers, subsidiaries, business units...) in a single presentation.
To the right of the illustrations you will find a link where you can download the corresponding file for Excel 2010 (for your personal, non-commercial use). For more information about the origin of the data etc., please refer to the Excel file.
You can use the templates for your own data. The files are not protected, contain no macros and do not exchange information. The elements in the charts can be changed with the usual Excel commands.

Hint/Recommendation:

• Look for the representation which contains at least the number of clusters you want to consider. (You can "zero" clusters that are not required and edit them in the chart as desired).

• Use for the comparison of data series - for example of budget and invoice or two companies - the pure vector representations (without colored rectangles). Although the interpretation takes some getting used to. But the transparency of direct comparisons improves, and the limits of application are almost unlimited.

• You get "drill-downs", if you copy the first page as many times and "put behind" the first page as you have planned "clusters". Structure the elements of the "sub-clusters" according to your needs and link the sum to the corresponding fields on the first page.

• Connect external (web) with your internal data by linking the corresponding fields with the data from the web.

Beyond 'kpisquare':
'kpisquare' is part of 'Business Engineering Systems' (Framework and metrics for smart economy).
'Business Engineering Systems' is part of 'INSEDE' (Institute for Sustainable Economic Development).
'INSEDE' is part of 'Project NEMO' (New/Next Economic Model).

Legal:
The representations are proprietary and part of the Business Engineering Systems (Registered Copyright TXu512154).
Private use is allowed without restriction and without license. Creating derivative works and commercial use requires a registered license (end-user, consultant, education, software).

Questions/Feedback:
Questions about adapting the templates to your needs, licenses etc.. please send an email to peter.bretscher@bengin.com with the note "kpisquare".
Thank you for any comments about errors and for improvements.
Peter Bretscher, Engineering Office for Economic Development, Alpsteinstrasse 4, 9034 Eggersriet, Switzerland
Mobile: ++41 79 650 49 04

On this page you will find more and more examples. Just have a look again.	Pattern with 4 cluster x-axis: Number of people y axis: Assets they control [in $] https://bengin.net/beta/04_global_wealth_vector_cs_e.xlsx                 5 (or 4) Cluster x-Axis: Net sales y Axis: Operating Results, CO2 and Water (3 examples) The Excel file contains three examples of Hilti with figures from the financial statements and the environmental impacts (CO2 and water) https://bengin.net/beta/05_HILTI_operating_result_net_sales_e.xlsx                  Pattern with 5 clusters x-axis: Expenditures for 5 different services (clusters) provided to customers (in %). y-axis: Survey of customers, how much value they attach to the different services (in %) https://bengin.net/beta/05_cost_value_vector_e.xlsx                 Pattern with 10 clusters Survey in different countries on how employees are engaged (Gallup survey). x-axis: % of employees who are committed y-axis: % of employees who are "actively" not engaged. https://bengin.net/beta/10_global_workplace_gallup_2011_e.xlsx                 Pattern with 10 clusters The first nine energy companies of Fortune 500. x-axis: Revenues [$] y-axis: Profits [$] https://bengin.net/beta/10_fortune500_energy_rect_e.xlsx                 Pattern with 10 cluster x-axis: Yields of the different companies [$] y axis: Profit of the different companies [$] The Excel file contains four examples with data from the Fortune 500 (total list, computers, banks, energy). https://bengin.net/beta/old_new_10_fortune500_cluster_rect_standard_v0.99_e.xlsx          2 vector profiles with 5 clusters x-axis: Number of employees in the corresponding departments. y axis: Revenue in the corresponding departments. The steeper the vectors, the better the performance. https://bengin.net/beta/pwc_ey_2_performancevector_1blatt_d.xlsx                  Special package Municipalities: Here you will find a package of 15 examples (with links to the templates) for municipalities. The brochure with about 50 pages contains explanations of the vector as well as notes on the structure of the files and how to customize the charts in Excel. (in German language) Special: Creating vector profiles "without background": pages 14 to 25 Customize the "vectors with background": pages 26 and 27 Download PDF
(C) 2011/2020, Peter Bretscher, peter.bretscher@bengin.com - bengin.net - insede.org Ingenieurburo fur Wirtschaftsentwicklung, Alpsteinstrasse 4, CH-9034 Eggersriet, Switzerland