Managing large data on SQL service (Card game)

[Ben Razidlo]

The card game, Keyforge, uses randomly generated decks of cards and competes them in organized play. Data from the results are available:

https://www.fantasyflightgames.com/en/products/keyforge/

The community of Keyforge players are interested in creating a system to assess decks based on their composition: specific cards or groups of synergistic cards.

Using the following PS script (http://www.techtrek.io/keyforge-data-scraping-part-2-the-script/), I have downloaded a great quantity of the win/loss data that includes deck composition. This data was downloaded for about a week and saved into a SQL database service.

Tableau can access the database service, but the amount of data is pretty unwieldy. I am looking for recommendations on tools I might use to thin the data out or utilize it with greater agility on Tableau.

Thanks – Ben

[Author]

Posts