Once ClicData is connected to your data sources, you’re ready to transform the data into useful information. ClicData is a powerful data warehouse, capable of enriching, cleansing, standardizing it and combine multiple data tables into one.
Do you need a calculated column that your source data doesn’t have? Create it in ClicData and each time your data is refreshed, the calculation is also refreshed. Or perhaps you need the data grouped a certain way? Create the group in ClicData and it will always be refreshed and ready to be used in your dashboards.
There is more to ClicData than just dashboards!
ClicData features help you establish uniformity and consistency across your data warehouse with a selection of transformations, normalization, merge options, data history management and more.
Clean your data
Prepping your data for use in dashboards is not always easy. Ensuring that all your data is uniform and ready to be displayed in a table or a chart is not always straightforward and requires a lot of manual data manipulation. ClicData makes it easy with our data standardization and cleansing features.
Our Normalize feature ensures that all your text data is in the right case without extra spaces or that your dates are not in 1899 or in 2096.
Our Standardize feature ensures that different values all converge into one, for example “U.S.A.”, “US”, and “USA” can all be automatically changed to “United States”.
Merge and Combine data
Do you need to match your current sales numbers with your sales targets? How about connect the budget data to the expense data? ClicData’s Data Merge feature allows you to combine data from multiple sources into a single table.
Your data merges stay in synch with the individual data sets so that you do not have to match data ever again. Just refresh each individual data source and the data merge will refresh as well.
Learn more about data merges here.
The Data Transform feature let you use familiar functions and formulas to create new calculated columns or to convert from one column type into another. By letting ClicData augment your data you will not have to modify your source data any longer! Here are some of the things you can do:
- Add calculated columns
- Filter data
- Group rows of data
- Change column types
- Pivot data rows
- and more…
Learn more about data transformations here.