From the course: Implementing a Data Warehouse with SQL Server 2022
Join today to access over 24,800 courses taught by industry experts.
Create an indexed view - SQL Server Tutorial
From the course: Implementing a Data Warehouse with SQL Server 2022
Create an indexed view
- [Instructor] At this point, our KinetEco data warehouse has a single fact table for orders and two dimensions that we can use to give context to these orders, either through the dates that the orders were placed or through the customers that placed the order. Now we can use these dimensions to slice and dice the facts in order to get insight into the performance of the business. For instance, we might want to look at the sum total of order revenue per month by combining the fact table with the date dimension or we could look at the order performance per state by combining the fact table with the customer dimension. Or we could combine everything, all three tables and look at the quarterly sales performance for each city by pulling information from all three tables. So there's already a lot of flexibility built into this very small data warehouse that could be used in a number of different analyses and reports. When we do…
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.