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

Other files attached to Kentucky Analytics Platform Solution (KAPS), newest first.
File Type Posted
ATTACHMENT B - Cost Proposal Form - RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).xlsx XLSX spreadsheet
ATTACHMENT M - Acronyms - RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).pdf PDF
ATTACHMENT A - Terms and Conditions - RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).pdf PDF
ATTACHMENT C - Annual Affidavit and Other Affidavits -RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).pdf PDF
ATTACHMENT K- Proposed 1st Quarter Performance Report Card - RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).pdf PDF
ATTACHMENT L - Penalties - RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).pdf PDF
ATTACHMENT O CHFS-219V Form Version 2.7 - RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).pdf PDF
ATTACHMENT F - Mandatory Requirements Checklist RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).xlsx XLSX spreadsheet
ATTACHMENT G - Security Requirements for Vendor Cloud Hosted Systems V1.3.6 - RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).pdf PDF
ATTACHMENT H - Solution Matrix- RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).xlsx XLSX spreadsheet
ATTACHMENT P - Business Associate Agreement, Version 070623 - RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).pdf PDF
ATTACHMENT S - MITA SSA 2022 - RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).xlsx XLSX spreadsheet
ATTACHMENT T - Sources of Data - RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).xlsx XLSX spreadsheet
ATTACHMENT D - Vendors' Question Form -RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).xlsx XLSX spreadsheet
ATTACHMENT E-Personal Information Security & Breach Investigation Act-HB5- RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).pdf PDF
ATTACHMENT J Minimum Contract Deliverables - RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).pdf PDF
ATTACHMENT N - CHFS TsCs_Version 110623 - RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).pdf PDF
ATTACHMENT Q - QHI White Paper, Version 3.0.4 - RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).pdf PDF
ATTACHMENT U IAS Dashboard Examples Redacted - RFP 758 2500000171 Kentucky Analytics Platform Solution (KAPS).pdf PDF
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 NameNameViews Title
Department for Developmental and Intellectual Disabilities (DBHDID)Comprehensive Community Support DashboardTime Series (DB)
DBHDIDComprehensive Community Support DashboardGeographically (DB)
DBHDIDComprehensive Community Support DashboardProvider Volume (DB)
DBHDIDComprehensive Community Support DashboardData Narrative
DBHDIDMP/SCL Psychotropic Rx/DxData Narrative
DBHDIDMP/SCL Psychotropic Rx/DxRx-Break Down
DBHDIDMP/SCL Psychotropic Rx/DxRx-without Dx
DBHDIDMP/SCL Psychotropic Rx/DxRxDx Summary
DBHDIDMP/SCL Psychotropic Rx/Dx GRAPHS ONLYIntraclass Rx Prescribed
DBHDIDPeer Support Services in KY MedicaidData Narrative
DBHDIDPeer Support Services in KY MedicaidSUD Modifiers (DB)
DBHDIDPeer Support Services in KY MedicaidGeographically (DB)
DBHDIDPeer Support Services in KY MedicaidProvider Volume (DB)
DBHDIDPeer Support Services in KY MedicaidStory of Peer Support Services in KY Medicaid
DBHDIDPeer Support Services in KY MedicaidTime Series (DB)
DBHDIDTargeted Case Management DashboardProvider Volume (DB)
DBHDIDTargeted Case Management DashboardTime Series (DB)
DBHDIDTargeted Case Management DashboardGeographically (DB)
DBHDIDTargeted Case Management DashboardTarget Case Modifier (DB)
COVID19All Reportable Lab DataLab Map
COVID19All Reportable Lab DataLab Quality
COVID19All Reportable Lab DataMissing Data
COVID19All Reportable Lab DataLab Data
COVID19COVID Vaccine Inventories MapsJohnson & Johnson Inventory (DB)
COVID19COVID Vaccine Inventories MapsModerna Inventory (DB)
COVID19COVID Vaccine Inventories MapsProviders - Pharmacies
COVID19COVID Vaccine Inventories MapsProviders Type
COVID19COVID Vaccine Inventories MapsPfizer Inventory (DB)
COVID19COVID-19 LAB DataCovidLab Data (DB)
COVID19COVID-19 LAB DataCovidLab Data Information (DB)
COVID19COVID-19 LAB DataCovidLab Baseline Counts by Provider (DB)
COVID19COVID-19 LAB DataCovidLab Data Collection to Reporting (DB)
COVID19COVID-19 LAB DataCovidLab Data Alerts (DB)
COVID19COVID-19 LAB DataCovidLab Data PCR Only (DB)
COVID19COVID-19 LAB DataCovidLab Data Antigen Only (DB)
COVID19COVID-19 LAB DataCovidLab Baseline Counts (DB)
COVID19COVID-19 LAB DataCovidLab Data (DB)
COVID19COVID-19 LAB School ReportingCovidLab School Reporting (DB)
COVID19COVID-19 PositivityCOVID-19 Demographic Data
COVID19COVID-19 PositivityCOVID-19 7Day Rolling County Level
COVID19COVID-19 PositivityCOVID-19 7Day County Change Rate
COVID19COVID-19 PositivityCOVID-19 7Day Rolling Positivity
COVID19COVID-19 Positivity by CountyCOVID-19 7Day Rolling County Level
COVID19COVID-19 Positivity DashboardCOVID-19 7Day Rolling Positivity
COVID19COVID-19 surveillance metricsfor COVID-19 surveillance metrics (DB)
COVID19 SandboxAll Reportable Lab DataLab Data
COVID19-Kentucky Immunization Registry (KYIR)COVID Lab Dashboard with Gentrack dataGentrack Alerts (LTCF)
COVID19-KYIRCOVID Lab Dashboard with Gentrack dataGentrack Alerts (DB)
COVID19-KYIRCOVID Lab Dashboard with Gentrack dataGentrack Table View (DB)
COVID19-KYIRCOVID Vaccination DashboardMissing GeoLocators (DB)
COVID19-KYIRCOVID Vaccination DashboardState Totals Age and Race (DB)
COVID19-KYIRCOVID Vaccination DashboardCounty Totals (DB)
COVID19-KYIRCOVID Vaccination DashboardState Totals Graph (DB)
COVID19-KYIRCOVID Vaccination DashboardState Totals (DB)
COVID19-KYIRCOVID Vaccination LocationsVaccination Maps
COVID19-KYIRVaccinated in KYOut of State Residents by Zip Code
CTT SandboxCOVID-19 School Self ReportSchool Self Report Covid19 (DB)
Department for Medicaid Services (DMS)DMS-211685 - Managed Care Organization (MCO) DashboardDB - Access Trend
DMSDMS-211685 - MCO DashboardDB - Adequacy Trend
DMSDMS-211685 - MCO DashboardDB - Access
DMSDMS-211685 - MCO DashboardDB - Adequacy
DMSMCO Covid Weekly DashboardData Detail
DMSMCO Covid Weekly DashboardData Overview
DMSMCO Quarterly Report of Network Access and AdequacyDB - Analysis
DMSMCO Quarterly Report of Network Access and AdequacyDB - Access Trend
DMSMCO Quarterly Report of Network Access and AdequacyDB - Adequacy Trend
DMSMCO Quarterly Report of Network Access and AdequacyDB - Adequacy
DMSMCO Quarterly Report of Network Access and AdequacyDB - Access
DMS ReportsDMS Annual ReportBeneficiaries
DMS ReportsDMS Annual ReportProviders
DMS SandboxAzure testSheet 1
DMS SandboxDMS-211685 - MCO Dashboard_devDB-Adequacy by Claim Detail
DMS SandboxDMS-211685 - MCO Dashboard_devMCO Analysis Text
DMS SandboxDMS-211685 - MCO Dashboard_devDB-Access by County
DMS SandboxFQHC Impact SummaryFQHC Kentucky Demographics
DMS SandboxFQHC Impact SummaryFQHC Impact
DMS SandboxFQHC Impact SummaryFQHC Usage Kentucky
DMS SandboxLegislativeReport_2022Page 3
DMS SandboxLegislativeReport_2022Page 4
DMS SandboxLegislativeReport_2022Page 2
DMS SandboxLegislativeReport_2022CONTROL
DMS SandboxLegislativeReport_2022Page 1
DMS SandboxLegislativeReport_2022 - StatePage 3
DMS SandboxLegislativeReport_2022 - StatePage 4
DMS SandboxLegislativeReport_2022 - StatePage 2
DMS SandboxLegislativeReport_2022 - StatePage 1
DMS SandboxMaternal Child Health DashboardMaternal
DMS SandboxPSN 05 Network Access and AdequacyDB - Access
DMS SandboxPSN 05 Network Access and AdequacyDB - Analysis
Fee for Service (FFS)FFS_Claim_Data_DtlNarrative
FFSFFS_Claim_Data_DtlFFS_Claim_Data
Foster CareFoster CareRx Qtrly Trendline
Foster CareFoster CareStatewide Current Eligible Foster Care Beneficiaries with Psychotropic DX and RX Claims ( - )
Foster CareFoster CareDetails
Foster CareFoster Care Quality Dashboard M1-3’DCBS Map
Foster CareFoster Care Quality Dashboard M1-3’Data Narrative
Foster CareFoster Care Quality Dashboard M1-3’Comprehensive Psychiatric Evaluation
Foster CareFoster Care Quality Dashboard M1-3’Annual Preventative Services
Foster CareFoster Care Quality Dashboard M1-3’Detail for Current Beneficiaries
Foster CareFoster Care Quality Dashboard M1-3’Well Child Visits
Foster CareFoster Care Quality Dashboard M4-9Data Narrative M7-9
Foster CareFoster Care Quality Dashboard M4-9ED Utilization
Foster CareFoster Care Quality Dashboard M4-9Inpatient Utilization
Foster CareFoster Care Quality Dashboard M4-9Substance Abuse
Foster CareFoster Care Quality Dashboard M4-9Vision Screening
Foster CareFoster Care Quality Dashboard M4-9Dental Evaluation
Foster CareFoster Care Quality Dashboard M4-9Mental Health Services
Foster CareFoster Care Quality Dashboard M10-15Top 20 Medications
Foster CareFoster Care Quality Dashboard M10-15Rate of Medical Diagnosis
Foster CareFoster Care Quality Dashboard M10-15Top 10 Psychiatric Diagnosis
Foster CareQuarterly Foster Care Psychotropic ClaimsRx Intraclass Trendline
Foster CareQuarterly Foster Care Psychotropic ClaimsRX-Prescribing Provider
Foster CareQuarterly Foster Care Psychotropic ClaimsRX-without DX
Foster CareQuarterly Foster Care Psychotropic ClaimsRX Break Down
Foster CareQuarterly Foster Care Psychotropic ClaimsDCBS Quality Outcome Measures
Foster CareQuarterly Foster Care Psychotropic ClaimsRx Qtrly Trendline
Foster CareQuarterly Foster Care Psychotropic ClaimsDetails
Foster CareQuarterly Foster Care Psychotropic ClaimsStatewide 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
HEDISMetabolic Monitoring for Children and Adolescents on Antipsychotics (APM)Trendline
HEDISUse of First-Line Psychosocial Care for Children and Adolescents on AntipsychoticsTrendline
ImmunizationDPH Immunization Coverage RatesVaccination Rate 2yr (DB)
ImmunizationDPH Immunization Coverage Rates_V1Vaccination Rate 17yr (DB)
ImmunizationDPH Immunization Coverage Rates_V1Vaccination Rate 65yr (DB)
ImmunizationDPH Immunization Coverage Rates_V1Vaccination Rate 13yr (DB)
ImmunizationDPH Immunization Coverage Rates_V1Vaccination Rate 2yr (DB)
Kentucky Opioid Response Effort (KORE)KORE Program MeasureNaloxone Dispensed
KOREKORE Program MeasureTreatment Setting
KOREKORE Program MeasureGPRA Reason DS
KOREKORE Program MeasureMOUD DS
KOREKORE Program MeasureMOUD Svs
KOREKORE Program MeasureDemographic DS
KOREKORE Program MeasureProgram DS
KORENaloxone DashboardTop 10 Communities Distributed / Agency Type Breakdown Dashboard
KORENaloxone DashboardDispensed/Distributed via Community Organizations Dashboard
KORENaloxone DashboardOrganization/Agency Distribution Dashboard
KORENaloxone DashboardYOY and Map Dashboard
KORENaloxone DashboardDemographics Dashboard
KORENaloxone Dashboard-V2Percentage Distributed by Community Organizations/Agencies-old
KORENaloxone Dashboard-V2Other Agencies Distribution
KORENaloxone Dashboard-V2YOY and Map Dashboard
KORENaloxone Dashboard-V2Demographics Dashboard
KORENaloxone Dashboard-V3Dispensed/Distributed via Community Organizations Dashboard
KORENaloxone Dashboard-V3YOY and Map Dashboard
KORENaloxone Dashboard-V3Other Agencies Distribution
KORENaloxone Dashboard-V3Demographics Dashboard
LeadershipHealth ScreeningHealth Screening
LeadershipMCO Access and AdequacyData Narrative
LeadershipMCO Access and AdequacyDB - Adequacy
LeadershipMCO Access and AdequacyDB - Analysis
LeadershipMCO Access and AdequacyDB - Access
LeadershipMCO ExpendituresData Narrative
LeadershipMCO ExpendituresPlan Expenditures (DB)
LeadershipMed Insights Opioid DependenceOpioid Dependence
LeadershipMedicaid Beneficiaries with COVID-19 VaccineCounty (DB)
LeadershipMedicaid Beneficiaries with COVID-19 VaccineMCO Trend Lines by Running Total
LeadershipMedicaid Beneficiaries with COVID-19 VaccineSingle MCO Trend Lines
LeadershipMedicaid Beneficiaries with COVID-19 VaccineData Narrative
LeadershipMedicaid Beneficiaries with COVID-19 VaccineMCO Trend Lines by Running total of % Vaccinated
LeadershipMedicaid Beneficiaries with COVID-19 VaccineRace (DB)
LeadershipMedicaid Beneficiaries with COVID-19 VaccineMCO Trend Lines by Counts
LeadershipMedicaid Enrollment DemographicsProvider Counts (DB)
LeadershipMedicaid Enrollment DemographicsDeath Information Graphic Output
LeadershipMedicaid Enrollment DemographicsEnrollment Demographics Death Trend line (DB)
LeadershipMedicaid Enrollment DemographicsEnrollment Maps (DB)
LeadershipMedicaid Enrollment DemographicsEnrollment Demographics Trendline (DB)
LeadershipMedicaid Enrollment DemographicsEnrollment Demographics (DB)
LeadershipMedicaid InsightsClaim Totals
LeadershipMedicaid InsightsTop 25 Claims by Category
LeadershipSingle Compliance MeasurementSingle Compliance Measurement
LeadershipWeekly Medicaid Enrollment DemographicsDeath Information Graphic Output
LeadershipWeekly Medicaid Enrollment DemographicsEnrollment Maps (DB)
LeadershipWeekly Medicaid Enrollment DemographicsProvider Counts (DB)
LeadershipWeekly Medicaid Enrollment DemographicsEnrollment Demographics Trendline (DB)
LeadershipWeekly Medicaid Enrollment DemographicsEnrollment Weekly Changes
LeadershipWeekly Medicaid Enrollment DemographicsEnrollment Demographics (DB)
Medicaid Medical DirectorBilling for Higher Level CodesStory of Higher Order Codes and Dx
Medicaid Medical DirectorMedicaid Dental Fee Schedule SummaryDental Claims
Medicaid Medical DirectorPreventative Screenings by MCOAnnual rate of Medical preventative services for the Medicaid Population ages 21-64
Medicaid Medical DirectorPreventative Screenings by MCOData Narrative
Medicaid Medical DirectorPreventative Screenings by MCOAnnual rate of preventative services for the Medicaid Population
Medicaid Medical DirectorPreventative Screenings by MCOAnnual rate of Dental preventative services for the Medicaid Children
Medicaid Medical DirectorTrends in Urine Drug TestingArea Dev District Map
Medicaid Medical DirectorTrends in Urine Drug TestingProvider Table
Medicaid Medical DirectorTrends in Urine Drug TestingTrendline
Medicaid WaiverMonthly Waiver EnrollmentWaiver Enrollment Detail
Medicaid WaiverMonthly Waiver EnrollmentWaiver Enrollment Claims
Medicaid WaiverMonthly Waiver EnrollmentWaiver_Enrollment_Map
Office for Children with Special Healthcare Needs (OCSHCN) SandboxOCSHCN OverviewOSHCN Healthcare (DB)
OCSHCN SandboxOCSHCN OverviewOSHCN Criteria (DB)
OCSHCN SandboxOCSHCN OverviewOSHCN Overview (DB)
Opioid Use Disorder (OUD)OUD population dashboardNAS Dx
OUDOUD population dashboardOUD Dx
OUDOUD TreatmentResidential Treatment
OUDOUD TreatmentMOUD/MAT Treatment
OUDQuality and Outcomes for Residential FacilitiesData Narrative
OUDQuality and Outcomes for Residential FacilitiesData Narrative Continued
OUDQuality and Outcomes for Residential FacilitiesMeasure 3P4: Avg LOS
OUDQuality and Outcomes for Residential FacilitiesMeasure 3R: Behavioral Health or SUD Services
OUDQuality and Outcomes for Residential FacilitiesMeasure OUD Receiving Methadone
OUDQuality and Outcomes for Residential FacilitiesMeasure Peer Support Services
OUDQuality and Outcomes for Residential FacilitiesMeasure 3Q: Overdoes and Deaths
OUDQuality and Outcomes for Residential FacilitiesMeasure 3P1: Avg Daily Census of Res. Facility
OUDQuality and Outcomes for Residential FacilitiesOutliers
OUDQuality and Outcomes for Residential FacilitiesMeasure 3P: Beneficiaries at Res. Facility
Reportable LabsAll Reportable Lab DataLab Quality
Reportable LabsAll Reportable Lab DataMissing Data
Reportable LabsAll Reportable Lab DataLab Map
Reportable LabsAll Reportable Lab DataLab Data
State Lab SandboxDPH-231891 - HepC RNA Positivity DashboardData Narrative
State Lab SandboxDPH-231891 - HepC RNA Positivity DashboardFacility Overview
State Lab SandboxDPH-231891 - HepC RNA Positivity DashboardPositivity Rates (based on tests) by County
State Lab SandboxDPH-231891 - HepC RNA Positivity DashboardTests Over Time
State Lab SandboxState LabState Lab (DB)
VaccinationQuarterly DMS Immunization AnalysisProviders of Adolescent Vaccines by Quarter
VaccinationQuarterly Vaccine Dashboard for ChildrenTrendline for Child Vaccination
VaccinationYearly Immunization AnalysisTrendline 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 .