Tutorial Scenario
The scenario available in this page aims to indicate how to follow the tutorial following a simple case.
This case will implies 2 sources:
A CRM
A HR system
The data will be available through excel files :
Next to this scenario, the data model and the information to implement has been documented
By the end of this case, a data quality control and an enrichment will be proposed.
Tutorial case
As a data management, you are asked to handle the data of large car dealer company. The customer journey in this company is as follow:
The customer is looking for a car (a sport car for example). To do so, he/she may go one of the stores of the company located in several places in Belgium.
The customer is then received by one of the appointed salesperson of the shop.
The salesperson who is supervised by a manager is paid by commission on the cars he/she sells. His commission is 1% while the commission of his/her manager (n+1) is 0.1% of all the cars that his/her team sells.
The salesperson can grant a discount up to 10% of the unit price of the car.
Source system available
The CRM includes:
Information about the cars (or product)
Information about the contracts
Information about the customers
Information about the employees
The HR system includes
Information about the employees and the managerial relationships between employees
Information about the shops
DQ control
Source | crm_extract |
|---|---|
Concept | customer |
Responsible | dFakto IT manager (source: owner) |
Quality level | Level 1 |
Criticality | Warning |
Resolution | Fill in the location of the customer in the CRM plateform |
Test | if sh_customer_info.location is not null then 1 Else 0 |