Tutorial Scenario - WonderCar
Tutorial case
WonderCar is a large car dealer company. They have multiple shops, and they struggle to have a global view of their sales. They heard about your beVault and its capability to create one comprehensive model containing all the data of the company. Furthermore, they want to start with the sales, but they know that the model will grow in the future.
During a workshop, they described the customer journey in this company as follows:
The customer is looking for a car (a sports car, for example). To do so, he/she may go to one of the company's stores.
The customer is then received by one of the appointed salespeople of the shop.
The salesperson supervised by a manager is paid by commission on the cars he/she sells. His commission is 20% of the profit, while the commission of his/her manager (n+1) is 5% of all the cars his/her team sells.
The salesperson can grant a discount of up to 10% of the unit price of the car.
Source system available
The technical department of WonderCar provided an extract of their systems.
DriveNexus (CRM)
The CRM DriveNexus includes:
Information about the cars (or product)
Information about the contracts
Information about the customers
Information about the employees
StaffForce (HR)
The HR system StaffForce includes
Information about the employees and the managerial relationships between employees
Information about the shops
What’s expected from you?
The data model and the information mart have already been documented by one of your business analysts.
Your mission, should you choose to accept it, is to implement the data model of WonderCar, connect the given extract to that model, and create an information mart that will help the company to have a clearer view of its sales situation.
During your implementation, you might locate some data quality issues in the provided extracts. You can add some data quality controls to the project to help WonderCar to improve its data. The business analyst of the project already spotted one issue.
DQ control
Source | crm_extract |
|---|---|
Concept | car |
Responsible | Source owner |
Quality level | Level 4 |
Criticality | Warning |
Resolution | car should have 2 or 4 driving wheels |
Test | if drive LIKE ‘%2%’ OR drive LIKE '%4% then 1 Else 0 |