DeltaMaster clicks! 12/2016

Using Data from Microsoft Excel as a Measure

Greetings, fellow data analysts! When you are searching for new insights in data, you sometimes need to draw on new data – data that goes beyond what is offered in a data warehouse and, quite possibly, will only be collected for a specific purpose. For example, you may want to supplement the information that you provide on a regular basis with special analyses that stem from other systems or you might want to include external data, such as raw material Read More …

DeltaMaster clicks! 01/2014

Check list for DeltaMaster applications – Part 4: Nomenclature

Greetings, fellow data analysts! Companies spend a great deal of time and effort collecting, saving, preparing, and consolidating data – and, ultimately, making reports. But if a report is read and understood or even triggers a reaction doesn’t just have to do with the quality of the underlying data. The design plays a key role as well. When it comes to designing reports, DeltaMaster already answers many open questions and takes over a range of tasks, for example, through reasonable Read More …

DeltaMaster clicks! 01/2010

Using business effects as color criteria

Greetings, fellow data analysts! How many different colors does a map need so that no neighboring areas have the same colors? Although it seems rather simple at first, this very question occupied mathematicians and cartographers for centuries. In 1976, Kenneth Appel and Wolfgang Haken discovered that four colors suffice. To answer this question, they applied a procedure which was developed by the German mathematician Heinrich Heesch in 1950 but only executable with the help of computers 26 years later. Most Read More …

DeltaMaster clicks! 02/2008

Formatting values based on views

Greetings, fellow data analysts! Pi, the mathematical constant representing the ratio of any circle’s circumference to its diameter, has fascinated mathematicians for centuries. In their attempts to approximately identify its exact value, they have produced a wide range of algorithms and traced the number to over a trillion decimal places (not to forget the “3” before the decimal point). “It’s absolutely useless – but an incredible feeling!” explains Professor Albrecht Beutelspacher from the Institute for Mathematics at the University of Read More …