In this 7-part video tutorial, 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.
→ For a better viewing experience, please watch on a large screen and not on a mobile display.
→ In playback mode, you can click on the symbol at the bottom right to maximize it for a full-screen view:
→ Excel sample file: download