Modelling
Modelling refers to the process of creating a simplified representation or conceptual structure of a system or business process. It involves capturing the essential characteristics, behaviors, relationships, and properties of the process being modeled to gain a deeper understanding, facilitate analysis, and support decision-making.
Data Modelling: Data modelling is used to represent the structure, relationships, and constraints of data within a system or database. It involves creating entity-relationship diagrams or data flow diagrams to define entities, attributes, and their relationships, ensuring data integrity and supporting efficient data management.
Process Modelling: Process modelling focuses on representing the flow of activities, tasks, or operations within a system or business process. It helps to understand the sequence of events, dependencies, and interactions between different components.
In simpler terms, it is the process of configuring and analyzing data objects and their relationships to other objects. It is used to analyze the data requirements necessary for business processes. Data models are created for the data to be stored in a database.
Models form the foundation for storing, processing, updating, and visualizing data. They can be compared to tables in Excel, with columns identified as dimensions or metrics.
Identifying Models: Modelling in JustPerform takes a modular approach to creating multiple models to address a business process. The models are created considering business outcomes, data structure, data security, and business rules. Different models can be connected to support integrated analysis. JustPerform follows the ROLAP modelling approach to leverage the best of relational and multi-dimensional capabilities.
Identifying Dimensions and Metrics: While the models include key components referred to as dimensions or metrics, additional attributes are required for these dimensions to achieve business outcomes. These attributes can provide additional information about members (master data) maintained in dimensions or can be created for data processing, data input, security, or reporting requirements.
JustPerform takes a unique approach to modelling by adapting ROLAP instead of MOLAP, thereby allowing users to naturally convert their spreadsheet-based models into JustPerform models. This provides flexibility in supporting models that go beyond conventional multi-dimension analysis.