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.
- Assist with the development and implementation of advanced data model visualizations utilizing Microsoft Power BI platform to enhance organizational decision-making capabilities and data-driven insights.
- These systemic challenges have been further highlighted by recent public health emergencies, where the lack of common data standards and interoperability significantly hampered coordinated response efforts.
- This multifaceted data ecosystem requires sophisticated integration and visualization capabilities to provide comprehensive operational oversight and fiscal accountability.
- Requires demonstrated expertise in Power BI Premium platform capabilities, advanced DAX programming, geospatial analytics, real-time dashboard development, and enterprise-level security implementation including HIPAA compliance.
- Must deliver sophisticated visualization solutions supporting disease outbreak tracking, financial compliance reporting for annual audits, facility operational metrics including census and cost analysis, and emergency response dashboards with automated alert capabilities.
- 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 
- 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.

- Contract Period/Term: 1 year
- Pre-Proposal Conference Date: November 26, 2025
- Questions/Inquires Deadline: December 01, 2025