Data Management

your Data

Fusion, join, clean, enhance and aggregate your data with a set of unique functionalities that can be used by anyone. Our Data Flow designer is perfect for simple and complex data processing tasks.

header platform data management

Powerful Data Management

  • Fusion

    Our Data Fusion is available to combine identical or similar tables into one. It is ideal to produce a combined view of all your data across multiple regions or business units that have local databases.

  • Merge

    Relationships between tables from the same or different systems is sometimes required.  Our Data Merge functionality gives you the flexibility to join tables in many different ways to get a single data set.

  • JSON & XML Parsing

    Data sometimes comes in different shapes and we have the tools to convert free data structures such as JSON and XML into columnar data for fast aggregation.

  • Pivot & UnPivot

    When your data is already pivoted and you need to convert it into a flat structure or when you want to pivot some data so it's ready to use in other data processes or visualization.

  • Cleaning and Standardization

    Proper analysis and visualization requires clean data. We have several easy to use data transformation nodes that make this easy for you to do in just a few clicks.  

  • Simple and Advanced Filtering

    Filter data based on set values, formulas or dynamically based on other data or user and team parameters.

  • Aggregations

    We use columnar or vertical indexing of data so when it's time to perform sums, averages, standard deviations, and other types of aggregations, it is easy and instant.

  • Data Augmentation

    Enhance your data by adding templates with currency exchange, health, weather and other data to complement your own data.

  • Type Conversion

    Convert data from almost any type to another type to fix bad data and structure it properly for your visualization.

  • Geocoding

    Automatically convert street addresses to latitude and longitude as the data is processed and start using our map visualizations.

  • Lookup Tables

    Create your own dictionary and lookup tables and use them to prepare, validate or enhance your core data.

central place for all data

A Central Place
For All Your Data

Data Warehouse, Data Lake and Document Storage. Benefit from all types of storage to have all your data in a scalable, secure, and centralized place for fast and efficient analytics. Our built-in data warehouse is hosted on any one of Microsoft's Azure Data Center 20 data centers around the world.

structured unstructured data

Structured and
Unstructured Data

Store structured or unstructured data from spreadsheets, databases, JSON and XML files. Go beyond text and numerical data and store images, videos, audio and binary data to complement your analytics.

data versioning

Data Versioning
and History

Your historical data is retained in our data warehouse irrespective of your systems' availability. If you migrate applications, or your data supplier stops sending you historical data, you will not lose a single byte.

visual data flow

Visual Data Prep
with Data Flow

Prep your data using our visual, drag'n'drop Data Flow module: apply transformations, filter or de-duplicate data, join separate datasets from different sources, and add calculated columns to enrich the baseline data.

Frequently Asked Questions

Upgrade your data management skills with our Experts

Watch our webinar and learn how to simplify complex data models into ready-to-use datasets

You look interested... Let's chat

Book a 30-minute call with one of our product specialists and find out if ClicData is right for you.