From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Logical design for a data warehouse - SQL Server Tutorial
From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
Logical design for a data warehouse
In this section, I'd like to talk about the logical design of a data warehouse. A data warehouse contains two main types of tables. One is a fact table, and the fact table will contain a measurement of a business process. The other is a dimension table. A dimension table will be used for filtering, grouping and sorting our data. Some examples of fact tables. Certainly, money is the most common. We may be looking at a fact table of profit. Maybe one of revenue. Maybe one of expense. But the measurement of most business processes involves money. So our fact tables will often involve money. And we will be summing those, or sometimes looking for averages, or max, or min. Examples of dimension tables would be time. Many of the reports we'll be generating will be for a week, a month, a quarter, a year. We'll need to have some record of what time these facts happened and a way to sort, filter, and search by time. Many businesses also keep track of things by location. Any time our business…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
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.