chartisan
chartisan GmbH is a specialist consultancy and implementation partner working in the field of controlling and reporting. Our expertise lies in the areas of report automation and data visualization. For our customers, who comprise corporations active on the global stage, medium-sized businesses and administrative bodies, we combine comprehensive cross-sector theoretical and practical experience from the areas of controlling, management/organisation and IT.
Illustrate variations
Knowledge @enIt´s mostly about variations when presenting data to decision makers, such as planned, target or empirical values. Only these variations allow us to reasonably evaluate the actual numbers. Variations should play a major role during the visualisation as well. Today´s trick shows us that this is feasible within Excel only with a few clicks in […]
Direct captioning of diagrams
Knowledge @enData captions and legends are important to understand the content of diagrams. Unfortunately the provided alternatives to caption are partially not legible. For example, sums on top of piled columns are not provided. You search in vain for standard functions such as legends which support the viewer not to look back and forth as they are […]
Correct scaling of multiple diagrams
Knowledge @enIn many cases it is important to allocate data to multiple diagrams so the presentation is clear. It results in so-called Small-Multiple illustrations. If each single diagram uses its own scale, the informative value of the entire page will get lost. In terms of a high quality visualisation, unitary scales are very important. At the […]
Visualise strategic portfolios competently
Innovations @en, Knowledge @en, Projects @enThe origin of portfolios is in finance and describes a planning method of compiling a package of security papers (security holdings) dependent on to the criteria of return and risk. Later, this method has been applied to other areas in the 70ies. Since that time the portfolio analysis has been modified in many […]
Visualise surveys legibly
Knowledge @en, Projects @enOpinions, trends and behaviours – the interest in surveys is growing steadily. Numerous evaluation results are prepared and presented daily. Diverse ways of visualising the results are available, still some essential basics should be considered. Good to know: Survey results are most interesting when the reader can quickly draw comparisons. When executing the primary demands, […]
Buchrezension: Few – Understanding What Matters in a World of Noise
Innovations @en, Knowledge @enIm letzten Blogartikel habe ich es angekündigt. Hier also mein Eindruck der druckfrischen Ausgabe von Stephen Fews neuem Buch: „Bessere Entscheidungen können nur durch besseres Verständnis kommen. Informationstechnologien sind nicht der Schlüssel zu besseren Entscheidungen, das sind wir. Technologien können unser Denken erweitern, aber nicht ersetzen. Computer haben ein neues „Datenzeitalter“ eingeläutet. Das „Informationszeitalter“ wird erst […]
Bullet Graphs: 5 disadvanteges you can avoid
Innovations @en, Inside @en, Knowledge @enWhat are Bullet Graphs and where are they used? Key data overviews on dashboards are easier to understand by visualisation. The realisation is quite difficult, because standardised diagrams are uneligible for this function. Bullet Graphs, a special type of bar diagrams, have been especially developed by Stephen Few. Basically they are very suitable for those […]
Sales Dashboard mit Excel
Innovations @en, Inside @en, Projects @enEin kleiner Projekt-Einblick in ein übersichtlich aufgebautes Sales Dashboard. Durch die Realisierung in Excel, ohne etwaige Plugins oder VBA-Programmierung, lässt es sich komplikationslos von jedem Office-Anwender nutzen und verteilen. Die Datenaufbereitung basiert in diesem Beispiel auf Pivot-Tabellen. Eine Datenbank-Anbindung ist problemlos möglich. Das ist keine Zauberei oder ewige Tüftelei. Versprochen! Wenn Sie unsere Lösung interessiert, […]