DeltaMaster clicks! 09/2015

Grouping and classifying members individually

Greetings, fellow data analysts! One major advantage of OLAP databases is that you can create a data model that closely resembles your business structures. You typically group customers, materials, teams, cost centers, etc. into hierarchies that you can use in reporting and analysis. These structures are essential so that report consumers can gain the insights they need to drive business performance. Even though the OLAP data model represents how you usually want to view your data, there are times when Read More …

DeltaMaster clicks! 12/2012

Small Multiples with dynamic comparisons

Greetings, fellow data analysts! To be an informative speaker or writer, you should use concrete words – and, ironically, that’s often easier when you think abstractly. Abstraction doesn’t mean omitting things that aren’t important, but rather finding things in common. In reporting, for example, you rarely deal with just any old customers, product groups, or business divisions. You select them using set criteria based on a rule – customers with the highest revenues, product groups with the largest inventory, or Read More …

DeltaMaster clicks! 05/2009

Reusing axis definitions with named sets

Greetings, fellow data analysts! Sometimes people use a derogatory tone when they talk or write about textbook knowledge. We, on the other hand, feel that a good textbook can offer very useful advice. In the case of visualization, you can even start with a grade school textbook. Nowadays, 7th graders are already learning how they should view area charts*.By the 5th grade, many children have already learned about set theory, which shows how useful it can be to collect individual Read More …