Shelter Dashboard

Are you looking for a one-stop shop to view all your shelter-related data in one place? ACRE Consulting's Shelter Dashboard for Power BI does everything you want and more!

Dashboard highlights:

  • Slicers for cluster, service provider type, service provider, program type, program, country, province, city, and date range
  • A dynamic graph showing occupancy by date, with trends and anomalies detected
  • Demographic breakdowns by gender, age, citizenship, veteran status, and indigenous identity
  • An intakes page showing reason for service, origin city, origin housing type, and housing status at intake, along with a bonus slicer for intake number
  • A discharges page showing reason for discharge, destination city, destination housing type, and housing status at discharge
  • A flow-through chart showing how many clients went from homeless at intake to housed at discharge, or use other parameters to look at origin and destination city or housing type
  • An analysis of the duration clients are spending in shelters
  • Shelter demand analysis, including data from turnaways and active service restrictions
  • The ability to cross-tabulate your data on nine different dimensions, such as by looking at year-over-year or month-over-month changes, comparing different programs or service providers, or grouping data by city or cluster

Go for a Test Drive

Frequently Asked Questions

What version of HIFIS is required to use this dashboard?

This report should run on any version of HIFIS version 4.0.57 and higher.

Bonus: if you are using 4.0.60+, it will pull some data about Diversions. It's a minimal amount of information to ensure compatibility with all versions of HIFIS.

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 do I connect this dashboard to my data?

Check out our README file.

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 stay in your database and then some. Most likely, the best use for this dashboard is to refresh it once a month.

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.

Does this dashboard use any native queries?

Yes. It simply wasn't possible to build this dashboard without using one.