GRAND RIVER ANALYTICS LLC
Professional results through data.
We are a small GIS and Data Analysis shop that specializes in using data to tell a story. We can do work for any discipline and ensure the best possible results.
Ordered Most Recent to Oldest
These are the projects I learned the most from. They also highlight some key skillsets.
EXCEL MACROS AND POWERBI
Collected the geologic data for over 630 wells from SES, used a macro to pull them all into an excel workbook and then wrote macros to build summary, completion, and zone tables. Imported this into PowerBI with production data to build a production and geology dashboard. The process allowed me to continually add wells and data to the dashboard.
SES, EXCEL, SPOTFIRE
March - June 2018
Calculated percentage in zone by formation, in and out of zone, and lithology using SES data. Created an Excel macro to import tables from SES then converted this into a single database. Used Tibco Spotfire to correlate these attributes with 12-month oil production. The result was inconclusive overall but when divided by formations there were some key relationships between percentage in zone and oil production. Also incorporated geographic areas and found stronger relationships based on geography.
Gathered well, geologic, log, and production data from both proprietary and public sources, performed quality control, combined into a large GIS database. Performed detailed geologic and economic analysis of the black warrior basin, shallow Devonian in the Appalachian Basin, Deep shale in the Illinois basin, and deep targets in Kentucky. Created several grids including porosity, gamma values, thickness maps, and hydrocarbon production. Performed correlation to find the relationships between these and oil/gas production then produced weighted sums based on these results for each basin.