• Looker Data Models - Overview

    Bitfocus has built five different data models for data analysis using Looker: Coordinated Entry Analysis across a continuum Designed to work with Coordinated Entry features from Clarity Human Services Only available with standalone Looker license Client Model - Beta Similar to HMIS Performance, however does not require project enrollment to be included in the model More information in the Client Model article ...

    label_outline Looker label_outline Data Model
  • HMIS Performance Model

    The HMIS Performance model is loosely based on the HUD HMIS CSV/XML table structure and requires a project enrollment to be included in this model. There is also an automatic Enrollments Reporting Period filter to limit the amount of information searched at once. It is default set to 1 quarter, but can be easily adjusted to capture any time period desired. The HMIS Performance Model is organized into several fo...

    label_outline Looker label_outline Data Model label_outline HMIS Performance Model
  • Client Model - Beta

    Purpose Bitfocus has created the Client Model to allow for analysis across the various ways clients may come in contact with the Continuum of Care system. Clients where only an initial intake (profile screen) was done Assessments like the VI-SPDAT Enrollments Services The model is designed to give insight into: Non-HMIS analysis For those communities that utilize Clarity Human Services for purposes other than ...

    label_outline Looker label_outline Data Model label_outline Client Model
  • Data Quality Model - Releases Fall 2018

    Overview This model provides easy-to-use calculations of data quality performance for all HMIS data elements. Like the HMIS Performance Model, the Data Quality Model is based on project enrollments. For convenience, some of the dimensions from HMIS Performance are included in this model and mirror the structure of HMIS Performance.   Dimensions and Measures For most of the DQ HMIS Data Elements dimensions, the err...

    label_outline Looker label_outline Data Quality label_outline Data Model label_outline Data Quality Model
  • Reservations Model

    Overview The objective of the Reservations model is to allow reporting on information from the Reservation Management System including: Ability to see all reservation slots for all dates in the recent past or near future Ability to show which reservation slots have reservations Ability to see client data associated with reservations, including whether or not the client showed up for the reservation Previously, R...

    label_outline Attendance and Reservations label_outline Looker label_outline Attendance label_outline Reservations label_outline Data Model label_outline Reservations Model
  • System Performance Measures - In Development

    Using System Performance Measures and Homelessness Occurrences in Looker The System Performance Measures (SPM) are meant to provide a high level assessment whether a Continuum of Care (COC) is accomplishing the goals set down by the McKinney-Vento Homeless Assistance Act. Reviewing HUDs (Housing and Urban Development) System Performance Measures Introductory Guide is advised BEFORE EXPLORING the measures in Looke...

    label_outline Looker label_outline SPM label_outline System Performance Measures label_outline HMIS Performance Model
  • Client Location of Heads of Household

    HUD reports are increasingly relying on [Client Location of Head of Household] for CoC-wide reporting. Specifically this is required for: System Performance Measures (SPM) Longitudinal System Analysis (LSA) (formerly AHAR) The following are steps for developing a suggested Look for identifying Enrollments with CoC issues. Explore - HMIS Performance model Add the following fields to the Look: Personal ID (Clien...

    label_outline Looker label_outline SPM label_outline System Performance Measures label_outline LSA label_outline Longitudinal System Analysis
  • Measure 1: Length of Time Homeless

    The most complicated of all the measures, give extra attention to this section to better understand how the measure works and how to trouble shoot issues/concerns.  Overview of Measure 1 "The measures are the number of clients active in the report date range along with their average and median length of time homeless across the relevant universe of projects. This includes time homeless during the report date ...

    label_outline Looker label_outline SPM label_outline System Performance Measures label_outline HMIS Performance Model
  • Measure 2: Returns to Homelessness

    Measure 2 is much easier to grasp than measure 1... relax. You've got this. Overview of Measure 2 "This measure begins with clients who exited to a permanent housing destination in the date range two years prior to the report date range. Of those clients, the measure reports on how many of them returned to homelessness as indicated in the HMIS system for up to two years after their initial exit." HUD Sys...

    label_outline Looker label_outline SPM label_outline System Performance Measures label_outline HMIS Performance Model
  • Clients with No Assessments/Enrollments

    For some agencies, a program enrollment is essential to client case management and outcomes reporting. For coordinated entry projects, having an Assessment such as the VI-SPDAT is the starting point for the coordinated entry system for the community. No assessment, no prioritization. The following suggested Look is intended to identify clients that may have missed getting a program enrollment &/or an assessmen...

    label_outline Looker label_outline Client Model
  • Archivable Clients

    A best practice for human services systems is to periodically remove or archive data for inactive clients. HIPAA standards call for removal after 6 years. The Client Model provides a method to identify inactive clients using the "Last Interaction" features of the model. For a description of the "Last Interaction" fields, refer back to the Client Model article. The following is a suggested Look ...

    label_outline Looker label_outline Client Model
  • Annual Assessment Due Look

    Annual Assessments are a required element of several Federal Partner programs. This Look will help program managers monitor progress towards collecting these data points. Explore - Data Quality Model Fields Add the following fields to the Look: [Name] (Programs folder) [Assigned Staff] (Enrollments) [Personal ID] (Clients) [Enrollment ID] (Enrollments) [Annual Assessment Status] (DQ Annual Assessments) [Targeted...

    label_outline Looker label_outline Data Quality label_outline Data Quality Model
  • Universal Data Element Look

    The Universal Data Elements are, well, universal. All HMIS projects must report on all of these elements. The following will give a simple summary of data quality problems by program and user with exceptional detail on the drill downs. Explore - Data Quality Model FieldsAdd the following fields to the Look: [Name] (Programs folder) [Assigned Staff] (Enrollments) Measure [Total Universal Data Element Errors Count...

    label_outline Looker label_outline Data Quality label_outline Data Quality Model
  • Additional Project Information Look

    To create a Look to review the new and required project descriptor elements, do the following in Looker: Explore>Project Descriptor Model Add Filters: Program Active=Active (Programs folder) Project Type Code=      (Programs) Emergency Shelter PH - Housing Only PH - Housing Services (no disability... PH - Permanent Supportive Housing (disability... PH - Rapid Re-Housing Transitional Housing Safe Haven Ad...

    label_outline Looker label_outline For System Administrators label_outline Data Standards label_outline 2017 label_outline Project Descriptor Model
  • Funding Sources Look

    To create a Look to identify projects with retired federal partner funding sources, do the following in Looker: Explore>Project Descriptor Model Add Filters: Funding Source (Program Funding Sources) RETIRED (VA Community Contract Residential Treatment) RETIRED (VA: Grant Per Diem) Program Active = Active (Programs) Add the following dimensions to the Look: Agency Name (Agencies) Name (Programs) Funding ...

    label_outline Looker label_outline Project Descriptor Model
  • Reservation Status Chart

    This article describes the steps to create a Look that summarizes the Status for Reservations. Explore - Reservations Model FieldsAdd the following fields to the Look: Reservation Section (Reservation Slots) Reservation Slot (Reservation Slots) Status (Styled) (Reservations) Pivot on Date (Reservations) FiltersAdd the following fields to the Look: Added by default: Reservation Slots Date - Adjust days as nee...

    label_outline Looker label_outline Reservations Model
  • Reservation Utilization Chart

    This article will describe creating a Look to display the utilization of reservations. Explore - Reservations Model FieldsAdd the following to the Look: Status (Reservations) Count (Reservation Slots) FiltersChange the default filter, Reservation Slots Date to: Is in the past - "1 quarters"Add additional filters as appropriate Agency Name Reservation Slot Section Service or Service Item Name Run ...

    label_outline Looker label_outline Reservations Model