Working with the Sample-customers Dataset

This example shows how to use various methods to analyze, validate, transform, and cleanse your data.

The Sample-customers dataset contains a set of fictional customers data, among which some data is invalid. By default, a project named project 1 is created from this dataset.

Suppose you are an administrator at a widget manufacturer named TWIDGCO, Inc. The company has experienced unprecedented growth over the last decade, but a recent report revealed inefficiencies and lost opportunities due to inconsistent customer data across all brands. The management decided to roll all brands and their respective customers data into the main Customer Master of TWIDGCO.

Now you are facing the challenge of consolidating a massive amount of customers data from multiple data sources and in a variety of formats. With TIBCO Clarity, you can upload data from various data sources and streamline the data into a unified representation.

This example shows how you can meet the challenge with TIBCO Clarity:

• Creating a Dataset and a Project

  Create a dataset by importing data from different data sources, and create a project out of the dataset to sample data.

• Analyzing Data

  Profile data, facet data, check data dependency, and chart data.

• Validating Data

  Validate data by data types.

• Facet data, check data dependency, and chart data.

• Transforming Data

  Transform data into a uniform data format.

• Cleansing Address

  Cleanse the address data.

• Deduplicating Data

  Check duplicates.