Eikosstatistics & data science

Programming & Scientific Computing · Databases & Data Engineering

Data warehouses and dimensional modeling for business intelligence

Public introduction · full guide in Eikos

Introduction

What this guide covers

Introduction Introduction Scientific Data Processing · Business Intelligence

Overview

Topics covered

  • Introduction
  • Data Storage Systems and Dimensional Modeling for OLAP
  • Philosophy of Data Storage and Business Intelligence
  • 1. Evolution from OLTP to OLAP
  • 2. Foundational Visions: Inmon vs. Kimball
  • Dimensional Modeling Based on the Kimball Methodology

Related concepts

Main connections

  • SQL & relational data modeling
  • Window functions in SQL
  • Mean & expected value
  • Aggregation & grouping in SQL
  • Supervised machine learning
  • Relational joins & entity integrity

Compatible notation

Mathematical sample in LaTeX

The expression is rendered accessibly, with its LaTeX source preserved below.

V=∏i=1D|di|
View LaTeX sourceV = \prod_{i=1}^{D} |d_i|