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
  • Iterating on your models
  • To go further
  1. Core concepts
  2. Data modeling

Maintaining data models

PreviousEvent schemaNextData models best practices

Last updated 2 years ago

Iterating on your models

As building models can be an overwhelming endeavour, it is important to take things one step at a time. Iterating on your models will help you mitigate some of this complexity by slicing a big work package into smaller and simpler tasks

Start small

Start by creating the minimum models you will need. Select the bare minimum number of columns you need and start from there.

Add what's needed

When you need to add a new information to a model, you should always ask yourself the following question : Should I extend my existing model or create a new one. If you sense that adding a new column will change the purpose of your current models, you should probably create a new one. If not, you should update your model.

Carefully remove what's not needed anymore

Removing columns may be a tricky operation, as your model columns might be used in other part of the BI (explorations, relationships, drills and even other models). If you need to replace a column, we advise you start by creating a new column, update your model and it's dependencies and then remove the column. This should avoid some downtimes and mitigate risks to break downstream items.

Repeat

Iteration is a never ending process, so don't be afraid to iterate every time it's needed

To go further

Building models in Whaly is a great way to quickly deliverer value and iterate on feedback. When some of your Whaly models are widely adopted and become a central part of your BI analysis, you should think about moving them to a more stable and testable environment, such as .

Some core functions of dbt are building, testing and documenting SQL models, as well as providing a complete version control system.

Whaly offers a direct integration with dbt cloud: you will be able to automatically import your dbt models in your Whaly environment in order to use them in your explorations and your charts.

🪄
dbt