The Task
Our coach Robbin is a big Path of Exile fan, so he asked us to create a Path of Exile-themed dashboard using data from poe.ninja. The data provided daily updates on the values of the 235 currencies within Path of Exile as well as the value of more than 10,000 items that can be traded in the game. Path of Exile has 28 seasons (officially called Leagues) spanning from 2016 to 2024.
The main currency in the game is Chaos Orbs, which serve as the general base currency for trading. I tried to confirm this using an Alteryx flow.
The Plan
My plan for the dashboard was to:
- Rank the most valuable currencies from the last x leagues.
- Allow users to track how the value of a selected currency changed over the course of a league.
- Enable users to select a league and browse item values during that league.
- Provide a converted price for items in the selected currency.
Data Preparation
Confirming Chaos Orbs as the Primary Currency
To confirm that Chaos Orbs are the primary currency in Path of Exile, I used the Summarize tool to count the number of exchange rates listed for each currency each day. I summarized again to find the maximum listed exchange rate for each day, before performing an inner join on this value.
Obtaining Image URLs for Currencies
Dashboard
The Final Dashboard
The final dashboard ranks the most valuable currencies, visualizes currency value changes across leagues, and allows users to browse item prices for a selected league. Converted prices are also displayed in the chosen currency.
You can view the dashboard here:
Path of Exile Items and Currency Dashboard