Listed on:
April 13, 2023

Excel + Open Query

Alan Mourgues
(view profile)
Video tutorial
Description

Seven part video tutorial where I show you how to create a Data Model from an existing excel data set, and then how to pull data from the data model to build pivot charts and tables.

The result is a graph and a table that can be easily updated interactively by simply clicking on the slicer buttons.

The example uses a data set containing production profiles (dummy data) for 200 gas wells (Type Curves).

However, the workflow can be applied to any other data set. Consider this a time series (20 years long, 1 value per year) for 200 entities.

Product
tags:
Reservoir Engineering
Reservoir Engineering
Production Engineering
Production Engineering
Type Curves
Type Curves
Production profiles
Production profiles
Excel
Excel
Open Query
Open Query
BUY

$

340