Building reliable product from the start

The whole solution consists of several integral parts.

Cloud ELT service

To gather data from various sources: CRM, Google Analytics, Ads services, Sheets.

Key thing here is you can easily adapt any service provider or even plug your own self-managed connectors if you wish.

CORE DWH module

Which serves as a medium between tables created by a cloud connector and Data Marts

It also covers every source table with tests comprehensively (right now it is roughly 600% code coverage)

packages:
 - git: "https://github.com/kzzzr/mybi-dbt-core.git"
   revision: 0.2.0

Client DWH deployment

Where the main business logic resides.

Most commonly it is about calculating ROI, building sales funnels, clustering customers, conducting clickstream and web analytics.

Every client project incorporates specific data sources by importing the CORE DWH module.

Data access layer

Could be anything from well established visualizations and dashboards to modern self-service BI as well as reverse ETL tools to serve data back to operational systems (CRM and communication tools).