I have been working on a paper where I use the Compustat database to model the hierarchical structure of firms. I will not discuss the details here, but will share a new method that I have developed for visualizing the model.
In the plot below, individual firms appear as pyramids. The size of the pyramid is proportional to the firm's employment. Vertical levels correspond to hierarchical levels of the firm. Color corresponds to individual pay (individuals are visible as tiny vertical bars, if you look closely).
Of course, individual pay is not available for Compustat firms. I have simulated it using Compustat's data for total labor expenses and CEO pay. The model assumes that pay increases exponentially by hierarchical level. Given this assumption, each modelled firm shown below has mean pay and a CEO-to-average-employee pay ratio that matches Compustat data.
The image is very high resolution that appears to be too big for the CasP server. I've provided a link belowhttps://drive.google.com/file/d/0B_AS9iet5yFMcVdwZEtYVWRVQVU/view?usp=sharing