Implement data warehousing techniques

Apply models and tools such as online analytical processing (OLAP) and Online transaction processing (OLTP), to integrate structured or unstructured data from sources, in order to create a central depository of historical and current data.

skill/competence

sector-specific

Implement data warehousing techniques is an essential skill of the following occupations:

Database integrator: Database integrators perform integration among different databases. They maintain integration and ensure interoperability.

Implement data warehousing techniques is optional for these occupations. This means knowing this skill may be an asset for career advancement if you are in one of these occupations.

Data entry clerk: Data entry clerks update, maintain and retrieve information held on computer systems. They prepare source data for computer entry by compiling and sorting information, process customer and account source documents by reviewing data for deficiencies and verify entered customer and account data.
ICT information and knowledge manager: ICT information and knowledge managers contribute to the definition of organisational information strategy and apply information and knowledge creation, editing, storage, and distribution policies. They manage the maintenance and evolution of structured and unstructured information. They create digital structures to enable exploitation and optimisation of information and knowledge, manage data analysis and enable business intelligence.
Data entry supervisor: Data entry supervisors manage the day-to-day operations of data entry staff. They organise the workflow and tasks. 
Software architect: Software architects create the technical design and the functional model of a software system, based on functional specifications. They also design the architecture of the system or different modules and components related to the business’ or customer requirements, technical platform, computer language or development environment.

References

1. Implement data warehousing techniques – ESCO