DeltaMaster I: Compact Training

A one-day overview of all key functions and modules for working with existing applications.

• Introduction: Philosophy and architecture
• Basic functions: Browse, zoom, navigate
• Modeling (self-service BI): Connecting to new data sources
• Editing: Graphical Tables, links and navigation, analytics
• Publishing: Report distribution and Repository (overview)
• Help functions and sources of know-how

DeltaMaster II: Report structuring and analysis

All of the key details on working with Graphical Tables: conceptual background information, technical implementation, correct visualization.

• The Bissantz reporting standards
• Graphical Tables: Axis definition, context menu, table properties
• Analytics: Ranking, concentration analysis, time series analysis, portfolio analysis, SQL drill through
• Calculated members
• Application logic and workflow: Navigation and links, report comments
• Report organization and properties

DeltaMaster III: Report organization and distribution

Concentrated expertise on administering, updating, distributing, and publishing reports and analyses using the push and pull principle.

• Architecture and central components: Publisher and Repository
• Application administration: Repository role administration
• Push procedure: Office, PDF, e-mail, DeltaApp
• Pull procedure: Web option, add-in for Office, DeltaMaster app
• Layout and CI: Adjusting format templates

SQL: Introduction to relational databases and the SQL query language

One-day beginner’s/refresher course on relational databases, modeling and the SQL query language.

• Principles of relational modeling
• Normalization, keys and indexes, types of link
• Structured introduction to SQL and the key elements of the language

MDX: Introduction to the Multidimensional Expressions database language

Two-day introduction to the MDX query language based on useful practical examples in DeltaMaster.

• MDX principles for BI users
• Introduction to MDX syntax (terminology, structure)
• Identifying and using the most important MDX objects (tuples, sets, members)
• Understanding how DeltaMaster uses MDX
• Navigating hierarchical trees using MDX
• Working with MDX operators and functions, e.g. Ancestors, Descendants, CrossJoin, etc.
• Calculating KPIs using MDX (aggregates, rankings, etc.)
• Using the acquired principles in DeltaMaster (axis definition, measures, named sets, etc.)
• Numerous exercises to reinforce the acquired knowledge

OLAP: Modeling using Microsoft SQL Server and Analysis Services

From raw data to the finished application in two days: Creating a complete BI solution using Microsoft Data Tools for BI.

• OLAP: Concept and terminology
• Extracting and loading with SQL Server Integration Services (SSIS)
• Attribute-based dimensional and hierarchical structure
• Cubes and measure groups
• Calculated members
• Aggregations, partitions, and writeback
• Semi-additivity and discretization
• Administration: Backup/restore, permissions concept

ETL: Automated and standardized model generation using DeltaMaster ETL

Automated and standardized model generation using DeltaMaster ETL for greater flexibility and error-proofing.

• Automation, optimization, and standardization of data models
• Modeling through metadata maintenance in
• Automatic generation of the snowflake schema and of relational data transformations
• Automatic generation of the entire OLAP model
• Integrated support for troubleshooting

Individual DeltaMaster training

One-day or two-day DeltaMaster training on all of the key functions and modules based on your own data – irrespective of which version of DeltaMaster you have.

The content of the training is individually adapted to your requirements but can draw upon the DeltaMaster I – III training programs. All that is required is a good training infrastructure, i.e. a sufficiently large training room, a video projector, and a computer for each participant with DeltaMaster installed (including database access).

DeltaMaster-Individualschulung

Eine ein- oder zweitägige DeltaMaster-Schulung zu allen wichtigen Funktionen und Modulen auf Grundlage Ihrer eigenen Daten – unabhängig von Ihrer DeltaMaster-Version.

Der Schulungsinhalt wird individuell an Ihre Bedürfnisse angepasst, kann jedoch an die Schulungen DeltaMaster I – III angelehnt werden. Voraussetzung: Lediglich eine gute Schulungsinfrastruktur, d. h. ein ausreichend großer Schulungsraum, ein Projektor, für jeden Teilnehmer einen Rechner, ausgestattet mit DeltaMaster (einschließlich Datenbankzugriff).