Clicks Clicks Labeling reports with modified view descriptions Artists who present their works as “Untitled” usually have their reasons which we as observers can only speculate. Perhaps, the viewers should reflect the work without being biased or distracted by [...] Learn more
Clicks Clicks Level formats in Flexreports When someone talks about “user friendliness”, we generally think of some type of software or technical equipment that is easy to use. The German Automobile Association (ADAC) also uses this term to [...] Learn more
Clicks Clicks Step by step to an information-dense one-pager Controllers and honest journalists both share a yearning for the truth. One-sided reporting, however, can mean trouble for some and prestige for others. The German Press Council, for example, doesn’t [...] Learn more
Clicks Clicks Calculating and reporting percentages A few of our readers disapproved of our criticism of percentages in the June issue of clicks!: If you remember, we said that comparing them is, well, “cheesy” in certain cases. We thought, therefore [...] Learn more
Clicks Clicks Absolute, relative and weighted variance Consumers who are conscious about their health or figure religiously check the nutrition labels to see how much fat is in certain food. In England, on the other hand, they simply use traffic-light colors [...] Learn more
Clicks Clicks Graphical tables in cockpits and analyses In a song titled “Work” on his tribute album to Andy Warhol, Lou Reed quotes his former protégé saying: “You ought to make things big, people like it that way.” Warhol was a famous member of [...] Learn more
Clicks Clicks Selecting dimensions for the hyperbrowser Each spring, both professional and hobby gardeners are busy pruning their fruit trees so that they will have a bountiful harvest in the months to come. The perfect cut is a science in itself, and it can [...] Learn more
Clicks Clicks Filter measures, numerical filters and filters for member properties Most avid tea or coffee drinkers understand the value of a good water filter. In fact, consumers spend millions each year on special filter cartridges, pitchers or other distilling paraphernalia. And [...] Learn more
Clicks Clicks Formatting values based on views 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 [...] Learn more
Clicks Clicks Automatic sparkline exports with the TickerPortal Pictures first learned how to move at the end of the 19th century. These early “motion pictures” were little more than individual images shown in quick succession. This innovation soon spread into [...] Learn more
Clicks Clicks Recognizing and visualizing trends with the Trend barometer Who wants to simply follow the next trend, when being a trendsetter is so much more interesting! Or if you prefer to stay on the safe side, you can simply label something a trend – in this case then [...] Learn more
Clicks Clicks Locating distribution differences with Comparator At the beginning of the 19th century, David Ricardo set a milestone in classical economics with his theory on comparative advantage. In short, the core message of his theory simply says that each person [...] Learn more
Clicks Clicks Drilling Down Into Pivot Tables Using the Pivot Navigation Gesellschaft für Informatik (GI), the largest organization for computer science professionals in Germany, Austria and Switzerland, honors pioneers in this field with its annual Innovation Prize. And [...] Learn more
Clicks Clicks Distributing reports through the Web and Intranet with the DeltaMaster WebOption Back in the July edition of clicks! we explained how you can access the Web from DeltaMaster by creating hyperlinks in reports. But did you also know that you can also access DeltaMaster from any computer [...] Learn more
Clicks Clicks Time analysis members It’s often the little things in life that make a big difference. How on earth did we ever survive back in the days before Blackberries, one-button coffee makers, or our beloved iPods? These and other [...] Learn more
Clicks Clicks Links to reports and the Web Although it hasn’t yet reached its 16th birthday, the World Wide Web has already revolutionized our social and business lives. Its success is anchored by the concept of hypertext, an age-old idea that [...] Learn more
Clicks Clicks Event-driven report distribution through MDX “No news is good news” is a typical motto of stressed-out managers. But why, actually? Are managers simply pessimistic when they say that if they receive a message that it can only be something unpleasant? [...] Learn more
Clicks Clicks Budget/actual comparisons with trumpet curves "Making predictions is difficult, especially about the future," once commented the Danish physicist and Nobel Prize winner Niels Bohr. Who can argue with that? Wrong forecasts don't just come from the [...] Learn more
Clicks Clicks Multilanguage analytical reporting with aliases and alias sets The Directorate-General for Translation (DGT) of the European Commission is the largest translation service in the world. From its offices in Brussels and Luxemburg, the organization employs more than [...] Learn more
Clicks Clicks Rankings in pivot tables 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 [...] Learn more
Clicks Clicks Rankings and PowerSearch For many elite athletes and other overly ambitious people, winning is everything. You don’t win silver. You lose gold! The same applies in modern business. The bottom line for most companies today is [...] Learn more
Clicks Clicks Integrating images into Flexreports and combination cockpits Who says that there is no educational value in television? MTV, for example, has successfully enriched the vocabulary of millions of Europeans with colorful words, such as “to pimp”. In a 30-minute [...] Learn more
Clicks Clicks Search function in DeltaMaster One of a dog’s favorite pastimes is searching for things: primarily for food, but also for drugs, explosives, truffles (although rare), toys and sticks. Besides being just fun, searching has its incentives [...] Learn more
Clicks Clicks Working with views To ensure that we don’t get lost in the data jungle, DeltaMaster offers a series of helpful devices that track and secure our steps for the course of our expedition. Just as Gretel had Hansel and he [...] Learn more
Clicks Clicks Creating and customizing pivot charts DeltaMaster clicks!, of course, is not the appropriate medium to debate the do’s and don’ts of data visualization. But it is an ideal platform to explain how you can efficiently and effectively showcase [...] Learn more
Clicks Clicks Spruce up your pivot tables with chart and analytic features 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! [...] Learn more
Clicks Clicks ImportWizard – Preparing data for multi-dimensional analysis Preparing data in such a way that it can be analyzed fluidly can be an extremely laborious job. Techies use software that is known as ETL tools to do this. "ETL" stands for extraction, transformation [...] Learn more