LESSON 6: Use Case

LESSON 6: Use Case

Now that you have completed the main portion of Online Training, we would like you to go on and try out a few Use Case's on your own. You can follow the lab guides and consult the Recipe Steps when needed.
         
Chapters:

Duration: 25 minutes



Chapter 6A - Use Case Application 

In this Lesson, you will practice applying what you learned in the previous lessons in the context of a use case. In this lesson, you will work with Customers data. Before you begin working on this lesson, read the following background information about the customers dataset and use case


Downloadable Resources:


Chapter 6B - Preparing and Pivoting Data

In this lab, you will:
  • Create a new dataset for the Transactions data
  • Remove test transactions
  • Standardize data values (product names)
  • Compute actual product price (based on discount)
  • Learn how to use the Pivot transformation

Downloadable Resources:


Chapter 6C - Application of Techniques in Customer Use Case

In this lab, you will:
  • Combine transaction data from multiple year files
  • Join the data with the Customers dataset
  • Perform a lookup to fill in the missing state values

Downloadable Resources:




<<< PREVIOUS - Lesson 5: More Advanced Transforms      


keywords: union, aggregate, join, lookup, enrich, blend, integrate, calculate, concatenate, reference data
version 4.0
last updated 03.13.2017