Advanced PowerBI Consultant Services

The Vendor is required to provide comprehensive data transformations, modeling, and visualization using PowerBI, and provide further business intelligence consulting services.
- Data Integration and Modeling
•    Public health surveillance systems: integration of disease reporting data, epidemiological surveillance metrics, emergency preparedness indicators, and population health statistics from CDC reporting systems, NNDSS, and state health information exchanges
•    Enterprise financial systems: advanced integration with state enterprise oracle/PeopleSoft financial reporting systems including general ledger (GL), accounts payable (AP), budget modules, encumbrance tracking, contract management systems, and federal grant awards databases with real-time data refresh capabilities 
•    Healthcare facility operations: comprehensive dashboard development for eight (8) state healthcare facilities requiring complex operational metrics including daily census tracking, direct care cost analysis with cost-center allocation, overtime expenditure monitoring with trend analysis, personnel vacancy rate calculations, turnover rate analytics, cost-per-bed calculations with seasonal adjustments, and facility-specific performance indicators 
- Advanced Visualization Development Requirements
•    Geospatial analytics: advanced mapping capabilities utilizing Power BI'S spatial functions for disease outbreak tracking, vaccination campaign monitoring, and high-risk area identification with demographic overlay capabilities
•    Real-time dashboards: interactive dashboards with automated data refresh intervals not exceeding 15 minutes for critical health surveillance metrics and facility operations 
•    Financial compliance reporting: specialized visualizations supporting annual audit requirements with drill-down capabilities to transaction-level detail and automated variance analysis
•    Emergency response dashboards: crisis management visualizations capable of integrating multiple data streams during public health emergencies with automated alert systems 
- Technical Specifications and Platform Requirements
•    Power BI premium features: advanced row-level security implementation, dataflows, paginated reports, AI insights, and custom connector development
•    Data gateway configuration: on-premises data gateway management for secure enterprise system connectivity
•    DAX programming: advanced data analysis expressions (DAX) formula development for complex calculations, time intelligence functions, and statistical analysis
•    Power query: complex data transformation and cleansing operations using m language for enterprise data integration
•    API integration: restful API connectivity for real-time data ingestion from health information systems and enterprise applications
- Performance and Scalability Requirements
•    Concurrent users: minimum 500 simultaneous users across eight facilities and central office locations
•    Data volume: processing capabilities for datasets exceeding 10 million rows with sub second query response times
•    Historical data: trend analysis capabilities spanning minimum five-year historical periods with predictive modeling components.
- Provide comprehensive data visualization consulting services utilizing Microsoft Power BI Premium platform to integrate and visualize complex, multi-source datasets.

- Contract Period/Term: 1 year
- Questions/Inquires Deadline: October 08, 2025