Introduction
The term Master Data within the AIV application encompasses functionalities for creating various components such as Datasource, Datasets, Parameters, Group Dataset, Data Pipeline, and Datasource Mapping.
Visibility Based on Privileges
The availability of specific sections, such as Datasource and others, under the Master Data tab is contingent on the user’s privileges. If users encounter difficulties accessing sections under the Master Data tab, contact the administrator regarding access issues.
Master Data Tab Contents
Datasource
The Master Data section of the AIV application allows users to create Datasource with various types of metadata, including traditional relational databases (MySQL, Oracle, MSSQL, PostgreSQL) and modern solutions like Big Query, OLAP, and NoSQL databases. Users can also work with flat files and customize Datasource according to their needs.
Datasource Mapping
Datasource mapping extends the availability of created Datasource to multiple users, facilitating collaborative data access. The AIV application supports a wide range of database types and custom options, empowering users to work with data in a way that suits their specific requirements.If users have questions or need assistance
Go to the Datasource Mapping section
Datasets
The Dataset feature in the AIV application offers a comprehensive solution for creating datasets based on required Datasource. Users can incorporate parameters and hierarchies, providing a customizable and structured approach to data analysis. Additionally, the ability to preview datasets before saving them allows for fine-tuning data configurations.
Data Pipeline
The Data Pipeline feature supports the creation of joins and unions between multiple datasets and tables, enabling advanced data manipulation and analysis. Users can also incorporate client-side and server-side scripts into their datasets for further customization and automation.
Group Dataset
The Group Dataset feature allows users to organize and categorize data based on specific parameters or criteria, streamlining data retrieval by grouping it according to predefined conditions. This optimization enhances efficiency and reduces unnecessary data processing, resulting in quicker and more targeted results.
This feature is particularly useful for analyzing data based on distinct categories or subsets, leading to more efficient data analysis and decision-making within the AIV platform.
Go to the Group Dataset section
Parameters
Parameters provide users with the flexibility to create various types of parameters, enhancing user control and customization within the platform. Users can create different types of parameters, such as text, numeric, or date parameters, tailored to specific requirements. Parameters are designed to receive input from end-users, enabling a dynamic and interactive experience.
Data Pipeline
The Data Pipeline feature in the AIV application allows users to easily define relationships between different datasets and tables through an intuitive, user-friendly interface. With Data Pipeline, there is no need for SQL knowledge to create joins between tables or datasets. This feature simplifies data integration by enabling users to visually connect tables and datasets using drag-and-drop functionality, making it accessible to business users who may not be familiar with SQL. It also allows users to join pre-existing datasets within the AIV application.