Power BI MCHB HVIS Form 1 Dashboard

Unduplicated Count of New and Continuing Program Participants Served by MIECHV Home Visitors

This visualization presents the awardee-level data reported on new and continuing program participants as a stacked bar chart for the selected fiscal years, grouped by the participant type.

Each participant type shows individual stacked bars for the reported fiscal year. The cumulative total of the newly enrolled and continuing participants is above each individual stacked bar.

This visualization can be filtered by the reporting fiscal year, state, and participant type. State filter is a single select and it gives an ability to filter the data for different states. On hovering over the stacks of the stacked bar chart, the tooltip displays the reporting fiscal year, participant type and the number of participants specific to the participant type.

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

Unduplicated Count of Households Served by MIECHV Home Visitors

This visualization presents awardee-level data reported on newly enrolled and continuing households as a stacked bar chart for the selected fiscal years. 

Each fiscal year shows individual stacked bars the cumulative total of the newly enrolled and continuing households for each fiscal year is above each individual stacked bar.

This visualization can be filtered by the reporting fiscal year, State. State filter is a single select and it gives an ability to filter the data for different states. When hovering over the stacks of the stacked bar chart, the tooltip displays the reporting fiscal year and the count of the newly enrolled or continuing households.

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

Participants by Ethnicity

This visualization presents awardee-level data reported on participant ethnicity. Each ethnicity is represented by an individual bar graph and grouped by the participant type for the reporting fiscal years selected. A radio button option to show/hide the national average can be selected to display the national average trend lines of the respective participant ethnicities along with the bar graph. 

The percentage of the participants in each category is presented above each individual bar in the graph.

This visualization can be filtered by the reporting fiscal year, state, participant type. State filter is a single select and it gives an ability to filter the data for different states. When hovering over the bar chart, the tooltip displays the reporting fiscal year, participant type, ethnicity and the number of participants specific to the participant type and ethnicity. When hovering over the trend line, the tooltip displays the reporting fiscal year, participant type, ethnicity and the national average percentage of participants specific to the participant type and ethnicity.

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

Participants by Race

This visualization presents awardee-level data reported on participant race. Each race is represented by an individual bar graph and grouped by the participant type for the reporting fiscal years selected. A radio button option to show/hide the national average can be selected to display the national average trend lines of the respective participant races along with the bar graph. 

The percentage of the participants in each group is presented above each individual bar in the graph.

This visualization can be filtered by the reporting fiscal year, state, and the participant type. State filter is a single select and it gives an ability to filter the data for different states. When hovering over the bar chart, the tooltip displays the reporting fiscal year, participant type, race, and number of participants specific to the participant type and race along with the percentage of the participants. When hovering over the trend line, the tooltip displays the reporting fiscal year, participant type, race and the national average percentage of participants specific to the participant type and race.

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

Participants by Education Attainment

This visualization presents awardee-level data reported on the level of education achieved by the participants. Each level of education is represented by an individual bar graph and grouped by the participant type for the reporting fiscal years selected. A radio button option to show/hide the national average can be selected to display the national average trend lines of the respective participant education level along with the bar graph. 

The percentage of the participants by education attainment in each category is presented above each individual bar in the graph.

This visualization can be filtered by the reporting fiscal year, state, and the participant type. State filter is a single select and it gives an ability to filter the data for different states. When hovering over the bar chart, the tooltip displays the reporting fiscal year, participant type, education attainment and the number of participants specific to the participant type and education attained along with the percentage of the participants. When hovering over the trend line, the tooltip displays the reporting fiscal year, participant type, education attainment and the national average percentage of participants specific to the participant type and education attained.

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

Adult Participants by Housing Status

This visualization presents awardee-level data reported on the housing status of the participants. Each state of housing is represented by an individual bar graph and grouped by the participant type for the reporting fiscal years selected. A radio button option to show/hide the national average can be selected to display the national average trend lines of the respective participant housing status along with the bar graph. 

