Amazing world of Data : Building Blocks of Data Warehouse

  • Subject oriented
  • Nonvolatile
  • Integrated
  • Time variant
  • Source data
  • Data staging
  • Data storage
  • Information delivery
  • Management and control
  • Metadata
This diagram in taken from an awesome books on data warehousing, “Data Warehousing Fundamentals for IT Professionals by Paulraj Ponniah”
  • Production data comes from various operational systems of the enterprise which include financial systems, manufacturing systems, and systems along with supply chain management.
  • Internal data refers to an organization’s private user data like customer profit, departmental databases.
  • Archived data refers to periodically taken old operational system data which is stored in an archived file.
  • But most of the time executives depend on data from external sources, which contain statistics relating to their industry produced by external agencies and national statistical offices.

Freelancer content writer with a profound understanding of data engineering, big data, and cloud. drop a mail: abhishekgore0605@outlook.com for further details

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Linear.Finance AMA with CEO & Co-Founder Kevin Tai transcript

Writing Functions in Python— A Beginner’s Guide

Lab 5 — Output: Piezo Speakers

Changing the slpash-screen in an ios application without using a second storyboard file and…

Praeco Walkthrough

Measuring Software Teams

Using django-rest-knox

Next step to avoid backing properties for StateFlow

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Abhishek Satish Gore

Abhishek Satish Gore

Freelancer content writer with a profound understanding of data engineering, big data, and cloud. drop a mail: abhishekgore0605@outlook.com for further details

More from Medium

Why I use AirFlow for ETL | Vishwanath Akuthota

Redshift — Distribution styles

https://unsplash.com/@chuttersnap

Data Model for Video Streaming Platform

How asking a simple question bridged the gap between data science and data engineering