From the course: Introduction to Data Warehouses
Join today to access over 25,300 courses taught by industry experts.
Dimensional modeling
From the course: Introduction to Data Warehouses
Dimensional modeling
- [Instructor] Have you ever wondered how companies like Amazon and Walmart are able to analyze and make sense of their vast amounts of data? The answer is dimensional modeling. Dimensional modeling is a data modeling technique used to organize and structure a data in a data warehouse. Dimensional modeling helps organize data in a way that solves a business problem by creating a model that is optimized for querying and analysis. A dimensional model is made up of two types of data: facts and dimensions. Facts are usually things that can be measured and aggregated, such as profit, sales, et cetera. Dimensions provide additional context to these measurements. For example, a dimension could be the year, month, or product category. Dimension tables and fact tables are connected through a relationship to form a dimensional model. Now let's look at how dimensional modeling can be used in a real world example. Assume that a…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.