About this document

Dimensional Model Design Lab for SQL by Bí is a document available to read on EtoBox.

This document provides an overview and instructions for Lab 2, which involves implementing the physical dimensional model for a data warehouse. The lab has three main parts: 1. An SQL refresher that demonstrates how to create a star schema sample called "part1-college-data-mart.sql". 2. Implementing and loading data into a dimensional model for a Northwind trader sales data warehouse, which involves creating the star schema, staging the data, and loading it. 3. Testing the ROLAP schema with Excel pivot

Author

Bí

Language

EN