How to achieve DATA MODELING - Session 3

DATA MODEL'S INPUTS:

One of the most important consideration is the complexity level of the design of the Data Model. It is normal to break down the tasks depending on basic guidelines into multiple process flows or multiple dataset sources.

• Process Flow Concept: The basic notion is to use two or more process flows so that there is better readability and optimum resource utilization. It is crucial to group the tasks such that there is minimum repetition of data sources across each of the process flows.
• Dataset Concept: In the scenario, when only one process flow would suffice the requirement, the controlling factor is where the datasets reside, generally referred as libraries. The joins between the datasets need to be accurately devised to achieve desired outcome. Thorough understanding of key relationships and heavy usage of data examination techniques will govern the stability and robustness of data model.

DATA MODEL'S OUTPUTS:

In iterative design, it is important to consider if outcome of basic data model will source other advanced data model.

• Dataset Concept: The general thumb rule is to strategize the categories of output into multiple datasets, either in one or more libraries, so that they can be reused. It is convenient to follow standard naming conventions since creating new datasets results into potential training documentation educating analysts and other power users and demonstrates proactive attitude towards planning efforts.
• Report Concept: It may be quintessential to publish the output of data model and in that case, there are myriad of solutions to customize the look and feel of the content in terms of reports. Relying on standard templates provided helps narrow down the professional outlook of the reports. The basic structure can be broken down to include visual representations such as line graphs, bar charts in conjunction with tabular data in matrix format for powerful delivery of information.

Here is an example of automated academic report that used to be manually generated by feeding data into MS Excel worksheets:

Figure 1. Complete PDF Report

Figure 2. Image and Highlights Content

Figure 3. Tabular Content

Figure 4. Graphical Content

DOWNLOADABLE REPORT