DeltaMaster clicks! 08/2017

Adapting the filter context – selecting what can be selected

Greetings, fellow data analysts! Complexity and flexibility go hand in hand in controlling applica­tions. For instance, think of the filters with which you set the month, customer group, product group, cost center, etc. to which reports are to refer: The more attributes, the more flexible you can be in configu­ring a report, but there are also more conditions to keep in mind and understand. DeltaMaster automatically eliminates some things that are created in the database but are not relevant to Read More …

DeltaMaster clicks! 07/2017

Setting rights for reports and folders

Greetings, fellow data analysts! Different views for different users. In companies, when working with software and figures, people often need to work with the same type of information, but not necessarily with the exact same information or in the exact same way. Rights are the key to handling this. The same database or the same controlling application can have a different appearance and behave in different ways depending on who is working with it. In DeltaMaster, this applies to reports Read More …

DeltaMaster clicks! 06/2017

Search functions in DeltaMaster

Greetings, fellow data analysts! In the past, when there was still a number of different search engines on the Internet, they were divided into two different categories: catalog-based and index-based. Catalogs such as DMOZ, Yahoo, and web.de arranged websites into a given structure, whereas index-based services such as Google or Bing prepare websites for individual search queries. Catalogs barely feature on the Internet these days – perhaps because the Internet is too unstructured for them. In business intelligence applications, it Read More …

DeltaMaster clicks! 05/2017

Formatting numbers in a compact and decision-oriented way

Greetings, fellow data analysts! Management information is not about the decimal places – control¬ling is not accounting. Decision-oriented management reports make an impression when they report on an appropriate scale, i.e. in thousands or millions, whichever applies. That way, numbers are shortened to the key digits, making them easier to read and understand. We explained how this can be done in DeltaMaster some time ago. In DeltaMaster 6, it is even more elegant: The “whichever” is now dealt with automatically, Read More …

DeltaMaster clicks! 04/2017

Wrapping long or wide tables

Greetings, fellow data analysts! Does this ring a bell? The report is long and the screen is wide. Scrolling is tedious and interferes with reading. Help is at hand with the Graphical Tables from DeltaMaster 6: They support table wrapping, which distributes long tables over multiple display columns and wide tables over multiple display rows – dynamically and automatically, depending on the data to be displayed and the available screen space. Some people call this “responsive design” – but it Read More …

DeltaMaster clicks! 03/2017

Setting up data input for planning – An overview

Greetings, fellow data analysts! In the last issue, we discussed how DeltaMaster can make it easier for you to input data in planning applications. Most of the functions described are available in all applications without having to be set up specifically for this purpose. However, some functions do need to be set up, while you will get more benefit from others if you prepare them carefully. These tasks are the responsibility of report editors and application administrators. This issue of Read More …

DeltaMaster clicks! 02/2017

Inputting data in planning applications – An overview

Greetings, fellow data analysts! When we demonstrate how DeltaMaster can be used to analyze variances during seminars and webinars on reporting, we sometimes find ourselves being asked the question: Where do you actually get the planned figures from that you use to calculate the variances? The answer is simple: From DeltaMaster! Some people may use it solely as a reporting and analysis tool, but for others, it is the most important instrument for collecting and storing planned figures. In this Read More …

DeltaMaster clicks! 01/2017

Calculating and displaying shares automatically in Graphical Tables

Greetings, fellow data analysts! Fulfilling some of the analytic requirements from business departments is often easier said than done. Let’s assume that your new marketing director wants to know what the current demand profile is and how it has changed over time. But what is a demand profile? How would you describe it or show its development? A little business sense is helpful to begin with. A demand profile could be the revenue breakdown by article groups. You could then Read More …

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

Predefining a Navigation for specific measures

Greetings, fellow data analysts! Let’s stick with the navigation (Pivot Navigation): Sometimes you may want to establish some sort of standard agenda within a department – a common approach how data should be analyzed and discussed. With DeltaMaster, report editors can predefine a series of analytic steps so the recipients can easily follow this common thread. When a user double clicks on a value or selects Navigate/Plus in the Analysis menu, DeltaMaster will add exactly one attribute to the table Read More …