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
  • What is data modeling
  • Why data modeling is needed
  1. Core concepts
  2. Data modeling

Understanding data models

PreviousData modelingNextDesigning data models

Last updated 2 years ago

What is data modeling

Modelling data is the process of reshaping your data into a new format that is easy to understand and to query for your non-expert, business users. In Whaly, models will be the foundation of your explorations.

Why data modeling is needed

Raw data may not always perfectly represent the concepts, business logic or definitions your company is using internally. This is often the case if you rely on SaaS data or on your own software data, as the data models are designed to make sense in the context of these applications.

By creating data models, you will hide your data complex logic to ensure that your business users all share the same definitions. This will greatly decrease the risk for wrong calculations and analysis, as well as boost your users ability to embrace data consumption.

🪄
You can think of a data model as a transformation layer that lives between your raw data and your explorations
Drawing