We often come across use cases that particularly highlight the power of RDF knowledge graphs. One such case involves the analysis of a simple violations dataset to explore complex trends surrounding team culture and conduct within a large investment bank.
Violations data in the knowledge graph within 3 weeks
Among a number of compliance-related datasets, we incorporated the bank’s employee violations data into an integrated ontological model. The source data consisted of the violator’s employee ID, the type of violation, the incident’s date, and a few additional data points about the incident itself. Within three weeks, we modeled, converted, and loaded the data into the development triplestore. The development knowledge graph was already populated with the firm’s organizational structure and human resources personnel data.
The amalgamation of data, coupled with the strength of SPARQL’s path queries, allowed us to quickly produce reports highlighting cultural trends that would have been extremely difficult to find in the original siloed data. In one example, we investigated senior personnel who committed violations, and who managed employees who committed similar violations. This could point to managers who may be cultivating certain negative behaviors within their teams.
17 of 54, found with one SPARQL query
Using property paths, we fine-tuned the query to include indirect managers within a variable number of levels in the company hierarchy, since cultural tendencies can propagate down the organizational ladder. We also calculated the number of personnel within these multi-level teams to provide a quantitative perspective. This revealed that 17 out of the 54 employees who report to various managers below Ms. Greed breached conflict-of-interest guidelines this year. This included 2 employees who committed repeat violations, and six who committed additional related violations. Ms. Greed herself participated in a private investment without authorization. All this was found, without a starting or seeding data point, using only one SPARQL query. It would have been nearly impossible to uncover the related nature of these violations with the legacy relational data structure.
In another example, we leveraged HR data to analyze the distribution of violations among the various job titles and hire types within different departments. We demonstrated which types of violations were common at different levels of seniority, the percentage of contingent workers (i.e., contractors) that committed the various types of violations, and which departments fostered problematic conduct at senior management levels.
What historical data would add
If we had access to historical organizational data, we could have discovered many additional interesting insights. For instance, we could look at likelihoods of job promotions or demotions following the various types of violations, and vice versa. We could study the effect of onboarding or departure of senior personnel on the conduct of their teams.
One of the next datasets we will be working on is pertaining to the bank’s compliance training attendance. We can then look at correlations between training and violations, to study the effectiveness of training across different topics and departments. By plugging a small dataset into our expanding knowledge base, we can instantly multiply our analytical possibilities.
Contact Us
Overcome integration debt with proven semantic solutions. Contact Semantic Arts, the experts in data-centric transformation, today.
Address: Semantic Arts, Inc.
123 N College Avenue Suite 218
Fort Collins, CO 80524
Email: [email protected]
Phone: (970) 490-2224