Getting Started with Data Model

Introduction

In today’s data-driven world, the ability to effectively manage and interpret vast amounts of information is crucial. Data Models play a pivotal role in this process by providing a structured and user-friendly framework for querying and refining data.

Users can create and manipulate data models that encapsulate complex business logic, making it easier to derive insights and make data-driven decisions. By simplifying database queries, Data Models enable users to focus on defining golden signals and their dimensions, applying transformations, and enriching data with domain-specific knowledge.

This empowers users to build comprehensive data pipelines, enhance data with contextual information, and ultimately streamline the analysis process, ensuring that critical insights are readily accessible and actionable. It powers the functionality of Data Visualization, Alerts, Reports, and Insights, ensuring a comprehensive and intuitive data-handling experience.

Embarking on 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: A data store is a repository for persistently storing and managing collections of data. Accessing and handling the data stores is simple and can be found at the top-left corner of the Data Models listing page. 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, Data Stores officially supports PostgreSQL, MySQL, Elasticsearch, and Hyperscale DB. 
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: You are required to provide a unique and intuitive name and a brief description of the data model.
   • Prepare Data 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 model your 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 join and concatenate transformations, when working with multiple queries.
   • Set Properties:  You can select the metrics and buckets you want to expose through this data model. In the ‘Set Properties’ step, you can choose, and define properties for the metrics and buckets to be accessible to Data Model users.

Support for Dynamic Filters in Dashboards VuNet’s dashboard lets you use dynamic filters for data viewing. The addition of the data model to the dashboard occurs indirectly via Insights. Configure your queries with custom filters to accurately filter the data on the dashboard.

Further Reading

• Learn to configure Insights

FAQs