Exercise - Model Data

In this exercise, you will work in small groups. Review the information presented about Fabrikam Robotics and complete the tasks.

Learning Objectives

After completing the exercise, you will:

• Evaluate customer requirements
• Make decisions for the data model

Exercise 1

You are building a solution for Fabrikam to track visitors to a showroom and manufacturing site. Some of the visitors are potential purchasers, while others are simply interested in seeing the robots in action.

• Visitors must have a reserved spot to gain access.
• Visitors invited by sales staff must be tracked to a sales process.
• Visitors touring for fun are not tracked to a sales process.
• Visitors can bring guests.
• Each visitor must have a photo taken upon arrival and associated with their visit.
• Each visitor must sign a waiver of liability during every visit, and the system must store their signature along with the date and time of acceptance.
• Each primary visitor is assigned an engagement tracking device that monitors their location within the manufacturing area and showroom. This tracking is used for safety purposes and to improve tour experiences. The device stores data in its own cloud service and provides both bulk export and API access.
• Tracking data must be viewable within the sales process user interface used by sales staff.
• Marketing requires reporting capabilities to view visits by day, month, and quarter, along with statistics showing sales closures that occurred after a visit.

Tasks

Create a data model that satisfies the requirements above. Use any tool or medium available to you, such as a whiteboard, Microsoft Visio, diagramming software, or pen and paper.

• How did you handle the storage of visitor photos?
• How did you handle the storage of visitor waiver acceptance and signatures?
• How did you accommodate viewing tracking data within the sales process?
• Did you use any entities from the Common Data Model (CDM) schema?
• How did you address Marketing’s reporting and statistical requirements?