LogoLogo
HomeDocumentation
  • ๐ŸณUsing Whaly Guides
  • Core concepts
    • ๐Ÿ“šGetting started
      • Data stack architecture
      • Consumers vs Builders
      • Data layers in Whaly
      • License Mapping
    • ๐Ÿช„Data modeling
      • Understanding data models
      • Designing data models
      • Common modeling patterns
        • Event schema
      • Maintaining data models
      • Data models best practices
    • ๐Ÿ–Œ๏ธExplorations
      • Understanding Explorations
      • Designing Explorations
      • Maintaining Explorations
      • Mistakes to avoid
  • Training
    • ๐Ÿ‘๏ธFor viewers
    • ๐Ÿ‘ฉโ€๐Ÿ’ปFor editors
    • ๐Ÿง™For builders
      • Setting up the training material
      • Creating a chart
      • Using and editing explorations
      • Filtering a dashboard
      • Creating explorations and models
  • Inspiration
    • ๐Ÿ—’๏ธUse cases
      • Billing / Invoicing
      • Customer success
      • Fundraising
      • Marketing
      • Partnerships
      • Product
      • Sales
      • Strategy
    • ๐Ÿ’ฌCommunication
    • ๐Ÿ’กTips
  • Recipes
    • ๐ŸคCustomer care
      • How to build a 360ยฐ customer dashboard
    • ๐ŸฆFinance
      • Modeling your recurring revenue
        • SQL for simplified MRR calculation
        • SQL for advanced MRR calculation
    • ๐Ÿ“ฃMarketing
      • Track your entire Marketing Funnel
      • Calculate your Customer Acquisition Cost
      • Create a partner dashboard
    • ๐Ÿ’ผSales
      • Analyze the impact of your Sales velocity on your closing rate
      • Create a sales performance dashboard
      • Build a target oriented sales dashboard
  • Misc
    • ๐ŸงSQL Fanout
    • ๐Ÿ“ฆBackup your data using BigQuery
    • โ˜๏ธEmbedding reports in Salesforce
    • ๐Ÿ‘จโ€๐Ÿ’ปUseful SQL operations
      • Flattening categories
Powered by GitBook
On this page
  • Why 4 data layers?
  • Layer 1 - Sources / Raw data
  • Layer 2 - Models
  • Layer 3 - Explorations / Semantic Layer
  • Layer 4 - Reports
  1. Core concepts
  2. Getting started

Data layers in Whaly

PreviousConsumers vs BuildersNextLicense Mapping

Last updated 2 years ago

Whaly offers you 4 main layers to expose your data to stakeholders. Each layer is the foundation for the next one.

Here is a diagram with the 4 data layers offered in Whaly โคต๏ธ

Why 4 data layers?

Offering 4 layers is provided the proper tools to your organization to properly govern your data assets and make sure that your Business Intelligence can be maintained and remains trusted by all data consumers in the long run.

Each of the data layer is offered with a set of tools that will enable your organization to remain in control of your Business Intelligence deployment and remain effective even in the long run.

Layer 1 - Sources / Raw data

At the very base of Whaly Data layers is the "Source" layer. This is where data is being sourced from to be then exposed in the Business Intelligence. Think of this layer as being the "Import layer" of Whaly. Everything analyzed in Whaly will be ultimately linked to a Data Source.

In this layer, it'll be important to:

  • Import all the data sources that are needed to build business insights from

This layer is managed by Data Builders in Whaly through the Workbench interface.

Depending on the state of your Data Stack and of your current deployment, the Source layer will enable you to:

a. Import Data already existing in your Data Warehouse (that came from an ETL vendor or from a custom pipeline)

b. Import Data managed by a modelling layer such as dbt

c. Import Data directly from one of your Business Tools with an integrated connector of Whaly

Layer 2 - Models

Above the Sources layer, exist a Models layer. This layer will help you clean and consolidate your various data sources to produce Models that will be analyzed and reported on by your Data Consumer.

In this layer, it'll be important to:

  • Build the "Data Model" of your organization, by merging different sources and building relationships between different business entities (ex. Customers and Orders)

  • Document the work that has be done to implement your business rules and definition

  • Produce data in a shape that will be easily analyzed by your Data Consumer

This layer is managed by Data Builders in Whaly through the Workbench interface.

Depending on the state of your Data Stack and of your current deployment, the Models layer will enable you to:

a. Import models managed by a modelling layer such as dbt

b. Build SQL based models directly from Whaly interface

c. Build Flow models with a no-code interface to bootstrap your models at the beginning of your Data Projects

Layer 3 - Explorations / Semantic Layer

Above the Models layer, exists the Exploration layer. This is also called "Semantic Layer". This layer will be the place where Data Builders and Data Consumers will collaborate. It will be the interface designed by Data Builders for Data Consumers to enable them to make self service queries.

In this layer, it'll be important to:

  • Design the proper set of Dimensions / Metrics that will empower your whole team

  • Document the Self Service interface to facilitate the adoption of Data Consumers and make them autonomous

This layer is configured by Data Builders in Whaly through the Workbench interface and used by Data Consumers through a dedicated query interface

Layer 4 - Reports

The Reports layer are where your Data Consumer will build their own dashboards and questions to suits their business needs. In this layer, they will be able to manage the look & feel of their data visualization, manage the sharing methods (pushs to external systems, sharing links, invitations).

A folder structure and access control settings will help your Data Consumers organize their Dashboards in a content hierarchy to maximize the adoption of the dashboards.

In this layer, it'll be important to:

  • Design and shape dashboards and charts so that they expose the right information and help everyone take better decision

  • Structure the overall content structure of your organization to make sure that people can find the insights they are looking for

This layer is configured by Data Consumers in Whaly in the Workspace interface

๐Ÿ“š
Drawing