DW - Data Warehousing & Modeling

A data lake is an important element of the buzzwords related to Big Data and Advanced Analytics. A data lake is a storage repository in which we hold raw data in its native format; this can be structured (e.g. entire source data-tables), semi-structured, and unstructured (e.g., photos, tweets) data. 

R, also called GNU S, is an open-source language and environment designed for statistical computing and graphics. Although it's been existing for 20 years, R remains the most popular statistical programming language used today.

Big Data business opportunities, data security, privacy, and others are too big not to be discussed at the C-level. A CDO or chief data officer is a leader role within the organization responsible for organization-wide governance and utilization of data and information, via data capturing, processing, analysis, data mining, information trading and other.

Process mining can be described as the search to discover strategic information and extracting patterns in bigger databases by making use of process patterns. In this process, users are "digging” into the data and make use of visual process techniques. It helps enterprises and analysts to visualize understand the essential information out of massive quantities of data.

Data masking or data versleuteling is het process van versleutelen en verbergen van orginele informatie met als doel de data te beschermen.

SAP has succeeded in moving towards a modern coherent planning suite with the release of SAP BPC 10.1, version for SAP NetWeaver. The new product combines the advantages of BW Integrated Planning, SAP HANA and SAP BPC.

Bill Inmon is one of the true pioneers of data warehousing and his "Building the Data Warehouse” is an absolute must read for every self-respecting data warehouse professional. First published in 1990, it provides a comprehensive introduction into the core concepts and methods of data warehousing. This new edition covers the latest developments and comes with some new chapters on understanding methods for handling unstructured data in a data warehouse; storing data across multiple storage media; examining the pros and cons of relational vs.

Introduction Drilling across different fact tables is a very important technique when analyzing data from a data warehouse. It gives us the possibility to analyze facts from different fact tables using conformed dimensions.

SAP HANA is an in-memory database platform for processing high volumes of operational and transactional data in real-time.

Wanneer in een database alle herhalende waardes (op attribuut niveau) verwijderd werden door deze waardes op te nemen in andere tabellen.Relationele OLTP systemen zijn meestal in hoge mate genormaliseerd. Data warehouses kennen typisch geen hoge graad van normalisatie.Het normaliseren van data is een proces, origineel gedefinieerd door E.F. Codd en komt neer op het zodanig structureren van gegevens in verschillende tabellen zodat er geen redundantie of dubbele gegevens meer aanwezig zijn.