- Feb 9, 2004
- 281
- 9
- 65
Hi everyone,
I’m a Mir2 player from euro days and continue to play every now and then, when time allows. I’ve recently been playing a new Mir2 server and was talking to one of the guys in my guild about how we can record and share boss drops with the rest of the guild. We’ve previously done this using excel, not exactly complicated, and easy to do but I’ve been working with PowerBi in my professional life and thought maybe it would be a fun little project to create a dashboard specifically for this, maybe a bit overkill but I thought it would make for some good practice and will help me develop my skills further.
As you can imagine, the result was a simple dashboard which allows the user to filter items by level, class and item type. It also allows the user to view boss drops. The latter is all added manually in a spreadsheet which PBi references and then automatically updates the data model.
The reason for this post is to see if any server owners would be interested in getting our heads together to see if there are other ways we can utilize PowerBi with Mir. It could be for the players, or solely for the server team, or both.
For example, in addition to the above, some other ideas could be:
Of course this will require that data is shared with me, or is at least accessible, so I don’t know how much of a problem this would be. I understand there will no doubt be concerns around trust but I wouldn't be doing this for self-gain. I’m not seeking financial payment, I am only interested in:
Cheers,
I’m a Mir2 player from euro days and continue to play every now and then, when time allows. I’ve recently been playing a new Mir2 server and was talking to one of the guys in my guild about how we can record and share boss drops with the rest of the guild. We’ve previously done this using excel, not exactly complicated, and easy to do but I’ve been working with PowerBi in my professional life and thought maybe it would be a fun little project to create a dashboard specifically for this, maybe a bit overkill but I thought it would make for some good practice and will help me develop my skills further.
As you can imagine, the result was a simple dashboard which allows the user to filter items by level, class and item type. It also allows the user to view boss drops. The latter is all added manually in a spreadsheet which PBi references and then automatically updates the data model.
The reason for this post is to see if any server owners would be interested in getting our heads together to see if there are other ways we can utilize PowerBi with Mir. It could be for the players, or solely for the server team, or both.
For example, in addition to the above, some other ideas could be:
- When are players mostly active? (login statistics):
- Peak hours
- Quiet hours
- What hours of the day players tend to login and out
- What is the average uptime and downtime of your server across a given time period
- An interactive player ranking view
- Not only can we see the usual info such as name, class, level but if we click on a players name could we view additional info? E.g:
- Total hours played
- Average time played per day, week, month
- Time spent at each level (if recorded?)
- Not only can we see the usual info such as name, class, level but if we click on a players name could we view additional info? E.g:
- Patches applied
- How many times in the year have patches been applied
- When have patches been applied
- What kind of patches have been applied (could categorize these into lists)
- Open bugs / issues and their status
- Pet taming info
- Undead / TS info
- Monster levels, and experience
Of course this will require that data is shared with me, or is at least accessible, so I don’t know how much of a problem this would be. I understand there will no doubt be concerns around trust but I wouldn't be doing this for self-gain. I’m not seeking financial payment, I am only interested in:
- Opportunity to practice and develop my skills
- A nice break from working with financial data and,
- Contribute something to the Mir community
Cheers,