In this mini-course, 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.

The course consists of 7 parts:

• Part 1: Creating an excel table
• Part 2: Creating the data model
• Part 3: Creating a pivot chart
• Part 4: Adding a well slicer
• Part 5: Adding a date slicer
• Part 6: Creating a pivot table
• Part 7: Linking the slicers

Tutorial

For a better viewing experience, please watch on a large screen rather than on a mobile display. Unfortunately, the video resolution didn’t come out great, but it does not prevent understanding the workflow shown. My apologies.