From the course: Introduction to Data Warehouses
Join today to access over 24,000 courses taught by industry experts.
Facts
- [Narrator] Facts are individual pieces of data or information that we want to store and analyze in our data warehouse. These facts can be numerical or quantitative values. A fact could be the number of products sold, the total sales amount, or the number of customer complaints. To make these facts meaningful and useful, we organize them into facts tables. A fact table is a central table in a data warehouse that contains the facts of the businesses, usually in the form of numerical values. The fact table is the center of the data warehouse schema, and is often surrounded by dimensions tables, which categorize the facts. Here is an example of how you would use one. A retail store may have a fact table that contains information about sales. This table would have columns for the date of the sale, the product sold, the number of units sold, and the total sales amount. In the manufacturing industry, a company can have facts…
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.