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.
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.
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 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
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 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.
