FlowSheet Data Workbench

Without script programming!

The graphical editor of the FlowSheet Data Workbench is the most advanced modelling tool for data flow graphs!

The simple and intuitive way of modelling with your data in real-time is supported by powerful functions of data inspection (even on several displays) and a context sensitive help system. Owing to parallel program execution you can model simultaneously while your data flow graph is being executed.

Collaboration in a team as well as seamless integration into the ANKHOR server world establishes the FlowSheet Data Workbench as the central tool for the greatest diversity of data projects.

Data Sources

ANKHOR FlowSheet supports a multitude of data sources and the processing of various kinds of data. An arbitrary number of data sources can be used at the same time. Next to the data of the data import you can also gather data and use it as a source. Numerous editing functions ease the handling of that constant data. ANKHOR FlowSheet does not restrict data to simple data types like numbers, strings or date values but processes even complex data types in a very simple manner.

File Files

Wizard operators make it easy to import data from Microsoft Excel files, CSV and text files with a fixed column layout. Moreover, numerous other data formats are supported and can additionally be extended.

File Web

ANKHOR FlowSheet allows for processing external data from the Internet via HTTP or FTP accesses. Web access is simplified by XML based function calls, e.g., through SOAP or RESTful APIs and data formats like JSON and MHTML.

File Database

ANKHOR FlowSheet accesses databases with an ODBC connection and SQL queries. The database accesses can also be modelled inside the ANKHOR data flow paradigm (compiled SQL).

List of supported file formats:

  • Microsoft Office Excel (.xls, .xlsx)
  • Comma-separated values files (.csv)
  • Text files with fixed column width
  • Text files (.txt) with Parser and Lexer Support
  • Key-Value lists (e.g. name=Bob,lastname=Wolff,gender=male)
  • XML - Extensible Markup Language (.xml)
  • SPSS - Statistical Package for Social Sciences
  • SQL-Dump (.sql)
  • Microsoft Outlook (.pst)
  • dBase (.dbf)
  • GDPdU - Grundsätze zum Datenzugriff und zur Prüfbarkeit digitaler Unterlagen
  • Apache Log (.log)
  • SAP ALV Lists
  • Images (.jpg, .png, .gif)
  • Scalable Vector Graphics (.svg)
  • XES - eXtensible Event Stream (.xes)
  • Binary files with parser support for bit sequences
  • Compressed files (.zip, .gz etc.)

In addition ANKHOR FlowSheet supports many file system functions.

ANKHOR FlowSheet data types

The supported data types by ANKHOR FlowSheet are:

  • Integers and floating point values
  • Strings of unlimited length
  • Boolean (TRUE/FALSE)
  • Tables
  • Lists
  • Absolute time (date / time) and relative time (time periods)
  • bit sequences
  • Name / value pairs ("tags") and lists thereof ("Tag Lists")
  • Enumerations: numbered amounts of textual constants, e.g. days of the week

For programming and output in the Dashboard ANKHOR FlowSheet supports other data types:

  • Errors
  • Empty tables "empty"
  • Neutral values "neutral" (unused / uninitialized cell)
  • Colors
  • Formatting values
  • 2D and 3D points

Data Processing

ANKHOR FlowSheet is deployed with a large library of operators, which cover a large spectrum of applications. Among others, are supported:

File Data Preprocessing

Data consolidation, ETL processing (Extract - Transform - Load) and data cleansing are also important basic functions in ANKHOR FlowSheet's data pre-processing libraries.

File Spreadsheet

ANKHOR FlowSheet picks up the approved principle of spreadsheet calculation and takes it to the next level, since it overcomes the known problems and restrictions of spreadsheets with a visual approach for data manipulation.

File OLAP Data Cubes

ANKHOR FlowSheet can generate multi-dimensional OLAP data cubes directly from tables in a highly optimized in-memory way, and it provides numerous intelligent operators for Drill and Slice-and-Dice Analysis as well as for data aggregation. Video

File Advanced Analytics

Data analyses are supported in ANKHOR FlowSheet with a multitude of analysis methods from the areas of data mining, statistics and prediction. Specific methods of analysis can be extended through the library system.

individual processing

ANKHOR FlowSheet can also be extended individually, owing to the integrated programming language. Model your own processing in the same graphical paradigm (without having to learn additional script programming). For this use the built-in operator primitives, the combination with operators from the libraries or adapt your already existing operators to your own requirements. Integrating external data processing such as in R or Python is also supported.

Charts, Graphs and Visualizations

Present your data with the impressive built-in charts. Various charts types, sparklines or 3D diagrams form a basis for expressive data visualizations. Special requirements can be realized with the Chart Construction Kit.

Without limits visualizations in ANKHOR FlowSheet reach the third dimension, with 3D vector presentations and optional ray tracing. In addition visualizations of geographical data based on the OpenStreetMap project are supported besides further technical and scientific visualizations.

Interactive Dashboards

Quickly and simply generate interactive Dashboards. Aside from your data - regardless whether as a table, chart, visualization etc. - you can use input elements for manually entering data as well as elements for designing your own user interface. In addition, graphical user interfaces from the wizard operators can be integrated, too.

And without requiring an additional adaptation, interactive Dashboards from an ANKHOR server can step into action immediately on a browser. Check it out:

Simple interactive dashboard sample of an recursive file directory tree.
Click the interactive visualization to drill in and out.

OPEN

Interactive dashboard of an Finite Element Methode (FEM) visualization.

OPEN

Process Mining Analysis Dashboard of an SAP™ Procurement Process.

OPEN

Interactive dashboard of energy data to explore virtual CPU meters of a server farm.
This sample dashboard uses the timeseries analytics libraries of ANKHOR FlowSheet Workstation.

OPEN

Interactive dashboard with graph set processing to explore a webaccess dataset (surfed sites are blue, sites loaded in background are red).

OPEN

Visual Data Exploration Dashboard of an Olympic Medal dataset using the DataCube Dashboard Filterset library.

OPEN

Deployment


Applications

Use ANKHOR FlowSheet to create applications for execution in the Dashboard of the FlowSheet Data Workbench, or for the command line client for batch processing or for one of our server products.

Reports and Documents

You can export the output of the FlowSheet Dashboard for your reports, but also create structured documents ready for printing. Your reporting becomes a special experience with the interactive Dashboards.

Data Services

The data processing of ANKHOR FlowSheet can be integrated with other programs written in C++ or C# via a DLL or be used simply as a web service with an ANKHOR server.

Ad-hoc analysis

Model data analyses simply and quickly with the intelligent operators in ANKHOR FlowSheet and gain deeper insight into your data quickly.

Platform Basics

In-Memory-Verarbeitung In-Memory Processing

ANKHOR FlowSheet is already optimized in its foundations for processing large amounts of data in main memory. For this it employs not only an efficient data compression but also optimizes the structure of the data and incorporates it into the data management.

Programmiersprache Programming Language

A Data Workbench must be flexible and extendable. For this, programming is essential. ANKHOR FlowSheet uses its own programming language, which integrates into the visual paradigm and makes additional script programming redundant.

parallele Ausführung Parallel Execution

The data flow graphs used by ANKHOR FlowSheet are optimal for parallelization of data processing and allow for parallel execution on several processor cores without the user having to consider this while constructing the graphs.

Newsletter Subscription

By subscribing to our newsletter, you will regularly receive tips and tricks, promotional offers and information on the latest developments around ANKHOR FlowSheet.