Definition of Enterprise Data Dictionary: Create and document the definition of all metrics and breakdowns (KPI - Key Performance
Indicators & Dimensions) that are used and need to be used within the organization. In addition, data culture definitions are set in motion within the institution via the data steward.
Data Warehouse Modeling
Creation of a data warehouse model: Designing the data warehouse model according to the definitions defined in the Corporate Data Dictionary (Fromel & Exceptions). Considering the organization requirements and provisions of the applicable method 3NF, Star Scheme and Snow Flake modeling as required.
Data Transfer & Integration
In the created data warehouse model, data from systems (relational databases, xls-txt files, unstructured data (social media) and external data, etc.) are collected within the institution and transformed and loaded according to the data warehouse model. Identifying dirty data for data quality, generating solutions with data normalization and/or identifying improvement points for processes within the organization.