Data Warehouse Design

Types of Data Warehouse

  • It is a centralized warehouse.
  • It provides decision support service across the enterprise.
  • It offers a unified approach for organizing and representing data.
  • It provides the ability to classify data according to the subject and give access according to those divisions.
  • Data store required when neither Data warehouse nor OLTP systems support organizations reporting needs.
  • The data warehouse is refreshed in real-time.
  • A data mart is a subset of the data warehouse.
  • It specially designed for a particular line of business, such as sales, finance, sales or finance.
  • Data can collect directly from sources.

Star Schema vs. Snowflake Schema


Relationship and Cardinality

Conceptual, Logical and Physical Data Model

In summary,

  • Design and develop semantic data models.
  • Design metadata and harmonized code references.
  • Identify business keys and relationships among the tables.
  • Ensure to involve all stakeholders including business users in Data warehouse implementation process.




Data Lover, Inspired Data Engineer

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

Recommended from Medium

A case study: Assessing confounding and modification using logistic regression in R and Stata

Identify your vulnerable populations: COVID-19 “starter” risk models for all countries in…

Can you tell me how many customers will I get for my restaurant tomorrow?(Recruit

Complete guide on logistic regression with gene expression data: the math

15 Data Science Questions You’re Too Embarrassed To Ask

Improving the Results and Efficiency of My Options Trading GA

Sampling With Replacement In Presto

Attribution models I CXL course review

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
LiYen Yoong

LiYen Yoong

Data Lover, Inspired Data Engineer

More from Medium

Experimentation as a business function: what to focus on?

The Case of News Aggregators

The false imperative of customer service automation

📅 CDP Week by Twilio Segment[June 21–23, 2022] | Partner Event