Process: Analyze data

Flow

Legend

Analyze data

Objective

Customers analyze Commerce data in order to identify trends, problems and opportunities in historical data and then use that information to adjust the WebSphere Commerce settings to maximize customer experience and profit.

Description

WebSphere Commerce Analyzer reads the data from the WebSphere Commerce and Tivoli Web Site Analyzer databases and manipulates it, using extract, transform and load (ETL) processes, into a new schema called datamart which is optimized for analytics reporting. Customers can then perform datamining on some of the data in the datamart.

Features

Customization

When extending the WebSphere Commerce database, customers should follow instructions in the WebSphere Commerce Analyzer online help on how to add database modifications to the extract, transform and load (ETL) processes. Customers can also create datamining algorithms (demographic clustering) to mine existing data or additional data added through customization, in different ways.

Edition

Professional, Business, and Express (except data mining) Edition

Subprocesses

Tasks

Task Description Role
Update data mart

Selected tables from the WebSphere Commerce and Tivoli Web Site Analyzer databases are replicated, or copied, to the datamart for processing. DB2's Replication technology copies only the changes made since the last replication, not the entire table.

Data from the replicated WebSphere Commerce and Tivoli Web Site Analyzer tables is processed and manipulated into the WebSphere Commerce Analyzer datamart tables, which are optimized for reporting. This manipulation also completes some summarizing and effectiveness calculations on the data.

Business intelligence analyst

Business artifacts

Feedback