Latest news from Factil

Factil to present at Enterprise Data World – Atlanta – 6 April 2017

No comments

Factil will be presenting a talk at the Enterprise Data World conference in Atlanta Georgia USA on 6 April 2017.

Graeme Port will be be speaking on the topic of “Conceptual Data Transformation: Code Generation from Source to Information Mart“.

Brief Description:

Fact-Based Modeling is an effective approach for managing conceptual data semantics. We show that a Fact-Based Modeling conceptual query language can be used to automatically generate transformation code and build information marts in both Data Vault and cloud-based data warehouse environments.

Abstract:

A modern data architecture manages data in many different forms:

  • Normalized data
  • Non-relational data
  • Semi-structured data available from diverse sources and a range of formats
  • Data Vault data
  • Dimensional data in information marts for reporting/business intelligence

The variety of forms and volume of data means that data transformation is a complex and costly aspect of any modern data environment.

Previously we have shown that Fact-Based Modeling can be used as a unified modeling approach managing conceptual data semantics across all these different forms.  In this talk we will focus on showing that a Fact-Based Modeling conceptual query language can be used to automatically generate transformation code from source, through a data warehouse and to information marts. 

We will apply this approach in two distinct environments:

  • A traditional data warehouse based on Data Vault
  • A cloud-based data warehouse

and show that automated transformation code generation from a conceptual query language reduces cost, contains fewer errors, and supports change/agility.

Graeme PortFactil to present at Enterprise Data World – Atlanta – 6 April 2017

Leave a Reply

Your email address will not be published. Required fields are marked *