DeltaMaster clicks! 01/2016

Adding member properties in self-service applications

Greetings, fellow data analysts! The data required for management information is not always already available in the data warehouse. Sometimes, you have to piece it together from Excel spreadsheets, Access files, or other sources at a spur of the moment. Today, this is called Self-Service BI – and DeltaMaster is the optimal tool for these types of tasks. The software supports you not only in analyzing and visualizing data but modeling new data sets as well. Best of all, you Read More …

DeltaMaster clicks! 12/2015

Analyzing, modeling, and automating with member properties

Greetings, fellow data analysts! In The BI Survey 15, DeltaMaster ranked first within its peer group in five categories. One of them was project success, where users measured their ability to complete projects on time and on budget. The high implementation speed of DeltaMaster projects is possible, in part, because you can modify and extend DeltaMaster applica­tions quickly – oftentimes without even having to change the underlying database. To create new structures and KPIs, you simply reuse what is already Read More …

DeltaMaster clicks! 11/2015

Providing information through member properties

Greetings, fellow data analysts! A member property is a typical example of an abstract database term that has a very practical use in applications. In DeltaMaster, member properties come to life as images in reports, weight or size informa­tion for products, population numbers of regions, cost center names (in place of numbers), the way you address report recipients, and in many other situations in which you describe report objects (members) in more detail. DeltaMaster offers vast support for member properties Read More …

DeltaMaster clicks! 10/2015

Cell comments – Writing, administering, and aggregating comments on individual values

Greetings, fellow data analysts! As you well know, you can use Business Intelligence applications to view and analyze numbers in great detail. These numbers tell you who, what, when, where, and how much – but never why. This answer requires language – spoken or written – right alongside your data. That is why DeltaMaster offers rich functionality for adding comments. Users can enter comments in each report and, in the case of pivot tables, even on individual values. The following Read More …

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! 08/2015

Early warnings with clever KPIs

Greetings, fellow data analysts! Entrepreneurs and managers have hoped to gain competitive advantages from sophisticated analytic technologies long before Big Data started making headlines in daily newspapers. Our experience from countless analysis projects, however, shows that all-knowing algorithms don’t necessarily reveal the best tips on what work is yet to be done. Oftentimes, the most valuable insights come from well-thought-out KPIs that are analyzed with robust methods. The secret here is asking the right questions and figuring out how to Read More …

DeltaMaster clicks! 07/2015

Tips and tricks for cumulated values

Greetings, fellow data analysts! The shortest route between Boston and Philadelphia is 490 kilometers. That is about the distance of the longest stage ever at the Tour de France – and only one of fifteen at the 1919 tour. Like always, there was a proud winner at the end of the day’s race. Someone else, however, wore the famous yellow jersey (Maillot Jaune). Outstanding performance during one stage of a race is one thing; however, it’s the overall classification that Read More …

DeltaMaster clicks! 06/2015

Highlighting changes automatically in updated reports

Greetings, fellow data analysts! You can often make processes much more efficient by focusing on changes. Loading a data warehouse, for example, is much faster when you concentrate on new and modified records (i.e. delta load). Video films are compressed by first saving a few reference images – instead of them all in their entirety – and then calculating the smaller difference images. To discuss legislative changes more quickly, lawyers and poli­ticians compare the old and new versions and highlight Read More …

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! 04/2015

Identifying similar value distributions with the cluster analysis

Greetings, fellow data analysts! The vast, built-in library of analysis methods is one of the strengths of DeltaMaster. Although the special algorithms, heuristics, and report formats in Miner mode usually stand out the most, the software offers many other functions that deliver new insights within tabular reports as well. One example is the cluster analysis, which searches for similar structures in the report data and highlights what deserves attention. This function is so subtle and simple to use that we Read More …