Application Deadline and Project Timeline
-Date Issued: January 15, 2025
-Submission Deadline: February 15, 2025
Organizational Background
BioNexus KC
The KC region is a global leader at the nexus of human and animal health, inspiring thinkers from diverse disciplines to combine their efforts for a common purpose — healthcare innovation. For 25 years, BioNexus KC has been advancing the region’s strengths in digital health, cancer research, health equity, informatics, and rare diseases.
BioNexus KC stimulates collaboration, accelerates emerging technology from concept to reality, and creates opportunities at the nexus of:
-Human and Animal Health
-Urban and Rural Health
-Healthcare and Information Technology
-Academia and Industry
-Kansas and Missouri
The organization has ten full time employees and serves over 300 partner organizations. All employees will use Salesforce.
Program: KC BioHub
The KC BioHub is a consortium of more than 100 local non-profits, institutions of higher education, local governments, startups, and industry partners within the greater Kansas City region (stretching from McPherson and Manhattan, KS to Columbia, MO) that work together to grow our regional biologics and biomanufacturing capabilities. The consortium has led the effort to designate Kansas City as a Regional Technology and Innovation Hub. The KC BioHub consortium is a program of BioNexus KC.
Program: Digital Health KC
Digital Health KC is a community initiative that seeks to build organizations and companies to solve healthcare’s biggest challenges `through the power of healthcare and information technology.
Our mission is to revolutionize healthcare delivery in the Kansas City region through cutting-edge technology and collaboration.
We explore the transformative potential of digital health solutions and our commitment to achieving positive outcomes for our community.
Project Overview and Objectives
Project Overview:
We are seeking a qualified Tableau consultant to assist in developing an interactive and visually engaging Tableau dashboard that will present the collective work of over 100 consortium partners in a transparent, accessible, and meaningful way. The dashboard should highlight key metrics and outcomes related to the consortium’s impact on specific areas related to EDA priorities—such as economic development, job creation, infrastructure improvements, etc.
This RFP invites Tableau consultants to submit proposals to build, implement, and maintain a dashboard that meets the following objectives.
Primary Objectives:
-Visualize the Data: Create a compelling and user-friendly dashboard that communicates the results of the consortium’s collective efforts.
-Public Accessibility: The dashboard must be easily accessible to the public, stakeholders, and funding agencies. It should be embeddable on our website and accessible on mobile devices.
-Alignment with EDA Priorities: The dashboard must reflect the datasets and metrics valued by the EDA, including economic development indicators, job growth, infrastructure data, and other key outcomes.
-Data Interactivity: The dashboard should allow users to interact with the data (filter, drill down, etc.) to explore various metrics and performance indicators across different regions and timeframes.
-Data Accuracy & Integrity: The data presented must be accurate, up-to-date, and aligned with the original data sources, ensuring high data integrity.
-Scalability & Maintenance: The dashboard should be designed with scalability in mind, allowing for future updates, data additions, and adjustments as needed.
Project Scope
Data Sources:
The dashboard will integrate with data stored in Salesforce Nonprofit Success Pack (NPSP) and other relevant datasets provided by BioNexus KC and the consortium partners. The consultant will be responsible for understanding the data structure, transforming it where necessary, and integrating it into the Tableau dashboard.
Key Deliverables:
Needs Assessment and Consultation:
-Work with BioNexus KC and its consortium partners to gather data requirements, understand the goals of the dashboard, and identify the key metrics and KPIs to be displayed.
Dashboard Design & Development:
-Design an intuitive and visually appealing dashboard layout.
-Develop interactive Tableau visualizations, including charts, maps, and tables, to communicate the required data.
-Incorporate best practices in data visualization to make the dashboard informative and easy to interpret.
-Ensure the dashboard is mobile-responsive and embedded on our website.
Data Integration & Automation:
-Connect the Tableau dashboard to our existing data sources (Salesforce NPSP and other datasets).
-Develop any necessary data pipelines for regular updates, ensuring that data is refreshed and accurate on a schedule.
Training and Documentation:
-Provide training for staff on how to maintain and update the dashboard as needed.
-Deliver documentation on how the dashboard was developed, how to update data, and how to troubleshoot common issues.
Post-Launch Support:
-Provide post-launch support for a period of 2 months to address any issues, updates, or improvements.
Required Qualifications and Experience
To be considered for this project, the consultant must meet the following qualifications:
-Proven experience with Tableau development, including building public-facing dashboards.
-Strong understanding of Salesforce Nonprofit Success Pack (NPSP) and its data model.
-Familiarity with Economic Development Administration (EDA) metrics and data reporting requirements is preferred but not mandatory.
-Expertise in data integration, including ETL processes, data cleansing, and connecting Tableau with external data sources (e.g., Salesforce, Excel, CSV files).
-Ability to design visually appealing and user-friendly dashboards that communicate complex data in an accessible manner.
-Experience in developing interactive data visualizations that allow users to filter and drill down on data.
-Excellent communication skills and experience working with nonprofit organizations or similar stakeholders.
-Ability to provide training and post-launch support for ongoing maintenance.
Proposal Submission Requirements
Interested consultants should submit a proposal that includes the following:
-Company Overview:
A brief description of the consulting firm, including its mission, size, and areas of expertise.
-Relevant Experience:
Examples of similar Tableau dashboard projects, particularly those in the nonprofit sector or involving data integration with Salesforce.
-Proposed Methodology:
A description of how you would approach the project, from needs assessment to final implementation. This should include timelines, milestones, and a brief outline of the proposed process.
-Cost Proposal:
A detailed breakdown of project costs, including hourly rates (if applicable), estimated time commitment for each phase, and any additional costs (e.g., for training or post-launch support).
-References:
Contact information for at least two previous clients who can speak to the consultant’s qualifications and experience with similar projects.
-Project Timeline:
A proposed timeline for the project, including key milestones and deliverables.
-Evaluation Criteria
Proposals will be evaluated based on the following criteria:
-Experience and Expertise: Demonstrated expertise in Tableau dashboard development and familiarity with nonprofit data systems, especially Salesforce.
-Proposed Approach and Methodology: Clear, detailed plan that aligns with the project’s goals and requirements.
-Cost: Competitive and transparent pricing.
-References and Past Work: Quality of references and relevant past projects.
-Timeline: Realistic and efficient timeline for project completion.
Preference will be given to vendors who have relevant industry certifications.
Preference will be given to vendors located in the Kanas City Region.
Submission Instructions
All proposals must be submitted via email to Laurie Brown at laurie@kcbiohub.org by Feb. 14, 2025. Late submissions will not be considered.
Timeline
-RFP Issued: 1/17/25
-Proposal Submission Deadline: 2/14/25
-Proposal Review Period: 2/17/25 – 2/21/25
-Consultant Selection Notification: 2/28/25
-Project Start Date: March 10, 2025
-Expected Project Completion Date: June 2025
Terms and Conditions
-BioNexus KC reserves the right to accept or reject any proposal.
-The selected consultant will be required to sign a contract that outlines the terms of the project.
-All proposals should remain valid for 90 days after the submission deadline.