Power BI MCHB HVIS Form 4 Dashboard

The Form 4 Program Capacity dashboard provides information on MIECHV awardee program capacity data.

The dashboard represents data in the following categories:

• • Current Caseload
  • Capacity

Visualizations in this dashboard: This dashboard includes visualizations of quarterly caseload and capacity trends. Caseload data is shown by continuing households and newly enrolled categories using stacked bar charts. Capacity percentage data is shown using a line graph, which includes a caseload capacity benchmark represented as a dashed reference line.

Filters: The dashboard includes a multi select Fiscal Year & Quarter filter, single select state filter, and single select Activity Code filter. Organization filter will be limited to the awardee’s own organization data. Visualizations can be filtered by applying the filters which gives an ability to filter the data for different years starting from FY 2017 Quarter 4.

State filter on the dashboards represent the physical state of the awardee organization.

On hovering over the charts, the corresponding values for the visualizations are shown in the tooltips.

Current Caseload: The stacked bar chart demonstrates the number of current caseloads based on continuing households and newly enrolled categories.

Capacity: The line graph demonstrates capacity percentage and includes a caseload capacity percentage using a dashed reference line.

The Form 4 Place-Based Services dashboard provides information on MIECHV awardee place-based services data.

The dashboard represents the data in the below Views:

• • Counties
  • Zip Codes

Visualizations in this dashboard: The dashboard contains geographic visualizations of counties and zip codes of households served.

Filters: The dashboard includes a multi select Fiscal Year & Quarter filter, single select state filter, and single select Activity Code filter. Organization filter will be limited to the awardee’s own organization data. Visualizations can be filtered by applying the filters which gives an ability to filter the data for different years starting from FY 2017 Quarter 4.

State filter on the dashboards represent the physical state of the awardee organization.

On hovering over the charts, the corresponding values for the visualizations are shown in the tooltips.

Counties View: The Counties Map view shows the data based on counties of households served.

The Form 4 Family Engagement dashboard provides information on MIECHV awardee family engagement data.

The dashboard represents the data in the below categories:

• • Households
  • Attrition

Visualizations in this dashboard: This dashboard includes family engagement visualizations of quarterly household and attrition trends. Household data is shown by family engagement category type using bar charts. Attrition rate (number of households who stopped services before completion/ total number of households) is shown using a line graph.

Filters: The dashboard includes a multi select Fiscal Year & Quarter filter, single select state filter, and single select Activity Code filter. Organization filter will be limited to the awardee’s own organization data. Visualizations can be filtered by applying the filters which gives an ability to filter the data for different years starting from FY 2017 Quarter 4.

State filter on the dashboards represent the physical state of the awardee organization.

On hovering over the charts, the corresponding values for the visualizations are shown in the tooltips.

Households: The bar chart demonstrates the number of households by family engagement category type based on fiscal year and quarter.

Attrition Rate: The trend line chart demonstrates attrition rate trends based on fiscal year and quarter.

Attrition rate calculation: (Households that stopped services before completion/Total number of households)

The Form 4 Staff Recruitment and Retention dashboard provides information on MIECHV awardee staff recruitment and retention data.

Visualizations in this dashboard: This dashboard includes quarterly staffing trends using stacked bar charts representing values across the 3 staffing categories (Home Visitors, Supervisors, Other).

Filters: The dashboard includes a multi select Fiscal Year & Quarter filter, single select state filter, and single select Activity Code filter. Organization filter will be limited to the awardee’s own organization data. Visualizations can be filtered by applying the filters which gives an ability to filter the data for different years starting from FY 2017 Quarter 4.

State filter on the dashboards represent the physical state of the awardee organization.

On hovering over the charts, the corresponding values for the visualizations are shown in the tooltips.

Staff Recruitment and Retention: The stacked bar chart demonstrates FTE values across the home visitors, supervisors, and other staff categories.

Login to the EHBs (https://grants.hrsa.gov) using your HRSA EHBs username and password. You will land on the EHBs Home page.

Click Dashboards tab on the Top Menu.

The Dashboards Portal lists all the available dashboards.

A. Use the Search text box to find the “MCHB Home Visiting Information System (HVIS) Form 4.”

B. Click the eye icon in the Actions column or View Dashboard in the preview section to open the dashboard.