Contact

YuGiOh Power BI Dashboard

Price trends of my old card collection

Skills Used

Challenge

The main challenge was creating the API script to extract the data from TCG player. It required going through the documentation and finding the right end points to call. Also, I had to manually scour through my old cards and enter each print tag individually, which was time consuming. There were issues with the API calls and the data that was extracted required pre processing to make it suitable for visualization

Results

I experimented with Figma here to create the dashboard layout and creating custom measures within Power BI using DAX. I implemented a rarity score where i classified each rarity with a value (common being the lowest). I also designed a Tree map to show individual value of each card.

Process

Manual Data Entry

Each card has a unique print tag, therefore I had to create a list of print tags and store them inside an Excel Spreadsheet

API Script

Created a Python script that fetches data from the TCG Player API and imports the data for each card based on the unique print tag

Data Cleaning

Removal of irrelevant columns, standardizing the spreadsheet into tabular format for data visualization, and creating measures inside the excel file

Power BI Dashboard

We conducted user interviews, surveys, and analyzed in-app analytics to understand the pain points and user needs. We also studied competitor apps and industry trends to gather insights

Manual Data Entry

Each card has a unique print tag, therefore I had to create a list of print tags and store them inside an Excel Spreadsheet

API Script

Created a Python script that fetches data from the TCG Player API and imports the data for each card based on the unique print tag

Data Cleaning

Removal of irrelevant columns, standardizing the spreadsheet into tabular format for data visualization, and creating measures inside the excel file

Power BI Dashboard

We conducted user interviews, surveys, and analyzed in-app analytics to understand the pain points and user needs. We also studied competitor apps and industry trends to gather insights

Manual Data Entry

Each card has a unique print tag, therefore I had to create a list of print tags and store them inside an Excel Spreadsheet

API Script

Created a Python script that fetches data from the TCG Player API and imports the data for each card based on the unique print tag

Data Cleaning

Removal of irrelevant columns, standardizing the spreadsheet into tabular format for data visualization, and creating measures inside the excel file

Power BI Dashboard

We conducted user interviews, surveys, and analyzed in-app analytics to understand the pain points and user needs. We also studied competitor apps and industry trends to gather insights

Manual Data Entry

Each card has a unique print tag, therefore I had to create a list of print tags and store them inside an Excel Spreadsheet

API Script

Created a Python script that fetches data from the TCG Player API and imports the data for each card based on the unique print tag

Data Cleaning

Removal of irrelevant columns, standardizing the spreadsheet into tabular format for data visualization, and creating measures inside the excel file

Power BI Dashboard

We conducted user interviews, surveys, and analyzed in-app analytics to understand the pain points and user needs. We also studied competitor apps and industry trends to gather insights

Twitter

Medium

Twitter

Medium

Twitter

Medium