Organizing models by levels

You need to set up a logical folder structure right from the start.

• Naming folders: Prefix by numerals to sort by importance
• Base models vs query models
  • A folder of base models as standard (where you have minimal to no changes to the underlying data)
  • A folder of query models (More complex models, that contains pre-aggregated data which is not exploratory)
• Archive folder (for data models you want to keep, but not delete)
• Children folders by Entity Type (Customers, Sales...)

Here is an example:

project-folder-name (root)
    |- 1.Base models
    |   |- customers
    |   |- sales
    |   |- base_model_n
    |- 2. Query models
    |   |- query_model_1
    |   |- query_model_2
    |- 3. Analytical models (Specific use query models)
    |   |- analytical_model_1
    |   |- analytical_model_2
        |- 4. Archive