Programming & Scientific Computing · Statistical & BI Software

Tableau: Data connection, preparation, and integration

Public introduction · full guide in Eikos

Introduction

What this guide covers

Data sources, Extract/Live, Tableau Prep, joins, unions, relationships, level of detail calculations and ETL flow architecture — with expert depth.

Overview

Topics covered

  • Introduction
  • Connecting, Preparing and Integrating Data in Tableau
  • Internal Architecture and VizQL Engine
  • Tableau Data Architecture Layers
  • The Life Cycle of a VizQL Query
  • Data Connection Types

Related concepts

Main connections

  • SQL & relational data modeling
  • Data granularity & row semantics
  • Relational joins & entity integrity
  • Mean & expected value
  • Linear algebra & matrices
  • Calculus & differentiation

Compatible notation

Mathematical sample in LaTeX

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

Tscan=Nrows×WcolBWmemory×Ncores×Ccompression−1
View LaTeX sourceT_{scan} = \frac{N_{rows} \times W_{col}}{BW_{memory} \times N_{cores}} \times C_{compression}^{-1}