Bi-kipedia

element61 proactively invests in extending and sharing knowledge and understanding of Business Analytics related topics and concepts.

As part of this effort, we have decided to start a humble "Wikipedia” of Business Analytics, baptized "BI-kipedia”.

Clicking on any of the below listed concepts or terms will lead you to a more elaborated definition and explanation. On the right, you can also filter to see terminology by Topic or Technology or by it starting letter in the alphabet.

Bi-kipedia

Lineage key or audit key

A Lineage key or audit key is an extra column in a dimension or fact table that has a foreign key relationship to another table in which data about Extract Transfer Load (ETL) processes is maintained.

Tuesday, 29 January 2019

Bi-kipedia

Hybrid Online Analytical Processing

HOLAP storage is a combination of MOLAP and ROLAP. Detail data is kept in the relational data source. But aggregate data and indexes are loaded into MOLAP storage during processing, as shown in figure below.

Tuesday, 29 January 2019

Bi-kipedia

OLTP - OnLine Transactional Processing

An OLTP database is typically normalized in 3th form with efficiency of storage and optimization of write operations or low-volume read operations in mind.

Thursday, 27 December 2018

Bi-kipedia

Data Estate

Data Estate reframes the notion that data is no longer a byproduct or just an accidental creation of business processes or the storage of information.

Thursday, 13 December 2018

Bi-kipedia

GDPR

GDPR stands for 'General Data Protection Regulation' which is European set of regulations aimed to better protect the privacy and thus data of its citizens. GDPR wiill be active as of 2018 and will require every company to be compliant with a set of data protection regulations such as applying proper data masking when business analysts use data or the ability of a customer to 'be forgotten'.Full details and informations can be found here.

Friday, 11 November 2016

Bi-kipedia

Data Lake

A data lake is a storage repository in which we hold raw data in its native format

Wednesday, 12 October 2016

Bi-kipedia

Lambda Architecture

A Lambda architecture is a data-processing architecture combining both batch- and (real-time) stream-processing methods.

Wednesday, 12 October 2016

Bi-kipedia

R language

R is an open-source language and environment designed for statistical computing and graphics.

Wednesday, 12 October 2016

Bi-kipedia

Spark

Apache Spark is an open source cluster computing framework released in 2014. It serves as an alternative to (part of) Apache Hadoop as it was originally developed in response to limitations in the Hadoop MapReduce cluster computing paradigm (read more on Hadoop). As such, Apache Spark complements Apache Hadoop as Spark replaces the use of Hadoop MapReduce but still requires (if used on scale) the other Hadoop elements: i.e., a file system (e.g. Hadoop Distributed File System) and a cluster manager (e.g. Hadoop YARN).

Wednesday, 12 October 2016

Bi-kipedia

CAO - Chief Analytics Officer

A CAO or Chief Analytics Officer is responsible for, and involved with, advanced business analytics.

Wednesday, 12 October 2016

Bi-kipedia

Lineage key or audit key

Hybrid Online Analytical Processing

OLTP - OnLine Transactional Processing

Data Estate

GDPR

Data Lake

Lambda Architecture

R language

Spark

CAO - Chief Analytics Officer

Refine your search