Running a community is a lot of work. Keeping up with community interactions is also a lot of work. I built a Power BI Dashboard for the Foodie Community to share with fellow community owners.
Running a community is a time-consuming task and it's often hard to find the time to just get in any interaction with the community when you are running contests, reviewing content and trying to continue and encourage engagement.
Reporting and monitoring the blockchain for your particular community is something that you need to do but I found it to be a very manual task. I've written scripts to pull data and such but that method is still lacking. I also wanted something that I could quickly visualize and even share with the community itself.
I use Power BI at work so why not here. I ended up creating a Power BI dashboard under the Hive Community Tools repo that I'm sharing for any community owner to use. You can download it from my Github.
If you have tools that others can use and you would like to share please let me know.
First off you will need a few things in order to use the dashboard:
Ok, now that you have that you will need to update the credential to your HiveSQL account. Once you've opened the .pbix go to File >> Options and Setting >> Data source settings.
Once there select the Edit Permissions and then Edit... as seen below.
Using the credentials from step two, select Database and then enter your credentials that you would have received from HiveSQL.
Then hit Save, OK, and close. Voila, you should be all set to go.
It's pretty straight forward to customize the dashboard for your community.
On the right-hand side expand the tabs for Filters, Visualizations and Fields, if they are not already. I used the community tag as a global filter on all pages, for Foodies it's 'hive-120586'. To change it to your community click on the 'category' under "Filters on all pages" and add your tag.
e.g. If I use my buddy and fellow community owner 
Under Filters on this page
Under Filters on this page
Under Filters on this page
You should be off to the races. Of course, you will want to replace the logos and update the colour scheme (Click on the View menu item to do that). The rest is up to you. Maybe rename the tabs, I realize that "FU Post Votes" may not be the best name... :-)
Please let me know if you use it for your community. I would love to see screenshots or posts on your usage. If you have updates to it to make it better please consider contributing through Github. Any questions hit me up below.
Also, if you have a tool that you use or have developed consider sharing it with the Hive community and contribute to the Hive Community Tools github.
I have a small ask. If you would like to use this Power BI dashboard for your community please support the HiveSQL proposal by 
and to continue to keep it free.
And, if you post anything related to food think about adding the Foodie tag.
Resources:
