I have a similar project. What I do is track everything in Google Sheets, than I have scripts to download those as CSV, which get imported into a SQL database. Then I have a Tableau worksheet looking at that. It's pretty neat, but not everything is working correctly and I haven't totally automated yet. Eventually I'd like to have a frontend to avoid google sheets entirely.Sorry to not follow the rules OP, but I'm curious what you made your database with?
I started via SQL Server Management Studio, but got entirely bored of insert SQL statements.
I had intended to do my whole collection and then build a report from Power BI to just I dunno visualise it all.
I did my PS4 collection and got entirely fed up of the SQL, and just built a report based from that.
Lmao, I want to know what that is but I'm afraid to google it..
MUHAHAHA! NOW WE FEASTSTOOOOOOOP!!!
The List is complete! I No longer take other Keywords until I finish with those first!!!
So take a seat and let see what results we will have.
Sorry to not follow the rules OP, but I'm curious what you made your database with?
I started via SQL Server Management Studio, but got entirely bored of insert SQL statements.
I had intended to do my whole collection and then build a report from Power BI to just I dunno visualise it all.
I did my PS4 collection and got entirely fed up of the SQL, and just built a report based from that.
I have a similar project. What I do is track everything in Google Sheets, than I have scripts to download those as CSV, which get imported into a SQL database. Then I have a Tableau worksheet looking at that. It's pretty neat, but not everything is working correctly and I haven't totally automated yet. Eventually I'd like to have a frontend to avoid google sheets entirely.
Here's a terribly old version with a limited subsect of my games, if you'd like to take a look. Good lord, I haven't touched this since 2016 (I have been updating my sheets regularly though), I really need to get back in and finish this.
002 - Hotdog - Results = 1!!!
Good game!!! I forgot about it truth to be told.
003 - Island - Results = 71!!!
[mod edit: removed nsfw content]
please ignore some duplicates....and my drawings. None is perfect.
You have Misaki on Tomb Island 2 but not Misaki on Tomb Island 1?