Analysis & visualization of online store performances
The eCommerce Connector enables online store owners to quickly and easily connect all relevant data in the company to a single touchpoint with the help of modern software such as Tableau and Exasol.
The eCommerce Connector at one glance
- The eCC enables online store operators to quickly and easily connect all relevant data in their business to one touchpoint.
- The eCC creates a fully modeled and ready-to-use data warehouse that uses the lightning-fast Exasol database as a foundation for Tableau.
- The eCC comes with a collection of ready-to-use dashboards for typical eCommerce KPIs, tasks & workflows.
- The eCC leverages the excellence and power of Tableau and Exasol for comprehensive analysis and visualization of online store performance. A large number of ready-made connectors for APIs are available as standard to merge data from different sources.
Ready-to-use Content
When using eCC with Tableau, the following information is provided by default:
-
C-Level: Gross-net sales, Customer Development, Return on Investment
-
Marketing: Channel Analysis, Campaign Management, Cost per Order
-
Sales: Product sales, processing times, supplier management
Advantages compared to other solutions
- Flatter learning curve and quicker start
- No quality management required for data modeling
- Use of analysis and optimization options through predefined dashboards
- No need to deal with confusing database structures from store systems
- Outstanding performance when using Exasol as a live data connection in Tableau
Architecture
This is how the eCommerce Connector is structured
- Consolidation of data from store systems, ERPs, marketing platforms and tracking systems in an Exasol database
- Preparation and optimization of the data
- Visualization of the data in Tableau Dashboard Starters, Tableau Solution Marketplace or Tableau Embedded Analytics