The percentage of the adult participants by housing status in each category is presented above each individual bar in the graph.

This visualization can be filtered by the reporting fiscal year, state, and the participant type. State filter is a single select and it gives an ability to filter the data for different states. When hovering over the bar chart, the tooltip displays the fiscal year, participant type, housing status and the number of participants in each category of the housing status. The housing status details provides the number of participants in each category of the housing status types. When hovering over the trend line, the tooltip displays the reporting fiscal year, participant type, housing status type and the national average percentage of the participants specific to the participant type and housing status type.

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

Household Income in Relation to Federal Poverty Guidelines

This visualization presents awardee-level data reported on the income levels with respect to the federal poverty guidelines of households. The levels of income are represented in percentages with how they compare to the federal poverty guidelines. Each level of income is represented by an individual bar graph and grouped by the reporting fiscal years selected. A radio button option to show/hide the national average can be selected to display the national average trend lines of the household income level along with the bar graph. 

The percentage of the participants in each category is presented above each individual bar in the graph.

This visualization can be filtered by the reporting fiscal year and state. State filter is a single select and it gives an ability to filter the data for different states.  When hovering over the bar chart, the tooltip displays the reporting fiscal year and the number of households specific to the income levels. When hovering over the trend line, the tooltip displays the reporting fiscal year and the national average percentage of households specific to the income levels.

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

Households by Priority Population

This visualization presents awardee-level data reported on the households of different priority population characteristics. Each category of the priority population category is represented by an individual bar graph and grouped by columns which determine whether the households in the program fall under the sub-category (Yes/No columns) for the reporting fiscal years selected. A radio button option to show/hide the national average can be selected to display the national average trend lines of the respective priority population category for the households along with the bar graph. 

The percentage of the participants in each category is presented above each individual bar in the graph.

This visualization can be filtered by the reporting fiscal year, state, and the priority population category. State filter is a single select and it gives an ability to filter the data for different states.  When hovering over the bar charts, the tooltip displays the reporting fiscal year, priority population category, priority population sub-category and the number of households specific to the priority population category and sub-category. When hovering over the trend line, the tooltip displays the reporting fiscal year, priority population category, sub-category and the national average percentage for the households specific to the priority population category and sub-category.

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

Home Visits

This visualization presents awardee-level data reported on the number of home visits. 

The total number of home visits for each fiscal year is present above each individual bar in the graph.

This visualization can be filtered by the reporting fiscal year, state, and model/modality category. State filter is a single select and it gives an ability to filter the data for different states. The Model/Modality filter is a sing select and it gives the further breakdown of all the models from reporting fiscal year 2024. When hovering over the bar chart, the tooltip displays the reporting fiscal year and the number of home visits for the organization.

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

Family Engagement by Households

This visualization presents awardee-level data reported on the different types of family engagements (household typed) by households. Each type of the household is represented by an individual bar graph for the reporting fiscal years selected. A radio button option to show/hide the national average can be selected to display the national average trend lines of the respective household types by household specific to the fiscal year along with the bar graph. 

The percentage of the households in each category is presented above each individual bar in the graph.

This visualization can be filtered by the reporting fiscal year and state. State filter is a single select and it gives an ability to filter the data for different states. When hovering over the bar chart, the tooltip displays the reporting fiscal year, household type and the number of households specific to the household type. When hovering over the trend line, the tooltip displays the reporting fiscal year, household type and the national average percentage of the households specific to the household type.

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

Unduplicated Count of Households by Evidence Based Home Visiting Model or Promising Approach

This visualization presents awardee-level data reported on different types of evidence-based home visiting models and promising approaches for households. Each model/promising approach is represented by an individual stacked bar graph for the reporting fiscal years selected. 

Each Home Visiting Model shows individual stacked bars for the reported fiscal year. The cumulative total of the newly enrolled and continuing households is above each individual stacked bar.

