Chapter 5: Use Case

Chapter 5: 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



Lesson A: 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:


Lesson B: 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:


Lesson C - 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 Chatper 4: Advanced Operations