Please enable JavaScript.
Coggle requires JavaScript to display documents.
⚔️ Data 🐉 Adventure - Coggle Diagram
⚔️ Data 🐉 Adventure
Move & Process data
Pipelines
-
-
-
Processing Types
ETL
-
less storage
-
ELT
-
MORE STORAGE
-
-
Processing Systems
OLAP
-
Data Cube
-
smaller volume
-
OLTP
-
LARGE VOLUME
-
-
Structure
Structured
:heavy_plus_sign:
-
ACID
-
Properties
Table Types
Dimension
-
Kimball Slowly Changing Dimensions (SCD)
-
-
-
-
-
Schema
Schema Types
Snowflake
-
Star
-
-
-
-
-
-
-
-
-
-
Semi-structured
-
-
Unstructured
Data Visualization
-
Visualization Types
Basic :smile:
-
-
Scatter Plot
-
-
Logarithmic Scale
Concentration of data points
Zoom In
Better vizualization with log scale
Zoom In
-
-
Bar Plots
-
Horizontal (easier to read)
Zoom In
-
-
-
-
The Black Sheep
-
-
-
-
-
-
Data warehousing process
Data Source Layer
:arrow_right:
Data Staging Layer
:arrow_right:
Data Storage Layer
-
Data Warehouse
-
Data Marts
:arrow_left:
-
Kimball bottom-up
- 1 more item...
-
-
Data Sources
-