Job-transition analysis and report system

A method comprising:

• identifying, by one or more processors, a transition of member of a social network from a source company to a destination company based on a profile of the member, the transition being determined by identifying that employment at the destination company follows employment at the source company;
• adding, by the one or more processors, a row to a members position table for the identified transition, the members position table including a row for each position of the members of the social network, the member positions table including a first field for a company identifier and a second field for a previous company identifier, wherein the previous company identifier indicates a transition from the source company that is associated with the previous company identifier to the destination company that is associated with the company identifier;
• receiving, by the one or more processors, via a user interface, a request for a report related to user transitions;
• querying, by the one or more processors, the member positions table to identify transitions based on a value of the previous company identifier;
• generating, by the one or more processors, the report based on a response to the query;
• and
• causing, by the one or more processors, presentation of the report based on the report data.

A non-transitory machine-readable storage medium including instructions that, when executed by a machine, cause the machine to perform operations comprising:

• determining transitions of users of a social network based on user profiles stored in a social network database, each transition comprising a change of employment from a source company to a destination company;
• creating a member positions table based on the determined transitions and the user profiles, the member positions table including a first field for a company identifier and a second field for a previous company identifier, wherein the previous company identifier indicates a transition from the source company that is associated with the previous company identifier to the destination company that is associated with the company identifier;
• providing a user interface for receiving user input to create a report based on the determined transitions;
• accessing the member positions table to generate report data based on the received user input;
• and
• causing presentation of the report based on the report data.