Process: Produce BI reports

Flow

Legend

Produce BI reports

Objective

Use the produce business intelligence reports process to view analytical reports in order to note and act on historical trends using the WebSphere Commerce datamart.

Description

The business user can choose to use either WebSphere Commerce Accelerator or a third party reporting tool to produce business intelligence reports. Some third party reporting tool vendors have created Reporting Integration Kits that contain all of the analytic reports derived from the WebSphere Commerce Analyzer datamart. Business users can user these reports to adjust WebSphere Commerce settings to maximize customer experience and profit.

Features

Pre-built analytics reports in the WebSphere Commerce Accelerator cover the following categories:

-Campaigns

-Initiatives

-e-Marketing Spot

-Campaign/Initiative/e-Marketing Spot Combination

-Product

-Order Summary

-Geographic Sales Analysis

-Demographic Sales Analysis

-Time Period Sales Analysis

-Sales by Account

-Sales by Contract

-Marketing Content

-Marketplace Activity

-Shopping Cart

-Storefront Activity

-Clickstream Activity

Reporting Integration Kits for third party reporting vendor tools (available online) cover the WebSphere Commerce Accelerator reports plus the following categories:

-Catalog

-Product Navigation

-Product Advisor

-Sales by Order Status

-Customer Order

-Web Site Traffic

-Orders by B2B Direct Business Model

-Request for Quote

-Account Sales by Recency, Frequency and Monetary Value

Customization

New business intelligence reports can be created in the WebSphere Commerce Accelerator using the Reporting Framework and the WebSphere Commerce Analyzer Datamart Guide.

New business intelligence reports can be created using third party reporting tools and the WebSphere Commerce Analyzer Datamart Guide

Edition

Express, Professional, Business Edition (some reports only work in Business Edition)

Tasks

Task Description Role
Generate reports

Business intelligence reports are created on demand and run against the WebSphere Commerce Analyzer datamart. Depending on the report tool you are using, the results will display in varying ways, but the report contents should remain the same.

Marketing Manager
Choose reporting tool (external)

WebSphere Commerce provides a framework for viewing Busines Intelligence reports using Commerce Accelerator. For more advanced reporting you may query the datamart directly using 3rd party report tools.

Marketing Manager

Business artifacts

Feedback