Skip to the beginning of the images gallery

FanShop

Lichtendahl, Kenneth C. Jr. ; Andrasko, Joe ; Boatright, Benjamin

Reference: DARDEN-QA-0887-E
Number of pages: 5
Publication Date: Aug 11, 2021
Fecha de edición: Mar 8, 2022
Source: Darden University of Virginia (USA)
Type of Document: Exercise

Grouped product items
Format	Language	Reference	Use	Qty	Price
pdf	English	DARDEN-QA-0887-E			As low as €8.20

You already have a subscription

To order please contact the person in charge of academic purchases in your university.

You'll be able to order once your profile has been validated.

Description

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.

Keywords

database