{'fraction_non_alphanumeric': 0.01674418604651163, 'fraction_numerical': 0.0018604651162790699, 'mean_word_length': 4.94475138121547, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Data and Process Analyses of Data Warehouse Requirements

As opposed to classical information systems, Data Warehouses (DW) have existing sources in addition to actor requirements as inputs. DW design methods have to take them both into account. Besides, ETL processes may consume up to 80% of the development time in a DW project and their costs are estimated to be at least one third of the effort. Therefore, ETL and others processes we will define should be handled at the first step of DW engineering. All these processes allow actors to validate relevant and required data. However, DW developpment methods which take into account existing sources do not address these processes at the early stage of process engineering. Thus, they are not represented and validated during the analysis step. Hence, we provide a model and an original approach to analyse requirements and data sources by specifying data and processes at the analysis stage. We specify DW properties through a graph which simplifies the confrontation between user requirements and existing data sources.