Are you looking for a one-stop shop to view all your drop-in program data in one place? ACRE Consulting's Drop-In Dashboard for Power BI does everything you want and more!
Dashboard highlights:
Slicers for service provider type, service provider, program type, program, date range, group activity type, reason for service, group activity size, attendance, location, and more!
Key performance indicators showing total number of events, total number of attendees, number of visits per client, and breakdown by known/unknown attendees
A handy calendar showing a monthly/weekly/yearly view of all of your group activities by date
A full demographic breakdown for known clients and unknown clients, on the basis of indigenous identity, gender, age, citizenship, and veteran status
A breakdown and analysis by housing status, including a reminder to collect housing status for group activity attendees
Breakdown of number of events and number of attendees by group activity type, location, reason for service, referral locations, service provider, service provider type, and program
A trend analysis showing changes in attendance over time, allowing you to see if demand is increasing, decreasing, or remaining stable
Do I need any software to use this dashboard?Yes. You need a copy of Microsoft Power BI, or you won't be able to do anything with the file you download.
What version of HIFIS is required to use this dashboard? This report should run on any version of HIFIS version 4.0.59 and higher.
What happens if the dashboard stops working? This dashboard will be maintained into the foreseeable future. If a software update causes it to stop working, or if we find an error, we'll update the file and let you know there's a new version available, at no additional cost to you.
How long does this dashboard take to pull data? It depends on how much data is in your database, but unfortunately the answer is "pretty long." It pulls data about every client's attendance in a group activity in your database. Most likely, the best use for this dashboard is to refresh it once a week.
Does this dashboard import data or use direct query? Import. One of the reasons for this is because it is pulling and manipulating a large amount of data, and it takes a long time to compile it all.