Conversational BI Assistant powered by Generative AI (LLM)

Natural‑language questions like “What are this week’s revenues?” are translated into structured queries.

Dynamic SQL Query Generation (Data Analyst Agent)

Turns user prompts into SQL that runs against the BI Data Hub, supporting flexible filters and time-based queries.

Visual Report Builder (KPI & Report Specialist)

Produces charts (bar, line, pie) and dashboards within the Copilot canvas; downloadable as PDF, PNG, or CSV.

Interactive Table Views

Renders structured tables (e.g., “Top 15 SKUs”) in the Copilot for copy or export.

Deep UI Integration into Copilot for Merchants

All results—charts, tables, forecasts—are displayed directly in the chat area.

Business Intelligence Data Hub

Built-in structured data warehouse offering these supported data objects from Intershop ICM/IOM: 

• Base order data (buyer name, creation date, currency, customer ID, document number, gross/net totals, tax, order ID, promotions applied) 

• Shipping bucket data (shipping method, bucket-level items) 

• Product line item (SKU, quantity, unit gross/net price, product ID) 

• Payment data (payment amount, payment ID) 

• Order states (order statuses from Order Management service) 

• Base product data (SKU, name, description, image link, default category, creation/update timestamp) 

• Category path data (category name, path ID, URI) 

• Assigned categories (category assignments per product)