DeltaMaster clicks! 05/2015

Pivot Navigation with a double click – predefining analysis paths

Greetings, fellow data analysts! Many regular sources of information follow specific conventions or guidelines regarding the content and order for reporting things. Standards for form and content make it easier to create and use reports as well. With DeltaMaster, you can even standardize things that are not part of the initial report – namely, the interactive steps to trace values and variances back to their origins. Using the Pivot Navigation, you can define and save analysis paths directly in a Read More …

DeltaMaster clicks! 03/2015

Linking reports – From a pivot table to detailed analyses

Greetings, fellow data analysts! The Brockhaus encyclopedia, once known throughout Germany as the epitome of a reliable information source, is now a thing of the past: The printed version was discontinued in 2014. New media and Internet portals such as Wikipedia sealed its fate. If you browse through their articles, however, you will sometimes miss the professional expertise that made the printed works so renowned. On the other hand, you probably do not want to miss the flexibility to jump Read More …

DeltaMaster clicks! 02/2015

Comparing positive and negative variances in the same report

Greetings, fellow data analysts! A general rule of writing says that the most important message belongs at the top, for example, in the heading or at the beginning of an explana­tion. That’s how we learned it, and that’s how we do it – in writing as well as reporting. When you analyze customers, products, materials, etc., you probably also sort them by a measure so that the most relevant objects appear at the top of the table. Yet in the Read More …

DeltaMaster clicks! 10/2013

Check list for DeltaMaster applications – Part 2: Pivot tables/graphical tables

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! 11/2012

Organizing pivot tables with additional gaps

Greetings, fellow data analysts! As a graphic designer, Otl Aicher has shaped the image of modern Germany. His pictograms didn’t just define the look and feel for the 1972 Olympic Games in Munich. Decades later, they still guide travelers through train stations and airports throughout the world. Aicher was one of the founders of the Ulm School of Design, which similar to Bauhaus is one of the most prominent schools of its kind. The real art of his work was Read More …

DeltaMaster clicks! 04/2012

Circles as in-cell charts in pivot tables

Greetings, fellow data analysts! The circle is a powerful symbol that dates back to ancient times. It has no beginning and no end – an allegory for the sun, completeness, and even perfection. When it comes to serious information, however, circles are often seen in a dubious light. Someone who talks in circles, for example, is neither getting ahead nor to the point. In data visualization, using circles in charts is questionable as well. The readers would have to compare Read More …

DeltaMaster clicks! 05/2011

Editing pivot tables faster – with the mouse and control keys

Greetings, fellow data analysts! It’s amazing how quickly (and frequently) young people type text messages on their mobile phones. Nowadays, you don’t even need to press any buttons. If you have a handheld, smartphone, or tablet, you simply need to wipe or touch the screen to tell the computer what you want to communicate with someone else. This works on account of the devices’ technical capabilities but also because you hold them in your hand. After all, it is not Read More …

DeltaMaster clicks! 03/2011

Nested axes in pivot tables

Greetings, fellow data analysts! As the old saying goes, there is a time and place for everything. In good literature, for example, highly elaborate and intricate styles of writing are often a pleasure – or sometimes a pain – to read. Yet, if you have to communicate a message that people should understand quickly, it is probably best to use clear, simple language.When you analyze data from multiple dimensions, you also need a certain level of complexity. Yet, that can Read More …

DeltaMaster clicks! 03/2007

Rankings in pivot tables

Greetings fellow data analysts! Business is complicated enough. Fortunately, analyzing it doesn’t have to be! Rankings, for example, are simple, sleek and effective – the next best thing to an iPod for data analysts. Ironically enough, their simplicity is what makes many people so skeptical. A “no pain, no gain” mindset, we suppose. Rankings, however, contain an amazing amount of information – if you take the time to read between the lines. When combined with graphical tables, they present and visualize Read More …

DeltaMaster clicks! 09/2006

Spruce up your pivot tables with chart and analytic features

Greetings, fellow data analysts! In the world of data visualization, tables are a prime example of “oldies but goodies” – especially when you can twist and turn them any way you’d like. We’re talking, of course, about pivot tables! Pivot tables allow you to transform multidimensional data models so that you can create multidimensional views, slices or partial cubes and even reorganize dimensions or measures to answer your most probing business questions. In addition to these typical OLAP functions, DeltaMaster provides Read More …