Process: Analyze data
Flow
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 database and manipulates it, using extract, transform and load (ETL) processes, datacubes in a datamart which is optimized for analytics reporting. Customers can then perform datamining on some of the data in the datamart.
Features
- Low-impact movement of data from WebSphere Commerce to WebSphere Commerce Analyzer data mart
- Extract, transform and load (ETL) processes
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, Enterprise, Express
Tasks
| Task | Description | Role |
|---|---|---|
| Update data mart |
Selected tables from the WebSphere Commerce database 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 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
(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.