Working with Data Model

Introduction

Data Modelling Workspaces offer a powerful solution for querying and refining data at an abstract, user-friendly level. They serve as the foundation for each golden signal, encompassing dimensions, transformations, and associated properties. 

Users can define and configure Data Model Workspaces to enrich them with domain-specific insights. Also,

• This tool simplifies the data pipeline process by eliminating the need for learning complex database queries. 
• It provides an abstraction that defines golden signals, their roles, dependencies, and relationships among signals and components. 
• With the ability to create new fields using formulas, specify data enrichment, and incorporate external events, Data Modelling Workspaces streamline the RCA (Root Cause Analysis) process.

Working with Data Modelling Workspace

1. Accessing Data Modelling Workspace: Navigating your Data Modelling Workspace is a breeze. Begin by visiting the vuSmartMaps homepage and selecting “Data Modelling Workspace” under the Explore section. Once you’re there, you’ll find a comprehensive overview of your data models. You can easily manage your models by performing actions such as creating, viewing, editing, and deleting them. For enhanced control, customize permissions for different roles—whether it’s granting viewing rights or permitting modifications. 
2. Data Store: In the realm of data management, accessing and managing Data Stores has never been easier. vuSmartMaps supports a variety of backend databases, making it highly adaptable to your needs. You can effortlessly query these Data Stores using a standard Query Editor or tailor your queries to the specific capabilities of each Data Store. Currently, PostgreSQL, MySQL, Elasticsearch, Azure Data Explorer (ADX), and Clickhouse are officially supported by Data Stores. 
3. New Data Model Creation: Creating a new Data Model is a breeze with our intuitive platform. The process consists of four straightforward steps: Start by providing the basic information, set up your data query, apply any necessary transformations, and finally, define the properties of your Data Model. 
   • Basic Information: These essential details serve as the foundation for your data model, ensuring it’s well-defined and ready for further configuration.
   • Add Query: This involves crafting queries to fetch data from your databases. The process allows you to choose between building queries using a user-friendly Query Builder or directly specifying a Raw query, giving you flexibility in how you retrieve data.
   • Do Transform: These transformations enable data manipulation to suit your specific needs. While not mandatory for data models with a single query, they become vital, especially joint transformations, when working with multiple queries.
   • Set Properties: By specifying metrics, you’re defining which data aspects the model will work with.

Support for Dynamic Filters in Dashboards allows you to create custom filters within your queries, enhancing your data analysis.

Further Reading

1. Accessing Data Modelling Workspace
2. New Data Model Creation