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.