From the course: Data Visualization with Python in Excel

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Creating dynamic measures with Python in Excel

Creating dynamic measures with Python in Excel

From the course: Data Visualization with Python in Excel

Start my 1-month free trial Buy for my team

Creating dynamic measures with Python in Excel

“

- [Instructor] One of the most exciting capabilities in BI tools like Power BI or Tableau is creating dynamic measures, which allow users to interactively choose which metrics to display in a visualization. This keeps dashboards compact and highly functional. Unfortunately, replicating this feature in Excel has not been so easy, but Python in Excel greatly simplifies it. Let's try it out with the exercise file "dynamic measures". Now, this example is a bit more complicated so I've already basically built out this model. We'll walk through what's here. We're using the MPG dataset, which I've already loaded into Python in the MPG worksheet. Next, let's address some of the auxiliary tasks we need to handle. I've created a helper table for the aggregation methods in the helper worksheet, which will crosswalk the user's aggregation selection from a dropdown menu into the exact aggregation type syntax required by pandas. So the idea here is that the user can get a sum, average, max, and so…

Contents