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. 

Pop_Dense_Acre_Person_edited.jpg

PAST PROJECTS

Ordered Most Recent to Oldest

These are the projects I learned the most from. They also highlight some key skillsets.

powerbi.JPG
SES_edited.jpg
COVID19vsPOPDENSE.jpg

EXCEL MACROS AND POWERBI

March 2019

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.

GIS ANALYSIS

Jan-May 2014

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.

What We Do

WHO: DAN AMRINE (OWNER)

9 years as a GeoScience Technician and 3 years as a Geologist.

I started my career in 2007 as a "Tech". I have since learned that I have a love and passion for ensuring the data is right. Accurate data is essential for a successful business.

fieldcampweek3camera%20068_edited.jpg

CONTACT ME

1-(720)-325-0278

Thanks for submitting!

20200104_154935.jpg