eCommerce Connector: Tableau for online stores

Connect your entire business: The eCommerce Connector enables online store owners to quickly and easily connect all relevant data across the enterprise with a single touchpoint, using advanced software like Tableau and Exasol.

See our eCC explanation video here

The more successful the business model, the more complex the operation of online stores can become. This is because visitors to online stores act in many different ways. In order to better understand the behavior of potential customers and significantly improve the performance of the online store, it is important to use the generated data in a meaningful and targeted manner and to make it analyzable. This possibility is offered by eCommerce Connector (eCC) developed by M2. 

eCommerce Connector uses the excellence and power of Tableau and Exasol for comprehensive analysis and visualization of your online store performance. A large number of ready-made connectors for APIs are provided as standard to merge data from different sources.

Basics - What is the eCommerce Connector, who should use it and why?

• the eCC enables online store operators to quickly and easily connect all relevant data in their company to one touchpoint
• eCC creates a fully modeled, out-of-the-box data warehouse that uses the lightning-fast Exasol database as the foundation for Tableau
• eCC comes with a collection of ready-to-use dashboards for typical eCommerce KPIs, tasks & workflows

Ready-to-use content - What insights are provided "out of the box" when using eCC with Tableau?

• 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

Benefits for the Customer - in comparison to other solutions

• Flatter learning curve and quicker start
• No quality management is required for Data Modeling
• Use of analysis and optimization options through predefined dashboards
• No need to deal with cluttered database structures from store systems
• Excellent performance when using Exasol as a live data connection in Tableau

Architecture - Which systems can be connected to Tableau via eCC?

• Data from store systems, ERPs, marketing platforms and tracking systems are consolidated in an Exasol database
• Preparation and optimization of data in the fastest analytical database in the world
• Visualization of data in Tableau Dashboard Startes, Solution Marketplace or Embedded Analytics

Tableau and Exasol work optimally together, as both systems are designed to process and analyze large amounts of data. Exasol is a high-performance database specifically designed for rapid query and analysis of large data sets. Together, Exasol and Tableau provide a powerful combination for organizations that need to process large amounts of data and access critical information quickly.

With Exasol as a database and Tableau as a visualization and analysis tool, companies can quickly and easily gain insights into their data and make informed decisions. We leveraged the excellent connectivity of these two tools to create the eCommerce Connector.