ATTACHMENT V - IAS Dashboards and Reports - RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).xlsx
XLSX spreadsheet 25 KB Posted
- Attached to
- Kentucky Analytics Platform Solution (KAPS) State and local contract opportunity
- Solicitation number
- RFP-758-2500000171-5
- Issued by
- Kentucky
About this file
The document is an Excel attachment (Attachment V) for RFP 758 2500000171 for the Kentucky Analytics Platform Solution (KAPS), primarily involving multiple Kentucky state departments including the Department for Developmental and Intellectual Disabilities (DBHDID), Department for Medicaid Services (DMS), and various public health and social service agencies. The spreadsheet details a comprehensive dashboard and reporting system covering diverse healthcare and social service areas such as COVID-19 laboratory data, vaccine inventories, immunization registries, managed care organization (MCO) performance, foster care analytics, opioid response efforts, and healthcare effectiveness metrics.
The dashboards and reports encompass multiple data domains including COVID-19 surveillance, vaccination tracking, Medicaid enrollment demographics, healthcare provider networks, substance abuse treatment, immunization coverage rates, and specialized population health monitoring. The platform appears designed to provide sophisticated data visualization and analysis capabilities across state healthcare and social service systems, with granular reporting capabilities including geographic, time series, provider volume, and demographic breakdowns. The solution seems focused on enabling data-driven decision-making for Kentucky's public health and social service agencies by consolidating complex healthcare and social service data into accessible, actionable dashboard formats.
View the file
Other files for this state and local contract opportunity
Show all 19
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Workbook Utilization_data
| Attachent V - IAS Dashboards and Report - RFP 758 2500000171 Kentucky Analytics and Platform Solution (KAPS) | ||
| Project Name | Name | Views Title |
| Department for Developmental and Intellectual Disabilities (DBHDID) | Comprehensive Community Support Dashboard | Time Series (DB) |
| DBHDID | Comprehensive Community Support Dashboard | Geographically (DB) |
| DBHDID | Comprehensive Community Support Dashboard | Provider Volume (DB) |
| DBHDID | Comprehensive Community Support Dashboard | Data Narrative |
| DBHDID | MP/SCL Psychotropic Rx/Dx | Data Narrative |
| DBHDID | MP/SCL Psychotropic Rx/Dx | Rx-Break Down |
| DBHDID | MP/SCL Psychotropic Rx/Dx | Rx-without Dx |
| DBHDID | MP/SCL Psychotropic Rx/Dx | RxDx Summary |
| DBHDID | MP/SCL Psychotropic Rx/Dx GRAPHS ONLY | Intraclass Rx Prescribed |
| DBHDID | Peer Support Services in KY Medicaid | Data Narrative |
| DBHDID | Peer Support Services in KY Medicaid | SUD Modifiers (DB) |
| DBHDID | Peer Support Services in KY Medicaid | Geographically (DB) |
| DBHDID | Peer Support Services in KY Medicaid | Provider Volume (DB) |
| DBHDID | Peer Support Services in KY Medicaid | Story of Peer Support Services in KY Medicaid |
| DBHDID | Peer Support Services in KY Medicaid | Time Series (DB) |
| DBHDID | Targeted Case Management Dashboard | Provider Volume (DB) |
| DBHDID | Targeted Case Management Dashboard | Time Series (DB) |
| DBHDID | Targeted Case Management Dashboard | Geographically (DB) |
| DBHDID | Targeted Case Management Dashboard | Target Case Modifier (DB) |
| COVID19 | All Reportable Lab Data | Lab Map |
| COVID19 | All Reportable Lab Data | Lab Quality |
| COVID19 | All Reportable Lab Data | Missing Data |
| COVID19 | All Reportable Lab Data | Lab Data |
| COVID19 | COVID Vaccine Inventories Maps | Johnson & Johnson Inventory (DB) |
| COVID19 | COVID Vaccine Inventories Maps | Moderna Inventory (DB) |
| COVID19 | COVID Vaccine Inventories Maps | Providers - Pharmacies |
| COVID19 | COVID Vaccine Inventories Maps | Providers Type |
| COVID19 | COVID Vaccine Inventories Maps | Pfizer Inventory (DB) |
| COVID19 | COVID-19 LAB Data | CovidLab Data (DB) |
| COVID19 | COVID-19 LAB Data | CovidLab Data Information (DB) |
| COVID19 | COVID-19 LAB Data | CovidLab Baseline Counts by Provider (DB) |
| COVID19 | COVID-19 LAB Data | CovidLab Data Collection to Reporting (DB) |
| COVID19 | COVID-19 LAB Data | CovidLab Data Alerts (DB) |
| COVID19 | COVID-19 LAB Data | CovidLab Data PCR Only (DB) |
| COVID19 | COVID-19 LAB Data | CovidLab Data Antigen Only (DB) |
| COVID19 | COVID-19 LAB Data | CovidLab Baseline Counts (DB) |
| COVID19 | COVID-19 LAB Data | CovidLab Data (DB) |
| COVID19 | COVID-19 LAB School Reporting | CovidLab School Reporting (DB) |
| COVID19 | COVID-19 Positivity | COVID-19 Demographic Data |
| COVID19 | COVID-19 Positivity | COVID-19 7Day Rolling County Level |
| COVID19 | COVID-19 Positivity | COVID-19 7Day County Change Rate |
| COVID19 | COVID-19 Positivity | COVID-19 7Day Rolling Positivity |
| COVID19 | COVID-19 Positivity by County | COVID-19 7Day Rolling County Level |
| COVID19 | COVID-19 Positivity Dashboard | COVID-19 7Day Rolling Positivity |
| COVID19 | COVID-19 surveillance metrics | for COVID-19 surveillance metrics (DB) |
| COVID19 Sandbox | All Reportable Lab Data | Lab Data |
| COVID19-Kentucky Immunization Registry (KYIR) | COVID Lab Dashboard with Gentrack data | Gentrack Alerts (LTCF) |
| COVID19-KYIR | COVID Lab Dashboard with Gentrack data | Gentrack Alerts (DB) |
| COVID19-KYIR | COVID Lab Dashboard with Gentrack data | Gentrack Table View (DB) |
| COVID19-KYIR | COVID Vaccination Dashboard | Missing GeoLocators (DB) |
| COVID19-KYIR | COVID Vaccination Dashboard | State Totals Age and Race (DB) |
| COVID19-KYIR | COVID Vaccination Dashboard | County Totals (DB) |
| COVID19-KYIR | COVID Vaccination Dashboard | State Totals Graph (DB) |
| COVID19-KYIR | COVID Vaccination Dashboard | State Totals (DB) |
| COVID19-KYIR | COVID Vaccination Locations | Vaccination Maps |
| COVID19-KYIR | Vaccinated in KY | Out of State Residents by Zip Code |
| CTT Sandbox | COVID-19 School Self Report | School Self Report Covid19 (DB) |
| Department for Medicaid Services (DMS) | DMS-211685 - Managed Care Organization (MCO) Dashboard | DB - Access Trend |
| DMS | DMS-211685 - MCO Dashboard | DB - Adequacy Trend |
| DMS | DMS-211685 - MCO Dashboard | DB - Access |
| DMS | DMS-211685 - MCO Dashboard | DB - Adequacy |
| DMS | MCO Covid Weekly Dashboard | Data Detail |
| DMS | MCO Covid Weekly Dashboard | Data Overview |
| DMS | MCO Quarterly Report of Network Access and Adequacy | DB - Analysis |
| DMS | MCO Quarterly Report of Network Access and Adequacy | DB - Access Trend |
| DMS | MCO Quarterly Report of Network Access and Adequacy | DB - Adequacy Trend |
| DMS | MCO Quarterly Report of Network Access and Adequacy | DB - Adequacy |
| DMS | MCO Quarterly Report of Network Access and Adequacy | DB - Access |
| DMS Reports | DMS Annual Report | Beneficiaries |
| DMS Reports | DMS Annual Report | Providers |
| DMS Sandbox | Azure test | Sheet 1 |
| DMS Sandbox | DMS-211685 - MCO Dashboard_dev | DB-Adequacy by Claim Detail |
| DMS Sandbox | DMS-211685 - MCO Dashboard_dev | MCO Analysis Text |
| DMS Sandbox | DMS-211685 - MCO Dashboard_dev | DB-Access by County |
| DMS Sandbox | FQHC Impact Summary | FQHC Kentucky Demographics |
| DMS Sandbox | FQHC Impact Summary | FQHC Impact |
| DMS Sandbox | FQHC Impact Summary | FQHC Usage Kentucky |
| DMS Sandbox | LegislativeReport_2022 | Page 3 |
| DMS Sandbox | LegislativeReport_2022 | Page 4 |
| DMS Sandbox | LegislativeReport_2022 | Page 2 |
| DMS Sandbox | LegislativeReport_2022 | CONTROL |
| DMS Sandbox | LegislativeReport_2022 | Page 1 |
| DMS Sandbox | LegislativeReport_2022 - State | Page 3 |
| DMS Sandbox | LegislativeReport_2022 - State | Page 4 |
| DMS Sandbox | LegislativeReport_2022 - State | Page 2 |
| DMS Sandbox | LegislativeReport_2022 - State | Page 1 |
| DMS Sandbox | Maternal Child Health Dashboard | Maternal |
| DMS Sandbox | PSN 05 Network Access and Adequacy | DB - Access |
| DMS Sandbox | PSN 05 Network Access and Adequacy | DB - Analysis |
| Fee for Service (FFS) | FFS_Claim_Data_Dtl | Narrative |
| FFS | FFS_Claim_Data_Dtl | FFS_Claim_Data |
| Foster Care | Foster Care | Rx Qtrly Trendline |
| Foster Care | Foster Care | Statewide Current Eligible Foster Care Beneficiaries with Psychotropic DX and RX Claims ( - ) |
| Foster Care | Foster Care | Details |
| Foster Care | Foster Care Quality Dashboard M1-3’ | DCBS Map |
| Foster Care | Foster Care Quality Dashboard M1-3’ | Data Narrative |
| Foster Care | Foster Care Quality Dashboard M1-3’ | Comprehensive Psychiatric Evaluation |
| Foster Care | Foster Care Quality Dashboard M1-3’ | Annual Preventative Services |
| Foster Care | Foster Care Quality Dashboard M1-3’ | Detail for Current Beneficiaries |
| Foster Care | Foster Care Quality Dashboard M1-3’ | Well Child Visits |
| Foster Care | Foster Care Quality Dashboard M4-9 | Data Narrative M7-9 |
| Foster Care | Foster Care Quality Dashboard M4-9 | ED Utilization |
| Foster Care | Foster Care Quality Dashboard M4-9 | Inpatient Utilization |
| Foster Care | Foster Care Quality Dashboard M4-9 | Substance Abuse |
| Foster Care | Foster Care Quality Dashboard M4-9 | Vision Screening |
| Foster Care | Foster Care Quality Dashboard M4-9 | Dental Evaluation |
| Foster Care | Foster Care Quality Dashboard M4-9 | Mental Health Services |
| Foster Care | Foster Care Quality Dashboard M10-15 | Top 20 Medications |
| Foster Care | Foster Care Quality Dashboard M10-15 | Rate of Medical Diagnosis |
| Foster Care | Foster Care Quality Dashboard M10-15 | Top 10 Psychiatric Diagnosis |
| Foster Care | Quarterly Foster Care Psychotropic Claims | Rx Intraclass Trendline |
| Foster Care | Quarterly Foster Care Psychotropic Claims | RX-Prescribing Provider |
| Foster Care | Quarterly Foster Care Psychotropic Claims | RX-without DX |
| Foster Care | Quarterly Foster Care Psychotropic Claims | RX Break Down |
| Foster Care | Quarterly Foster Care Psychotropic Claims | DCBS Quality Outcome Measures |
| Foster Care | Quarterly Foster Care Psychotropic Claims | Rx Qtrly Trendline |
| Foster Care | Quarterly Foster Care Psychotropic Claims | Details |
| Foster Care | Quarterly Foster Care Psychotropic Claims | Statewide Current Eligible Foster Care Beneficiaries with Psychotropic DX and RX Claims ( - ) |
| Healthcare Effectiveness Data and Information Set (HEDIS) | Metabolic Monitoring for Children and Adolescents on Antipsychotics (APM) | ADD Map |
| HEDIS | Metabolic Monitoring for Children and Adolescents on Antipsychotics (APM) | Trendline |
| HEDIS | Use of First-Line Psychosocial Care for Children and Adolescents on Antipsychotics | Trendline |
| Immunization | DPH Immunization Coverage Rates | Vaccination Rate 2yr (DB) |
| Immunization | DPH Immunization Coverage Rates_V1 | Vaccination Rate 17yr (DB) |
| Immunization | DPH Immunization Coverage Rates_V1 | Vaccination Rate 65yr (DB) |
| Immunization | DPH Immunization Coverage Rates_V1 | Vaccination Rate 13yr (DB) |
| Immunization | DPH Immunization Coverage Rates_V1 | Vaccination Rate 2yr (DB) |
| Kentucky Opioid Response Effort (KORE) | KORE Program Measure | Naloxone Dispensed |
| KORE | KORE Program Measure | Treatment Setting |
| KORE | KORE Program Measure | GPRA Reason DS |
| KORE | KORE Program Measure | MOUD DS |
| KORE | KORE Program Measure | MOUD Svs |
| KORE | KORE Program Measure | Demographic DS |
| KORE | KORE Program Measure | Program DS |
| KORE | Naloxone Dashboard | Top 10 Communities Distributed / Agency Type Breakdown Dashboard |
| KORE | Naloxone Dashboard | Dispensed/Distributed via Community Organizations Dashboard |
| KORE | Naloxone Dashboard | Organization/Agency Distribution Dashboard |
| KORE | Naloxone Dashboard | YOY and Map Dashboard |
| KORE | Naloxone Dashboard | Demographics Dashboard |
| KORE | Naloxone Dashboard-V2 | Percentage Distributed by Community Organizations/Agencies-old |
| KORE | Naloxone Dashboard-V2 | Other Agencies Distribution |
| KORE | Naloxone Dashboard-V2 | YOY and Map Dashboard |
| KORE | Naloxone Dashboard-V2 | Demographics Dashboard |
| KORE | Naloxone Dashboard-V3 | Dispensed/Distributed via Community Organizations Dashboard |
| KORE | Naloxone Dashboard-V3 | YOY and Map Dashboard |
| KORE | Naloxone Dashboard-V3 | Other Agencies Distribution |
| KORE | Naloxone Dashboard-V3 | Demographics Dashboard |
| Leadership | Health Screening | Health Screening |
| Leadership | MCO Access and Adequacy | Data Narrative |
| Leadership | MCO Access and Adequacy | DB - Adequacy |
| Leadership | MCO Access and Adequacy | DB - Analysis |
| Leadership | MCO Access and Adequacy | DB - Access |
| Leadership | MCO Expenditures | Data Narrative |
| Leadership | MCO Expenditures | Plan Expenditures (DB) |
| Leadership | Med Insights Opioid Dependence | Opioid Dependence |
| Leadership | Medicaid Beneficiaries with COVID-19 Vaccine | County (DB) |
| Leadership | Medicaid Beneficiaries with COVID-19 Vaccine | MCO Trend Lines by Running Total |
| Leadership | Medicaid Beneficiaries with COVID-19 Vaccine | Single MCO Trend Lines |
| Leadership | Medicaid Beneficiaries with COVID-19 Vaccine | Data Narrative |
| Leadership | Medicaid Beneficiaries with COVID-19 Vaccine | MCO Trend Lines by Running total of % Vaccinated |
| Leadership | Medicaid Beneficiaries with COVID-19 Vaccine | Race (DB) |
| Leadership | Medicaid Beneficiaries with COVID-19 Vaccine | MCO Trend Lines by Counts |
| Leadership | Medicaid Enrollment Demographics | Provider Counts (DB) |
| Leadership | Medicaid Enrollment Demographics | Death Information Graphic Output |
| Leadership | Medicaid Enrollment Demographics | Enrollment Demographics Death Trend line (DB) |
| Leadership | Medicaid Enrollment Demographics | Enrollment Maps (DB) |
| Leadership | Medicaid Enrollment Demographics | Enrollment Demographics Trendline (DB) |
| Leadership | Medicaid Enrollment Demographics | Enrollment Demographics (DB) |
| Leadership | Medicaid Insights | Claim Totals |
| Leadership | Medicaid Insights | Top 25 Claims by Category |
| Leadership | Single Compliance Measurement | Single Compliance Measurement |
| Leadership | Weekly Medicaid Enrollment Demographics | Death Information Graphic Output |
| Leadership | Weekly Medicaid Enrollment Demographics | Enrollment Maps (DB) |
| Leadership | Weekly Medicaid Enrollment Demographics | Provider Counts (DB) |
| Leadership | Weekly Medicaid Enrollment Demographics | Enrollment Demographics Trendline (DB) |
| Leadership | Weekly Medicaid Enrollment Demographics | Enrollment Weekly Changes |
| Leadership | Weekly Medicaid Enrollment Demographics | Enrollment Demographics (DB) |
| Medicaid Medical Director | Billing for Higher Level Codes | Story of Higher Order Codes and Dx |
| Medicaid Medical Director | Medicaid Dental Fee Schedule Summary | Dental Claims |
| Medicaid Medical Director | Preventative Screenings by MCO | Annual rate of Medical preventative services for the Medicaid Population ages 21-64 |
| Medicaid Medical Director | Preventative Screenings by MCO | Data Narrative |
| Medicaid Medical Director | Preventative Screenings by MCO | Annual rate of preventative services for the Medicaid Population |
| Medicaid Medical Director | Preventative Screenings by MCO | Annual rate of Dental preventative services for the Medicaid Children |
| Medicaid Medical Director | Trends in Urine Drug Testing | Area Dev District Map |
| Medicaid Medical Director | Trends in Urine Drug Testing | Provider Table |
| Medicaid Medical Director | Trends in Urine Drug Testing | Trendline |
| Medicaid Waiver | Monthly Waiver Enrollment | Waiver Enrollment Detail |
| Medicaid Waiver | Monthly Waiver Enrollment | Waiver Enrollment Claims |
| Medicaid Waiver | Monthly Waiver Enrollment | Waiver_Enrollment_Map |
| Office for Children with Special Healthcare Needs (OCSHCN) Sandbox | OCSHCN Overview | OSHCN Healthcare (DB) |
| OCSHCN Sandbox | OCSHCN Overview | OSHCN Criteria (DB) |
| OCSHCN Sandbox | OCSHCN Overview | OSHCN Overview (DB) |
| Opioid Use Disorder (OUD) | OUD population dashboard | NAS Dx |
| OUD | OUD population dashboard | OUD Dx |
| OUD | OUD Treatment | Residential Treatment |
| OUD | OUD Treatment | MOUD/MAT Treatment |
| OUD | Quality and Outcomes for Residential Facilities | Data Narrative |
| OUD | Quality and Outcomes for Residential Facilities | Data Narrative Continued |
| OUD | Quality and Outcomes for Residential Facilities | Measure 3P4: Avg LOS |
| OUD | Quality and Outcomes for Residential Facilities | Measure 3R: Behavioral Health or SUD Services |
| OUD | Quality and Outcomes for Residential Facilities | Measure OUD Receiving Methadone |
| OUD | Quality and Outcomes for Residential Facilities | Measure Peer Support Services |
| OUD | Quality and Outcomes for Residential Facilities | Measure 3Q: Overdoes and Deaths |
| OUD | Quality and Outcomes for Residential Facilities | Measure 3P1: Avg Daily Census of Res. Facility |
| OUD | Quality and Outcomes for Residential Facilities | Outliers |
| OUD | Quality and Outcomes for Residential Facilities | Measure 3P: Beneficiaries at Res. Facility |
| Reportable Labs | All Reportable Lab Data | Lab Quality |
| Reportable Labs | All Reportable Lab Data | Missing Data |
| Reportable Labs | All Reportable Lab Data | Lab Map |
| Reportable Labs | All Reportable Lab Data | Lab Data |
| State Lab Sandbox | DPH-231891 - HepC RNA Positivity Dashboard | Data Narrative |
| State Lab Sandbox | DPH-231891 - HepC RNA Positivity Dashboard | Facility Overview |
| State Lab Sandbox | DPH-231891 - HepC RNA Positivity Dashboard | Positivity Rates (based on tests) by County |
| State Lab Sandbox | DPH-231891 - HepC RNA Positivity Dashboard | Tests Over Time |
| State Lab Sandbox | State Lab | State Lab (DB) |
| Vaccination | Quarterly DMS Immunization Analysis | Providers of Adolescent Vaccines by Quarter |
| Vaccination | Quarterly Vaccine Dashboard for Children | Trendline for Child Vaccination |
| Vaccination | Yearly Immunization Analysis | Trendline for Adolescents |
Attachment V - IAS Dashboards and Reports KAPS RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS)
&P of &N
File details come from the government source that posted it. Updated .