Preparing your Data Set for Analysis
Data preparation involves cleansing, standardizing, and enriching your data set before you analyze the data in a visualization canvas.
You can create data visualizations using either of the following options:
- Creating Datasets From Spreadsheets
Select this option if you want to import data from a spread sheet to create a new data set for the data visualization.
- Creating Datasets From Subject Areas
Select this option if you want to use the subject areas available in CIC Analytics from P6, Unifier, Oracle Primavera Cloud.
In This Section
About Data Enrichment and Transformation in CIC Analytics
Enriching and Transforming Your Data
Accepting Enrichment Recommendations
Transforming Data Using Column Menu Options
Transforming Data Using Replace
Converting Text Columns to Date or Time Columns
Adjusting the Display Format of a Date or Number Column
Creating a Bin Column When You Prepare Data
Configuring Column Properties in a Dataset
Restoring a Hidden or Deleted Column
Editing the Data Preparation Script
Creating Calculated Data Elements in a Workbook
Last Published Friday, December 8, 2023