Listed on:
June 19, 2023

Excel Data Model + Power Query: Visualization of Type Curves with Pivot Charts and Pivot Tables

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.

What you get
  • A link to a web page with the 7 embedded videos
  • A sample Excel workbook with the dataset used in the tutorial
Product
tags:
Reservoir Engineering
Reservoir Engineering
Production Engineering
Production Engineering
Type Curves
Type Curves
Production profiles
Production profiles
Excel
Excel
Power Query
Power Query
Watch