Reports & Dashboards

The point of entering data into a land system is to be able to get reports out.  Leases, assignments, mineral ownership research done in the courthouse, and more have to be entered so that they can be summarized and reported on.

There are lots of different report that can be run, each report has a different purpose and/or role.  Do you need an Exhibit A for an assignment?  Maybe the land manager needs an expiration report to see what extensions can be paid and what releases will need to be filed.  What about the landman who is interested in a Mineral Ownership Status report so they can see their acreage position on a tract-by-tract basis?  Anyone opening the folder would benefit from a Data Sheet at the beginning of every lease file to highlight the important pieces of each document included.
But how do these reports get made?  Lease Analysts, Division Order Specialists, Excel experts, and internal management at Pettigrew & Pettigrew work together to create a cohesive set of reports that get your questions answered.

A dashboard takes hundreds of columns and thousands of rows from multiple databases or spreadsheets and summarizes them using charts, graphs, and tables to provide a succinct picture.  Detailed reports are necessary for many people, but when it comes to the manager meeting, the boardroom, or talking to investors a single page that is updated dynamically to reflect current information accurately in the easiest to understand manner possible is what is needed.  Dashboards provide this information, quickly showing Land Managers, VPs, and C-level executives acreage, monetary, and land records statistics.

Reports VS Dashboards

Report Example   Dashboard Example
List of each lease that has been reviewed. Progress of Acquisition Review Pie chart showing the percentage completed noted with the total number of lease and exact number left to complete.
Spreadsheet showing lease and tract data such as owner information, expiration dates, and bonus amounts; as well as a column noting whether or not the lease was extended. Extension Progress Simple table showing how many acres were at risk for the quarter, how many acres are HBP, how many acres have options to extend, how many have been extended, and what the average cost per acre is.
Well by well report showing each cost associated with the well. Production Costs Graph for all wells displaying expenses by type, with an option to delve into the particulars of any well of interest.
Tracking sheet with a line for each sent Division Order, column to denote whether or not it was returned signed, and notes to detail any issues with the owner. Division Order Tracking Three  numbers:
1. How many Division Orders were sent
2. How Many Have been returned sign
3. How many have been returned unsigned or have and issue


As you can see in the table above, both reports and dashboards are necessary, but one will be more useful than the other to different people; the Division Order Analyst needs a tracking sheet, the Land Manager needs to see what the progress is – it is all based on the role that the user plays within the company that determines what level of detailed output they need from the database.