GrowthPath Analytics Connector for Dear Inventory

Connect Dear Systems to Zoho Analytics, Microsoft Power BI and other data warehouse tools for advanced reporting

 

The most advanced Dear Analytics connector available. This is a high-end product for sophisticated, larger Dear customers. It is live on sites with thousands of orders per day and with multiple multi-currency Dear instances.

 

Key Features

  • Powerful ETL layer for historical data cleanup and consistency across multiple Dears and legacy data

  • Support multiple Dear instances, converts different base currency to a common reporting currency

  • Built on GrowthPath Application Server, a robust and very high-volume Dear integration platform using parallel API connections and a sophisticated cache for high performance

  • Advanced tables offering critical reporting not possible with standard Dear endpoints as used by other data integrations.

  • Amazing Zoho Analytics data feed: rolling updates every two hours, automatic integrity checking, very high volume

  • Tables published by PostgreSQL, enabling PowerBI and most modern analytics tools

  • For security and performance, this does not use co-tenanting: your data and computational resources are isolated. This runs on the GrowthPath Application Server, a client-specific server stack, hosted using industry-leading AWS Kubernetes.

 

 

dashboard example 

This is a Zoho Dashboard using Dear data. It is also possible to combine Xero data, sales history from your old system, 3PL and freight data, Shopify, Google Analtyics, your internal systems and even spreadsheet data

 

 

Please see this slide deck for more specific information.

 

Sales Lifecycle Per Order

 

Another Example: Unmatched Revenue and COGS

Annoyed by invoices without COGS in the reporting period?

With the GrowthPath Analytics Connector, you can run an as-of report for any date in history, showing invoices without matching COGS at the date you want (or vice versa: shipments without invoices).

You can then review the invoices, or generate a reversing accrual.

This is a very difficult report with standard tools. WIth this report, it takes seconds.

It's possible because of the advanced tables prepared by the Connector

Unmatched Revenue

 

Example of the ETL capabilities

Do you have Shopify discounts arriving as additional charges? The GrowthPath connector will spread this into the net price of the order, giving you much better margin analysis.

Do you have one Dear instance where products are Blue and another Dear where they are BL? We can combine this to a common color or common tag, without needing to change historical Dear data.

 

 

 

 

 

Review the table schema from a test server

 View the table schema: GrowthPath Dear Analytics Table Schema

 

data model

Close-up of part of the data model

 

 

The Connector was originally designed for sending data to Zoho Analytics. It now makes the same tables available in a client-dedicated cloud database where it can be used by Power BI or any other analytics tools that can access Postgresql data. Postgresql feed for Power BI is in Beta.

Videos of the Analytics Connector working with Zoho Analytics here: Part 1 and Part 2

 

The Zoho Analytics connector is mature, and capable of high volume sites. GrowthPath has built a robust API connector with excellent retry capability (this is open-sourced). The Connector also has automatic integrity checking. It uses rolling update techniques and can refresh even on an hourly schedule.

The GrowthPath connector can work with multiple Dear instances in different base currencies, converting results to a common reporting currency.

The Dear API load is minimised by the use of our advanced Dear cache, part of the GrowthPath Application Server. The GrowthPath Application Server can also share its Dear API load over multiple Dear API connections, to get much higher rate limits, if required. GrowthPath has clients doing hundreds of orders per day.

Currently the Analytics Connector prepares more than 25 tables. They are not just a copy of Dear's master data and transactional data, but they include tables which combine data for insights which go beyond Dear's reporting. For instance, on overview per order of what's been shipped, invoiced, is in fulfilment, credited and returned.

Data transformation and clean up: The Connector allows for a client-specific transformation layer, which allows historical data to be corrected and adjusted on the fly. For instance, you may describe an important color as Gray in one Dear system, and Grey in another: we can standardise that before the data goes into the Analytics tool.

data model full

Larger extract of the data model

 

The Connector schematically looks like this:

GrowthPath Analytics Connector 2021

 

And it builds on the GrowthPath Application Server

GrowthPath Application Server

 

Zoho Analytics for advanced reporting

Zoho Analytics is a fairly advanced data warehouse and reporting tool, 100% cloud-based. You can make powerful reports, charts and dashboards. In one place, you can combine Xero data, Dear transnational  data, legacy data, Google analytics data, Shopify data, your own data feeds .... in an easy to use, browser-based tool, and it's not very expensive. If you have not used advanced reporting, it's a great place to start.

'Advanced reporting' means 

  • Reporting which focuses on the high level and allows a user to filter and drill down to immediately highlight interesting details
  • A tool where a user can construct new reports to meet one-off requirements (example: preparing to meet a buyer)
  • Use of visualisation
  • A focus on business-drivers
  • A tool that helps a skilled user explore relationships in transactional data to discover important trends
  • A tool which combines data from different sources, including legacy data, POS data, website analytics, CRM insights.

The reporting tools in Dear meet some of these requirements, but they have little visualisation, are not very flexible, are limited to data in Dear and a user-licence is required per user.

You can get a feel for Zoho's capabilities with this 6 minute video

https://analytics.zoho.com/workspace/sample 

Pricing

Using the GrowthPath Analytics Connector requires an annual subscription to the GrowthPath Application Server. This is a dedicated cloud server providing performance and data security. This varies depending on the size of the server required. Typically, it is from $1500 AUD to $3000 AUD per year. This covers the cost of hosting, server updates and provides revenue for GrowthPath to develop and support the connector. This server is shared with all GrowthPath integrations, so adding the connector will not require a new subscription, although it may require a server with more resources.

 

You also need to provide a Zoho Analytics subscription (https://www.zoho.com/analytics/pricing.html). If you want five users, you can budget less than $100 AUD a month, or about 70 USD. Zoho is good value. Zoho has server hosting geographically located in the US, EU, Australia, India and China.

The GrowthPath connector is currently sold as a one-time fee. Your code will be updated periodically. Prices start from $4000 AUD for the connector alone. If you want a customised ETL layer (to clean up historical Dear data), load and integration of data from legacy systems or consulting around choosing KPIs and configuring dashboards and reports, GrowthPath will provide a fixed-price services project. Typically, clients pay AUD $4000 for onboarding.

Currently, we provide the Postgresql connector, for PowerBI and other analytics tools, at the same charge as the Zoho connector.

If you want multiple Dear instances, there is a one-time charge of $1000 AUD extra.

 

Power BI and other analytics tools

Currently in soft launch. A small number of slots are available for clients interested in an early/preview version.

Microsoft's Power BI Desktop is a reporting tool running in Windows. It doesn't have its own store of data, although it stores extracts of data based on reports created.

To use fresh data, it needs a connection to a database acting as a data warehouse. You can connect it to the dedicated analytics database provided by the GrowthPath connector, which runs on Postgresql, a supported database.

The tables have relationships defined so PowerBI can help the report creator link data from the transactional tables to the master data tables.

If you have another analytics or datawarehouse tool, you can extract the data from the same database. Even into Excel.

This avoids having to write a custom integration into Dear's API. The Growthpath connection uses an advanced and robust connection to Dear, which is much more advanced and tested than a one-off integration made by an analytics vendor.

The other big advantage is that the GrowthPath connector offers a solution to multiple Dear databases in different currencies, we have advanced synthesised tables for reporting which goes beyond Dear, we have automatic data integrity checking and we have a data transformation layer.

This is in Beta testing, which means we are selling the service but to a limited number of customers. If you are interested, please contact GrowthPath.