This visualization can be filtered by the reporting fiscal year and state. State filter is a single select and it gives an ability to filter the data for different states. When hovering over the stacks of the stacked bar chart, the tooltip displays the reporting fiscal year, Home Visiting Model or Promising Approach and the number of households specific to the participant type.

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

Participants by Type of Health Insurance Coverage

This visualization presents awardee-level data reported on the type of health insurance coverage of the participants. Each type of health insurance coverage is represented by an individual bar graph and grouped by the participant type for the reporting fiscal years selected. A radio button option to show/hide the national average can be selected to display the national average trend lines of the respective participant health insurance coverage along with the bar graph. 

The percentage of the participants in each category is presented above each individual bar in the graph.

This visualization can be filtered by the reporting fiscal year, state, and the participant type. State filter is a single select and it gives an ability to filter the data for different states. When hovering over the bar chart, the tooltip displays the reporting fiscal year, participant type, health insurance coverage and number of participants specific to the participant type and their health insurance coverage. When hovering over the trend line, the tooltip displays the reporting fiscal year, participant type, health insurance coverage and the national average percentage of the participants specific to the participant type and their health insurance coverage.

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

Index Children by Usual Source of Medical Care

This visualization presents the awardee-level data reported on index child by usual source of medical care. Each source of medical care is represented by an individual bar graph and grouped by the Participant Type (Female Index, Male Index and All Index) for the Reporting fiscal years selected. A radio button option to show/hide the National Average can be selected to display the national average trend lines of the source of medical care for the respective participant type (Female Index, Male Index and All Index) along with the bar graph. 

The percentage of the participants (Female Index, Male Index and All Index) in each source of medical care category is present above each individual bar in the graph.

This visualization can be filtered by the reporting fiscal year, organization, state, and the participant type. State filter is a single select and it gives an ability to filter the data for different states. When hovering over the bar chart, the tooltip displays the reporting fiscal year, participant type, medical care and the number of participants specific to the source of medical care they receive and participant type. When hovering over the trend line, the tooltip displays the reporting fiscal year, participant type, medical care and the national average percentage of the participants specific to the source of medical care they receive and participant type.

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

Index Children by Usual Source of Dental Care by 12 Months of Age

This visualization presents awardee-level data reported on the usual source of dental care to an index child (birth – kindergarten entry. Each source of dental care is represented by an individual bar graph and grouped by the participant type (Female Index, Male Index and All Index) for the reporting fiscal years selected. A radio button option to show/hide the national average can be selected to display the national average trend lines of the source of dental care for the respective participant type (Female Index, Male Index and All Index) along with the bar graph. 

The percentage of the participants (Female Index, Male Index and All Index) in each category is presented above each individual bar in the graph.

This visualization can be filtered by the reporting fiscal year, organization, state, and the participant type. State filter is a single select and it gives an ability to filter the data for different states. When hovering over the bar chart, the tooltip displays the reporting fiscal year, participant type, dental care and the number of participants specific to the source of dental care they receive and participant type. When hovering over the trend line, the tooltip displays the reporting fiscal year, participant type, dental care and the national average percentage of the participants specific to the source of dental care they receive and participant type.

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

This visualization presents awardee-level data reported on Primary Language Spoken at Home. Each language is represented by an individual bar graph and grouped by the reporting fiscal years selected. A radio button option to show/hide the national average can be selected to display the national average trend lines of the respective participant languages along with the bar graph.

The percentage of the participants in each group is presented above each individual bar in the graph.

This visualization can be filtered by the reporting fiscal year and state. The State filter is a single select and it gives an ability to filter the data for different states. When hovering over the bar chart, the tooltip displays the reporting fiscal year, number, and percentage of the participants specific to the primary language spoken at home. When hovering over the trend line, the tooltip displays the reporting fiscal year and the national average percentage of primary language spoken at home.

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