Updated and connected :)
Mar. 10th, 2026 12:19 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
artemisdartI had been lax about updating my little PostGreSQL database with all my kudos and wordcounts posted... for the past 3 or 4 months... but starting on Friday and finishing just now, I managed to catch myself up!
And what's more, I drew inspiration from a Discord conversation about connecting the database to PowerBI, and tackled the problem again. This time, I was able to get it done! So now my database is feeding PowerBI directly, mwahahahahaha! This is very exciting, because the Excel pivot tables and pivot charts I built were lackluster, to put it mildly. I've never liked Excel for this purpose.
(PowerBI has its own issues, too -- don't get me wrong -- but at least it was MADE TO BE a visual dashboard program. Excel was not.)
ANYWAY, check out this sick visual!
I have this particular viz filtered to only the Star Wars Sequel Trilogy ships. You can see the line -- that's my kudos over time, layered over the columns representing the number of words posted over that same timeframe. Note that the scales for the two facts are wildly out of sync, because I post wordcounts in the thousands and get kudos in the dozens, haha.
I also have the wordcount columns color-coded by ship. You can see the vast blue sea that is all the Gingerpilot words I have posted, versus the others.
The Kudos Total is filtered down to only kudos that were associated with these particular works, so it provides a great comparison. I already knew that my Gingerpilot wordcount had fallen off -- way off -- but this viz really drives that home. Look how small the blue bar is for Qtr 1 2026! I need to do something!!!
I have many other ideas for different vizzes to add to the dashboard... here are a few to kick-start my memory later.
* Top kudos-leavers
* Cluster kudos-leavers into profiles (I bet there's a strong Gingerpilot profile, for instance, but I bet the data will reveal others)
* Named kudos vs. guest kudos by Rating (Explicit works have more guest kudos -- and also, the Anidala fic "Painted On Her Skin" has an insanely high guest kudos ratio for some reason)
* Ships in descending order by rank, with anything under 5 or 6 bucketed into an "Other Ships" bucket
* Wordcount and kudos posted by Rating over time (instead of by ship)
* Trends and forecasts! :D
I'm sure there are a bunch of other things I'm not thinking of. But for now, after having broken through this wall that has stymied me for over a year, I am well pleased and going to bed!
And what's more, I drew inspiration from a Discord conversation about connecting the database to PowerBI, and tackled the problem again. This time, I was able to get it done! So now my database is feeding PowerBI directly, mwahahahahaha! This is very exciting, because the Excel pivot tables and pivot charts I built were lackluster, to put it mildly. I've never liked Excel for this purpose.
(PowerBI has its own issues, too -- don't get me wrong -- but at least it was MADE TO BE a visual dashboard program. Excel was not.)
ANYWAY, check out this sick visual!
I have this particular viz filtered to only the Star Wars Sequel Trilogy ships. You can see the line -- that's my kudos over time, layered over the columns representing the number of words posted over that same timeframe. Note that the scales for the two facts are wildly out of sync, because I post wordcounts in the thousands and get kudos in the dozens, haha.
I also have the wordcount columns color-coded by ship. You can see the vast blue sea that is all the Gingerpilot words I have posted, versus the others.
The Kudos Total is filtered down to only kudos that were associated with these particular works, so it provides a great comparison. I already knew that my Gingerpilot wordcount had fallen off -- way off -- but this viz really drives that home. Look how small the blue bar is for Qtr 1 2026! I need to do something!!!
I have many other ideas for different vizzes to add to the dashboard... here are a few to kick-start my memory later.
* Top kudos-leavers
* Cluster kudos-leavers into profiles (I bet there's a strong Gingerpilot profile, for instance, but I bet the data will reveal others)
* Named kudos vs. guest kudos by Rating (Explicit works have more guest kudos -- and also, the Anidala fic "Painted On Her Skin" has an insanely high guest kudos ratio for some reason)
* Ships in descending order by rank, with anything under 5 or 6 bucketed into an "Other Ships" bucket
* Wordcount and kudos posted by Rating over time (instead of by ship)
* Trends and forecasts! :D
I'm sure there are a bunch of other things I'm not thinking of. But for now, after having broken through this wall that has stymied me for over a year, I am well pleased and going to bed!
