Biuwer Docs
Biuwer.comBlogLog InTry for free
English
English
  • Welcome
  • Getting Started
    • What is Biuwer?
    • Glossary
    • How to use Biuwer?
      • Sign Up process
      • Accessing Biuwer
      • Home page and navigation
      • My user Profile
      • Managing content
      • Exploring data
      • Filtering data
      • Collaborating with data
      • The Film Rentals space
    • How Biuwer works
    • Next steps
  • Managing Data
    • Introduction
    • Data Connections
    • Datasets
    • Data Models
  • Content Management
    • Introduction
    • Personal space
    • Shared spaces
    • Favourite content
    • Pages
    • Cards
      • Data Card Editor
      • Data queries
      • KPI card
      • Vertical Table Card
      • Cross Table Card
      • Chart Card
      • Map Card
      • Custom Card
      • Calculated fields
    • Filters
    • Multilanguage
  • Creating a Dashboard
    • What questions I want to answer
    • What data sources are there
    • Setting up data connections
    • Setting up datasets
    • Setting up data models
    • Create cards
    • Create the page
    • Setting up access security
  • Security Management
    • Introduction
    • Platform permissions
    • Roles
    • Object permissions
    • Permission inheritance
    • Property of objects
    • User access logs
  • Administration
    • Organization
      • 🎨Themes
      • 🎨Color palettes
    • Users
    • Groups
    • Roles
    • Authentication tokens
  • INTEGRATION GUIDE
    • Introduction
    • Concepts to take into account
      • Contents to integrate
      • Shared resources
      • Users
      • Groups of users
      • Authentication Tokens
      • Data Policies
    • How do I integrate Biuwer into my application?
      • Items to prepare
      • Content access security
      • Data access security
      • Embedding a resource in my application
    • Integration Types
      • Manual integration
      • Automated integration
Powered by GitBook
On this page

Was this helpful?

  1. Managing Data

Data Models

One of the keys to Biuwer's flexible operation is its data modeling layer, which is done using Data Models.

PreviousDatasetsNextIntroduction

Last updated 4 years ago

Was this helpful?

A Data Model is a non-physical but logical element, which allows to define a context of analysis and is composed of one or several Datasets and their respective Relationships.

Once a data model has been defined, it is available to carry out the data analysis it allows to the whole Organization, following the concept of "define once and use many".

It is recommended to define data models appropriate to types of data analysis that will be needed. It is not recommended to create a single data model with all available datasets, as it increases the complexity in the relationships between them and the results obtained may not be the expected ones, due to the intervention of relationships that do not apply in certain data queries.

The option "Data Models" is available on the left side menu of the Data Center, which gives access to the list of data models that your organization has defined in Biuwer.

From this list you can see the different Data Models that your Organization can use in any data card to make data queries and perform the following operations:

  • Filter data models according to their name and data connection

  • Directly access the model detail by clicking on its name.

  • From the context menu of each model, see the model detail, edit it or delete it.

  • Add a new model.

As in the case of Datasets, we also distinguish between managed and not managed Models. By clicking on the "Add" button in the list of models, a data model creation dialog appears. By default the option "Not Managed" is selected in which it is necessary to select a data connection. A not managed model will allow to include in it any dataset associated with a specified connection, because the query will be executed in the database engine associated with the connection.

If, on the other hand, you want to create a "Managed" model, it is not necessary to include a connection when you select this option, because Biuwer manages it automatically for your organization as a CDW (Cloud Data Warehouse).

Managed models can only include managed datasets. This is interesting because relationships can be modeled between data of different types uploaded to Biuwer, obtained through the CSV or Excel file importer, connections to external APIs or through the Biuwer data preparation module.

We have access to the list of Datasets that are part of the model from its detail page.

Using the "Add" button we can include new datasets. From the list itself, by clicking on the red cross you can remove a dataset from the model.

Clicking on the "Relations" tab shows the list of relations included in the model.

A relationship links two datasets using one or more fields, using an operator (equality, inequality, greater or lesser) and a relationship type:

  • Inner: includes all records when there is at least one match in both datasets.

  • Left Outer: includes all records of the left dataset, and the matching records of the right dataset.

  • Right Outer: includes all records of the right dataset, and the matching records of the left dataset.

  • Full Outer: includes all records of the left and right datasets.

List of Data Models in the Data Center
Dialog to add a new Not Managed Model
Dialog to add a new Managed Model
Detail of Datasets in a Data Model
Dialog to add a dataset to a model
Detail of Relations between Datasets in a Model
Dialog to add a Relationship to a Model