Use the Excel file in the Content Section for Week 3 to create a manual link chart. The information is a subset of information from an insurance fraud investigation. Create a chart using icons to represent the following: People, Vehicles, Residence, and Social Security Number. Link those items that are linked together. You should use all of the data from the file in the chart as identities, labels, attributes, etc. Please create a custom attribute for the Registration State. Create one card within one of your entities and specify which entity contains the card. For bonus points, there is a way to display an attribute that shows that an entity contains cards - discover that and you'll receive some bonus points.
In message of this submission, discuss what your finding are based on the chart that was created. Additionally, discuss some of the data quality issues that you may have noticed during the creation of the chart. Your postings and replies can also offer some helpful hints to others about the process utilized.
Insurance Fraud Data Set
Two entities were taken as :
And they are linked through vehicle.
The card for a person as an entity is SSN(social security number) and a card for a House is its pincode. The attribute for the link (vehicle) is created by dropdown method. ( the column Registration State was dropdown in attribute pan for link.
Data quality issues: The date format of Vehicle year created an issue when a card was being created through this column (vehicle year). This was not fitting with the date-time format, which has been set as DD-MM-YYYY to capture DOB column. Due to this there was an issue in importing the data.
Also, for bonus points:
When identity in entity is fixed with some columns and then if we directly move to attribute pan and it is found that the attribute pan has no specification, i.e. its empty then this indicates that some of the columns should be used as a card. So, this indicates that the entity associated carries a card.
With a detailed data analysis based on Analysts notebook it has been found that John Smith and Henry Casteel have same social security number (SSN) - 222-85-9632. This might be related to some fraud. A detailed enquiry should be done on these two names and attached single security number to avoid/catch any fraud associated.