Data Modeler

Overview

Produces a denormalized aggregated model based on functional requirements for a set of tables using a knowledge graph to provide context on investment management knowledge. This accelerator takes as input the functional requirements generated from the Data Product Strategy accelerator, and the data profiles from the Data Profiler. The modeler will output a visual star schema of the relevant subset of tables, a denomralized aggregated model, and SQL DDL to begin building the new table.

How it Works

Based on the given profiles, we select a subset of tables that are relevant to what's requested in the functional requirements. Using a knowledge graph, the subset of tables is visualized in a star schema to understand the relationships between tables. We then join tables and aggregate information based on the requirement to produce a denormalized aggregated table that is purely informational and ready for reporting.