Scenario Overview

This second lesson contains a video tutorial on how to create a standard SQL View.

In the tutorial, we will show you how to:

1. Take a customer list of US customers and filter it to show only companies by just 4 states.
2. Union the resulting list with the non-US customers.
3. Generate a conditional ID for each City.
4. Use this conditional ID as a match to join GPS location data for the cities these companies are in.
5. Configure the view as a dimension with a hierarchy.