Timeline profiling in data warehouse

by / Thursday, 03 September 2015 / Published in Billet
timeline profiling

Timeline profiling looks for patterns in historical data (such as temporal distribution of the data, patterns of values for different time periods, etc…).

Timeline profiling

Profiling techniques discussed thus far provide key input to data mapping and quality assessment decisions. Specifically, we can identify databases, entities, and attributes containing desired data and understand their meaning. However mere presence of a certain attribute is not enough. Most data maintained in the databases is historic in nature and a certain depth of history is expected.

Timeline profiling is the process of understanding the actual depth of the historic data stack and any patterns that data values have over time.

Entity timeline profiling

The objective of entity timeline profiling is to identify which data is available for which time periods. For each entity we build a distribution of records effective dates. Compare the minimum and maximum dates on the distribution charts and adjust for distribution tails.

Event timeline profiling

The objective of event timeline profiling is to identify availability of data about different kinds of events for different time periods.

Value timeline profiling

The objective of value timeline profiling is to verify that an attribute did not take different meanings over time. This situation is common when a code usage changes historically, or when a past data consolidation brought data from sources with different uses of the same code.


Others articles

State transition model 








state-transition timeline profiling Analyzing Mining Mining Profiling relationship profiling

Subject profiling Profiling

Get Free Email Updates!

Signup now and receive an email once We publish new content.

We will never give away, trade or sell your email address. You can unsubscribe at any time.

Please follow and like us:
David-Marc Petit

David-Marc Petit

Président at DWBI Expert
David-Marc PETIT est le président de DWBI Expert Inc. Il cumule plus de 20 ans d’expérience dans des entreprises de toutes tailles et tous secteurs, sur trois continents, en tant qu’expert en intelligence d’affaires. Il a fait de sa mission la démocratisation de l’intelligence d’affaires (Business Intelligence) pour optimiser les revenus et la performance de ses clients.
David-Marc Petit
David-Marc Petit

Latest posts by David-Marc Petit (see all)

Leave a Reply


Enjoy this website? Please spread the word :)