Product details

By continuing to use our site you consent to the use of cookies as described in our privacy policy unless you have disabled them.
You can change your cookie settings at any time but parts of our site will not function correctly without them.

Abstract

This exercise explores customer transaction data generated from a business owner's website and illustrates the added benefit of basic data analytics practices used to uncover business insights. Students discover the business's purchase trends when they answer the provided questions by writing SQL queries. The questions guide students to determine which product offerings the business should promote and which customer segments to target. Additionally, the case discusses the common relational database design that is often associated with transactional data and its metadata.

About

Abstract

This exercise explores customer transaction data generated from a business owner's website and illustrates the added benefit of basic data analytics practices used to uncover business insights. Students discover the business's purchase trends when they answer the provided questions by writing SQL queries. The questions guide students to determine which product offerings the business should promote and which customer segments to target. Additionally, the case discusses the common relational database design that is often associated with transactional data and its metadata.

Related